SQL> alter system set "_allow_resetlogs_corruption"=true scope=spfile;

System altered.

SQL> shutdown immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 432013312 bytes

Fixed Size 2021344 bytes

Variable Size 150997024 bytes

Database Buffers 276824064 bytes

Redo Buffers 2170880 bytes

Database mounted.

SQL> alter database open resetlogs;

Database altered.

[@more@]

ITPub博客

使用_allow_resetlogs_corruption隐藏参数跳过数据库一致性检查