_allow_resetlogs_corruption的使用

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

xuansiyu

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

阅读量4.5k

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle 备份恢复

本文链接：https://blog.csdn.net/xuansiyu/article/details/22224405

Oracle 备份恢复专栏收录该内容

22 篇文章

订阅专栏

当遇到ORA-03113错误且修改lsnrctl服务对象无效时，博主选择删除ora11来解决问题。尽管网上的常见原因不适用于此情况。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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   97588504 bytes
Fixed Size                   451864 bytes
Variable Size              33554432 bytes
Database Buffers           62914560 bytes
Redo Buffers                 667648 bytes
Database mounted.
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 897612315 generated at 10/19/2005 16:54:18 needed for thread 1
ORA-00289: suggestion : /opt/oracle/oradata/conner/archive/1_160.dbf
ORA-00280: change 897612315 for thread 1 is in sequence #160

Specify log: {=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/opt/oracle/oradata/conner/system01.dbf'

ORA-01112: media recovery not started

SQL> alter database open resetlogs;

Database altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.