企业官网建设流程全解析

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 scope=spfile;

5.startu force启动，推进scn

alter system set undo_management = 'MANUAL' scope=spfile;

alter session set events '10015 trace name adjust_scn level 10';

6.重建undo
drop 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_management='auto' scope=spfile;
alter system reset "_allow_resetlogs_corruption" scope=spfile;

8.重启确认正常

参考：https://blog.51cto.com/u_11682417/11050210