ORA-00600 kcratr_nab_less_than_odr Starting Database

When a database are performing crash recovery abort with ora-00600 at openning. The error is the next;

 

 
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [2120], [54473], [54480], [], [], [], [], [], [], []

The problem is a logical corruption in the controlfile, you have perform the following steps to solve it. Please, is a good idea to take a backup.

 
SQL> startup nomount;

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

MEMBER                                GROUP#  STATUS
------------------------------------- ------- ---------
/dsk45/rman/rdo1/RMAN/redo01.rdo      2       CURRENT  
/dsk45/rman/rdo2/RMAN/redo02.rdo      2       CURRENT

SQL> shutdown abort;

SQL> startup mount;
ORACLE instance started.

Total System Global Area 5010685952 bytes
Fixed Size                  2236968 bytes
Variable Size             956304856 bytes
Database Buffers         4043309056 bytes
Redo Buffers                8835072 bytes
Database mounted.
SQL> recover database using backup controlfile until cancel ;
ORA-00279: change 35290801 generated at 07/18/2016 04:01:28 needed for thread 1
ORA-00289: suggestion :
/dsk10/rman/fra/RMAN/archivelog/2016_07_22/o1_mf_1_2120_%u_.arc
ORA-00280: change 35290801 for thread 1 is in sequence #2120

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/dsk45/rman/rdo1/RMAN/redo01.rdo
Log applied.
Media recovery complete.
SQL>  Alter database open resetlogs ;

Database altered.

SQL>

HTH – Antonio NAVARRO

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s