ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [1498], [18713], [18720], internalerror

ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [1498], [18713], [18720], internalerror
Database Server appears ORA-00600 [kcratr_nab_less_than_odr], cannot open database 1. open DATABASE reports ORA-00600 [kcratr_nab_less_than_odr] SQL> ALTER DATABASE OPEN; ALTER DATABASE OPEN * 1st Line Error: ORA-00600: Internal error code, parameter: [kcratr_nab_less_than_odr], [1], [99189], [43531], [43569], [], [], [], [], [], [], [] 2. view alert logs Wed Jan 11 13:56:16 2012 alter database OPENBeginning crash recovery of 1 threads parallel recovery started with 2 processesStarte D redo scanCompleted redo scan read 54591 KB redo, 0 data blocks need recoveryErrors in file d: \ dbdms \ diag \ rdbms \ dbdms \ trace \ dbdms_ora_3108.trc (incident = 818557 ): ORA-00600: Internal error code, parameter: [kcratr_nab_less_than_odr], [1], [99189], [43531], [43569], [], [], [], [], [], [], [], [], [] Incident details in: d: \ dbdms \ diag \ rdbms \ dbdms \ incident \ incdir_818557 \ dbdms_ora_3936_i818557.trcAborting crcove Ry due to error 600 Errors in file d: \ dbdms \ diag \ rdbms \ dbdms \ trace \ dbdms_ora_3108.trc: ORA-00600: Internal error code, parameter: [kcratr_nab_less_than_odr], [1], [99189], [43531], [43569], [], [], [], [], [], [], [] Errors in file d: \ dbdms \ diag \ rdbms \ dbdms \ trace \ dbdms_ora_3108.trc: ORA-00600: Internal error code, parameter: [kcratr_nab_less_than_odr], [1], [99189], [43531], [43569], [], [], [], [], [], [], [] ORA-600 signalled d Uring: alter database open... trace dumping is refreshing Ming id = [cdmp_20110214555] 3. view trace file d: \ dbdms \ diag \ rdbms \ dbdms \ Trace \ dbdms_ora_3108.trcOracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionWith the Partitioning, OLAP, data Mining and Real Application Testing optionsWindows NT Version V6.1 Service Pack 1 CPU: 2-type 8664, 2 Physical CoresProcess Affi Nity: 0x0x0000000000000000Memory (Avail/Total): Ph: 2250 M/4060 M, Ph + PgF: 5868 M/8119 MInstance name: dbdmsRedo thread mounted by this instance: 1 Oracle process number: 17 Windows thread id: 3108, image: ORACLE. EXE (SHAD ).............................. WARNING! Crash recovery of thread 1 seq 99189 isending at redo block 43531 but shocould not have ended beforeredo block 43569 Incident 826550 created, dump file: d: \ dbdms \ diag \ rdbms \ dbdms \ incident \ incdir_826550 \ dbdms_ora_3108_i826550.trcORA-00600 :??????, ??: [Kcratr_nab_less_than_odr], [1], [99189], [43531], [43569], [], [], [], [], [], [], [], [] ORA-00600 :??????, ??: [Kcratr_nab_less_than_odr], [1], [99189], [43531], [43569], [], [], [], [], [], [], [], [] ORA-00600 :??????, ??: [Kcratr_nab_less_than_odr], [1], [99189], [43531], [43569], [], [], [], [], [], [], [], [] You can see from alert and trace that the database needs to be restored to rba to 43569, but for some reason, when the instance is recovered, it can only use 1 thread 99189 seq #, restore rba to 43531. As a result, the Database cannot be normally openThis Problem is caused by Storage Problem of the Database Files. the Subsystem (eg. SAN) crashed while the Database was open. the Database then crashed since the Database Files were not accessible anymore. this caused a lost Write into the Online RedoLogs and so Instance Recovery is not possible and raising the ORA-600.4. solution: SQL> SELECT STATUS FROM V $ INSTANCE; STATUS---MOUNT ED -- try to recover databaseSQL> recover database directly; ORA-00283: recover session cancel ORA-00264 due to error: recovery not required -- prompt no recovery -- Open DATABASE again, or kcratr_nab_less_than_odr error warning SQL> ALTER DATABASE OPEN; ALTER DATABASE OPEN * 1st Line Error: ORA-00600: Internal error code, parameter: [kcratr_nab_less_than_odr], [1], [99189], [43531], [43569], [], [], [], [], [], [], [] -- try not to completely restore SQL> RECOVER DATABASE UNTIL CANCEL; ORA-10879: error signaled in parallel recovery slaveORA-015 47: Warning: Successful RECOVER but open resetlogs will see the following error ORA-01152: File 1 has not restored the ORA-01110 from an older backup: Data File 1: 'd: \ DBDMS \ DATA \ SYSTEM01.DBF '-- recreate the control file SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS 'd:/1. TXT '; the database has been changed. SQL> SHUTDOWN IMMEDIATE; ORA-01109: the database is not open and has been detached. The ORACLE routine has been disabled. SQL> STARTUP NOMOUNT; the ORACLE routine has been started. Total System Global Area 417546240 bytesFixed Size 2176328 bytesVariable Size 268438200 bytesDatabase Buffers 138412032 bytesRedo Buffers 8519680 bytesSQL> create controlfile reuse database 'afc010c1 'noresetlogs noarchivelog
Maxlogfiles 16
Maxlogmembers 4
Maxdatafiles 100
Maxinstances 8
# Maxloghistory 18688
Logfile
Group 1 ('/oracle/redo1/AFC010C1/redo01a. log','/oracle/redo2/AFC010C1/redo01b. log') size 50 M blocksize 512,
Group 2 ('/oracle/redo1/AFC010C1/redo02a. log','/oracle/redo2/AFC010C1/redo02b. log') size 50 M blocksize 512,
Group 3 ('/oracle/redo1/AFC010C1/redo03a. log','/oracle/redo2/AFC010C1/redo03b. log') size 50 M blocksize 512,
Group 4 ('/oracle/redo1/AFC010C1/redo04a. log','/oracle/redo2/AFC010C1/redo04b. log') size 50 M blocksize 512
DATAFILE
'/Oracle/data1/AFC010C1/afc_biz_data01.dbf ',
'/Oracle/data1/AFC010C1/afc_log_data01.dbf ',
'/Oracle/data1/AFC010C1/afc_txn_data01.dbf ',
'/Oracle/data1/AFC010C1/afc_cd_data01.dbf ',
'/Oracle/data1/AFC010C1/afc_rpt_data01.dbf ',
'/Oracle/data1/AFC010C1/afc_ws_data01.dbf ',
'/Oracle/data1/AFC010C1/sysaux01.dbf ',
'/Oracle/data1/AFC010C1/afc_eod_data01.dbf ',
'/Oracle/data1/AFC010C1/afc_syscd_data01.dbf ',
'/Oracle/data1/AFC010C1/dbmgr_data01.dbf ',
'/Oracle/data1/AFC010C1/system01.dbf ',
'/Oracle/data2/AFC010C1/afc_biz_indx01.dbf ',
'/Oracle/data2/AFC010C1/afc_cd_indx01.dbf ',
'/Oracle/data2/AFC010C1/afc_eod_indx01.dbf ',
'/Oracle/data2/AFC010C1/afc_log_indx01.dbf ',
'/Oracle/data2/AFC010C1/afc_rpt_indx01.dbf ',
'/Oracle/data2/AFC010C1/afc_syscd_indx01.dbf ',
'/Oracle/data2/AFC010C1/afc_txn_indx01.dbf ',
'/Oracle/data2/AFC010C1/afc_ws_indx01.dbf ',
'/Oracle/data2/AFC010C1/dbmgr_indx01.dbf ',
'/Oracle/data2/AFC010C1/undotbs01.dbf ',
'/Oracle/data2/AFC010C1/users01.dbf'
Character set zhs16gbk;
The control file has been created. -- Continue to restore SQL> RECOVER DATABASE; restore media. SQL> ALTER DATABASE OPEN; the DATABASE has been changed. -- Open success in this recovery, it is mainly to re-create the control file, and then directly restore success. If the redo is damaged, Incomplete recovery may be required, and then use resetlogs to open the database.