Alter database open fails with ORA-00600 kcratr_nab_less_than_odr

今天将灾备数据库拉起来的时候爆了一个ora-600的错误
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[48977], [415398], [415926], [], [], [], [], [], [], []

通过查mos知道有如下几种原因导致出现这个错误
There was a power failure causing logical corruption in controlfile

This Problem is caused by Storage Problem of the Database Files. 
The Subsystem (eg. SAN) crashed while the Database was open. 
The Database then crashed because the Database Files were not accessible anymore. 
This caused a lost Write into the Online RedoLogs and/or causing logical corruption in controlfile so Instance Recovery is not possible and raising the ORA-600

解决方法：
 Do cancel based reocvery, and apply 'current online redolog' manually
------------

SQL>startup mount ;

SQL>Show parameter control_files

Query 1
------------

SQL> select a.member, a.group#, b.status from v$logfile a ,v$log b where a.group#=b.group# and b.status='CURRENT' ;

Note down the name of the redo log

SQL> shutdown abort ;

Take a OS Level backup of the controlfile (This is to ensure we have a backup of current state of controlfile)

SQL> startup mount ;
SQL> recover database using backup controlfile until cancel ;

Enter location of redo log shown as current in Query 1 when prompted for recovery

Hit Enter

SQL> alter database open resetlogs ;



SQL> recover database  until cancel using backup controlfile;
ORA-00279: change 104591374629 generated at 09/28/2017 16:34:42 needed for
thread 1
ORA-00289: suggestion : /archive1/fxps_1_48977_902413745.dbf
ORA-00280: change 104591374629 for thread 1 is in sequence #48977




Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/oradata_d1/fxps/redo02.log
Log applied.
Media recovery complete.

SQL> alter database open RESETLOGS;


Database altered.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30338315/viewspace-2145580/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30338315/viewspace-2145580/