ORA-00600 [kcratr_nab_less_than_odr]

ORA-00600 [kcratr_nab_less_than_odr]

[Note] recently, the entire IT system was a bit lucky. First, there was a power outage in the data center. Recently, another accident occurred. The hard disk of a virtual machine broke down, resulting in the failure of all applications and databases installed on the virtual machine. After some hard work, the virtual machine finally got up, but an error was reported during startup:

SQL> startup
Oracle instance started.

Total System Global Area 6747725824 bytes
Fixed Size 2213976 bytes
Variable Size 4362078120 bytes
Database Buffers 2348810240 bytes
Redo Buffers 34623488 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [6674], [13272], [13337], [], [], [], [], [], [], [], [], []
 

The alert alarm log is as follows:

Recovery of Online Redo Log: Thread 1 Group 2 Seq 6674 Reading mem 0
Mem #0:/oracle/oradata/klekpj/redo02.log
Media Recovery Complete (klekpj)
Completed: alter database recover if needed
Start
Tue Jun 23 16:11:45 2015
Alter database open
Beginning crash recovery of 1 threads
Parallel recovery started with 7 processes
Started redo scan
Completed redo scan
Read 1900 KB redo, 0 data blocks need recovery
Errors in file/oracle/diag/rdbms/klekpj/trace/klekpj_ora_19307.trc (incident = 9755 ):
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [6674], [13272], [13337], [], [], [], [], [], [], [], [], []
Incident details in:/oracle/diag/rdbms/klekpj/incident/incdir_9755/klekpj_ora_19307_i9755.trc
Aborting crash recovery due to error 600
Errors in file/oracle/diag/rdbms/klekpj/trace/klekpj_ora_19307.trc:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [6674], [13272], [13337], [], [], [], [], [], [], [], [], []
Errors in file/oracle/diag/rdbms/klekpj/trace/klekpj_ora_19307.trc:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [6674], [13272], [13337], [], [], [], [], [], [], [], [], [
 

Solution:

SQL> startup mount;
ORACLE instance started.

Total System Global Area 6747725824 bytes
Fixed Size 2213976 bytes
Variable Size 4362078120 bytes
Database Buffers 2348810240 bytes
Redo Buffers 34623488 bytes
Database mounted.
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1974040004 generated at 06/10/2015 16:04:16 needed for thread
1
ORA-00289: suggestion:/oracle/arch/ipv6674_829596422.dbf
ORA-00280: change 1974040004 for thread 1 is in sequence #6674

Specify log: {= suggested | filename | AUTO | CANCEL}
CANCEL
Media recovery canceled.
SQL> alter database open resetlogs;

Database altered.

The database is successfully opened.
 

Cause analysis:

Alter database recover database using backup controlfile until cancel
Media Recovery Start
Started logmerger process
Parallel Media Recovery started with 8 slaves
ORA-279 signalled during: alter database recover database using backup controlfile until cancel...
Tue Jun 23 16:56:20 2015
ALTER DATABASE RECOVER CANCEL
Media Recovery Canceled
Completed: ALTER DATABASE RECOVER CANCEL
Alter database open resetlogs
Archived Log entry 6334 added for thread 1 sequence 6673 ID 0xf5f2c983 dest 1:
Tue Jun 23 16:56:31 2015
Archived Log entry 6335 added for thread 1 sequence 6674 ID 0xf5f2c983 dest 1:
Archived Log entry 6336 added for thread 1 sequence 6672 ID 0xf5f2c983 dest 1:
RESETLOGS after incomplete recovery until change 1974040004
 

LGWR fails to write the online redolog file because of an abnormal power failure on the server. Of course, the data is not written into the data file. Exception recovery is required when the database is started next time, but this REDO information cannot be found when it is read from the online redolog. Therefore, an error is reported when it is opened.

ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [6674], [13272], [13337], [], [], [], [], [], [], [], [], []

When data is restored, it must be restored from the onine redo log 1seq #6674 log, from 13272 to 13337.