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
資料庫伺服器出現ORA-00600[kcratr_nab_less_than_odr]，不能open資料庫1.open資料庫報ORA-00600[kcratr_nab_less_than_odr]SQL> ALTER DATABASE OPEN;ALTER DATABASE OPEN*第 1 行出現錯誤:ORA-00600: 內部錯誤碼, 參數: [kcratr_nab_less_than_odr], [1], [99189],[43531], [43569], [], [], [], [], [], [], []2.查看alert日誌Wed Jan 11 13:56:16 2012ALTER DATABASE OPENBeginning crash recovery of 1 threads parallel recovery started with 2 processesStarted redo scanCompleted redo scan read 54591 KB redo, 0 data blocks need recoveryErrors in file d:\dbdms\diag\rdbms\dbdms\dbdms\trace\dbdms_ora_3108.trc  (incident=818557):ORA-00600: 內部錯誤碼, 參數: [kcratr_nab_less_than_odr], [1], [99189], [43531], [43569], [], [], [], [], [], [], []Incident details in: d:\dbdms\diag\rdbms\dbdms\dbdms\incident\incdir_818557\dbdms_ora_3936_i818557.trcAborting crash recovery due to error 600Errors in file d:\dbdms\diag\rdbms\dbdms\dbdms\trace\dbdms_ora_3108.trc:ORA-00600: 內部錯誤碼, 參數: [kcratr_nab_less_than_odr], [1], [99189], [43531], [43569], [], [], [], [], [], [], []Errors in file d:\dbdms\diag\rdbms\dbdms\dbdms\trace\dbdms_ora_3108.trc:ORA-00600: 內部錯誤碼, 參數: [kcratr_nab_less_than_odr], [1], [99189], [43531], [43569], [], [], [], [], [], [], []ORA-600 signalled during: ALTER DATABASE OPEN...Trace dumping is performing id=[cdmp_20120110214555]3.查看trace檔案Trace file d:\dbdms\diag\rdbms\dbdms\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 Affinity    : 0x0x0000000000000000Memory (Avail/Total): Ph:2250M/4060M, Ph+PgF:5868M/8119MInstance name: dbdmsRedo thread mounted by this instance: 1Oracle process number: 17Windows thread id: 3108, image: ORACLE.EXE (SHAD)…………………………WARNING! Crash recovery of thread 1 seq 99189 isending at redo block 43531 but should not have ended beforeredo block 43569Incident 826550 created, dump file: d:\dbdms\diag\rdbms\dbdms\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], [], [], [], [], [], [], []通過alert和trace中的內容可以知道，資料庫需要恢複到rba到43569，但是因為某種原因執行個體恢複的時候，只能利用1 thread 99189 seq#，恢複rba到43531。從而導致資料庫無法正常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.解決方案SQL> SELECT STATUS FROM V$INSTANCE; STATUS------------MOUNTED --嘗試直接recover databaseSQL> RECOVER DATABASE ;ORA-00283: 恢複會話因錯誤而取消ORA-00264: 不要求恢複--提示不用恢複 --再開啟資料庫，還是kcratr_nab_less_than_odr錯誤警告SQL> ALTER DATABASE OPEN;ALTER DATABASE OPEN*第 1 行出現錯誤:ORA-00600: 內部錯誤碼, 參數: [kcratr_nab_less_than_odr], [1], [99189],[43531], [43569], [], [], [], [], [], [], [] --嘗試不完全恢複SQL> RECOVER DATABASE UNTIL CANCEL;ORA-10879: error signaled in parallel recovery slaveORA-01547: 警告: RECOVER 成功但 OPEN RESETLOGS 將出現如下錯誤ORA-01152: 檔案 1 沒有從過舊的備份中還原ORA-01110: 資料檔案 1: 'D:\DBDMS\DATA\SYSTEM01.DBF' --重建控制檔案SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS 'D:/1.TXT'; 資料庫已更改。 SQL> SHUTDOWN IMMEDIATE;ORA-01109: 資料庫未開啟  已經卸載資料庫。ORACLE 常式已經關閉。SQL> STARTUP NOMOUNT;ORACLE 常式已經啟動。 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 50M blocksize 512,
group 2 ('/oracle/redo1/AFC010C1/redo02a.log','/oracle/redo2/AFC010C1/redo02b.log') size 50M blocksize 512,
group 3 ('/oracle/redo1/AFC010C1/redo03a.log','/oracle/redo2/AFC010C1/redo03b.log') size 50M blocksize 512,
group 4 ('/oracle/redo1/AFC010C1/redo04a.log','/oracle/redo2/AFC010C1/redo04b.log') size 50M 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;
控制檔案已建立。 --繼續嘗試恢複SQL> RECOVER DATABASE ;完成介質恢複。SQL> ALTER DATABASE OPEN; 資料庫已更改。--open成功在這次恢複中，主要就是重建控制檔案，然後直接恢複成功，如果redo有損壞，那麼可能需要使用不完全恢複，然後使用resetlogs開啟資料庫