_allow_resetlogs_corruption参数

最新推荐文章于 2024-01-04 16:02:02 发布

csdnhadoop

最新推荐文章于 2024-01-04 16:02:02 发布

阅读量921

点赞数

本文链接：https://blog.csdn.net/csdnhadoop/article/details/68593566

版权

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 6680915968 bytes
Fixed Size 2213936 bytes
Variable Size 3892316112 bytes
Database Buffers 2751463424 bytes
Redo Buffers 34922496 bytes
SQL> alter system set "_allow_resetlogs_corruption"=true scope=spfile;

System altered.

SQL> alter database mount;

Database altered.

SQL> recover database using backup controlfile until cancel;
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode.

SQL>