首页 > 数据库 > Oracle > Alter database open fails with ORA-00600 kcratr_nab_less_than_odr

Alter database open fails with ORA-00600 kcratr_nab_less_than_odr

原创 Oracle 作者:yczloveyy 时间:2017-09-29 04:34:17 0 删除 编辑
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], [], [], [], [], [], [], []

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,, b.status from v$logfile a ,v$log b where 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}
Log applied.
Media recovery complete.

SQL> alter database open RESETLOGS;

Database altered.

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录


  • 博文量
  • 访问量