缺少歸檔日誌，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