强启库后恢复

1.数据库突然宕机启动提示ORA-01589:要打开数据库则必须使用RESETLoGs或选项。2.尝试alter database open resetlogs;第1行出现错误:ORA-01113:文件1需要介质恢复0RA-01110:数据文件1:D:APPADMINISTRATORNORADATANORCLNSYSTEM01.DBF’3.recover无效同时出现ora-600错误4.启动隐藏参数alter system set “_allow_resetlogs_corruption”true scopespfile;5.startu force启动推进scnalter system set undo_management MANUAL scopespfile;alter session set events 10015 trace name adjust_scn level 10;6.重建undodrop tablespace UNDOTBS1 including contents and datafiles;create undo tablespace UNDOTBS1 datafile D:\app\Administrator\oradata\orcl\undotbs01.dbf size 1G;7.恢复参数文件alter system set undo_managementauto scopespfile;alter system reset _allow_resetlogs_corruption scopespfile;8.重启确认正常参考https://blog.51cto.com/u_11682417/11050210