缺少归档日志，ORACLE数据库恢复使用_allow_resetlogs_corruption参数

数据库版本10.2.0.2.0，要恢复到2011年备份，online备份，

恢复过程中，open的时候出现如下报错，经检查缺少备份的归档日志。

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01195: online backup of file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/oracle/P01/sapdata1/system_1/system.data1'

 

解决方法如下：

修改如下隐藏参数

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 1.2415E+10 bytes

Fixed Size 2049960 bytes

Variable Size 2751469656 bytes

Database Buffers 9646899200 bytes

Redo Buffers 14721024 bytes

Database mounted.

 

SQL> alter database open resetlogs;

lslslsalter database open resetlogs

*

ERROR at line 1:

ORA-03113: end-of-file on communication channel

 

查看当前状态

SQL> select status from v$instance;

ERROR:

ORA-03114: not connected to ORACLE

启动过程中自动断掉了，所有的oracle进程都不见了，

 

重新连接，直接startup启动成功，恢复成功，查看当前数据库状态。

SQL> select status from v$instance;

STATUS

------------

OPEN