Ora-00600:internal error code, arguments: [Kcratr_nab_less_than_odr], [1], [1498], [18713], [18720]

Database server appears ORA-00600[KCRATR_NAB_LESS_THAN_ODR]. Cannot open database 1.open database report ora-00600[kcratr_nab_less_than_odr]sql> ALTER DB OPEN; ALTER DATABASE open* Error 1th: ORA-00600: Internal error code, number of references: [KCRATR_NAB_LESS_THAN_ODR], [1], [99189],[43531], [43569], [], [], [] , [], [], [], []2. View Alert Log Wed Jan 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 recovery Errors in File d:\dbdms\diag\rdbms\dbdms\dbdms\trace\dbdms_ora_3108.trc   (incident=818557): ORA-00600: Internal error code, References: [KCRATR_NAB_LESS_THAN_ODR], [1], [99189], [43531], [43569], [], [], [], [], [], [], []incident details In:d:\dbdms\di Ag\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: Internal error code, number of references: [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: Internal error code, number of references: [KCR ATR_NAB_LESS_THAN_ODR], [1], [99189], [43531], [43569], [], [], [], [], [], [], []ora-600 signalled During:alter DATABASE OPEN ... Trace dumping is performing id=[cdmp_20120110214555]3. viewing trace files 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       &NBS P        : 2-type 8664, 2 physical coresprocess Affinity    : 0x0x0000000000000000memory (A Vail/total): ph:2250m/4060m, ph+pgf:5868m/8119minstance name:dbdmsredo thread mounted by this instance:1oracle process n Umber:17windows thread id:3108, image:oracle. EXE (SHAD) ........ .............. warning! Crash Recovery of thread 1 seq 99189 isending at redo block 43531 buT should not has 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], [], [], [], [], [], [], [] through the contents of alert and trace to know that the database needs to be restored to RBA to 43569, but for some reason the instance recovers, only 1 thread 99189 seq# can be used to restore RBA to 43531.

This causes the database to not function properly openthis problem is caused by Storage problem of the databases files. the Subsystem (eg. SAN) crashed while the database is open. the database then crashed since the database Files were not accessible anym Ore. this caused a lost Write into the Online redologs and so Instance Recovery are not possible and raising the ORA-6 00.4. Workaround sql> SELECT STATUS from V$instance; status------------mounted --try Direct recover databasesql> RECOVER database; ORA-00283: Recovery session canceled due to an error ORA-00264: No recovery required--prompts to not restore  --and open the databases. or KCRATR_NAB_LESS_THAN_ODR error warning sql> ALTER DATABASE OPEN; ALTER DATABASE open* Error 1th: ORA-00600: Internal error code, number of references: [KCRATR_NAB_LESS_THAN_ODR], [1], [99189],[43531], [43569], [], [], [] , [], [], [], [] --try not to completely recover sql> RECOVER DATABASE UNTIL cancel;ora-10879:error signaled in parallel recovery Slaveo RA-01547: Warning: RECOVER successful but OPEN Resetlogs will appear for example the following error ORA-01152: File 1 did not restore ORA-01110 from an older backup: Data file 1: ' D:\DBDMS\DATA\SYSTEM01. DBF '  --rebuild control file sql> ALTER DatabaSE BACKUP controlfile to TRACE as ' d:/1.txt ';  database has changed.  SQL> SHUTDOWN immediate;ora-01109: Database is not open    database is unloaded.

The ORACLE routine has been closed. Sql> startup Nomount;oracle Routine has been started.

Total System Global area 417546240 bytesfixed size 2176328 bytesvariable size 268438200 byte Sdatabase buffers 138412032 Bytesredo buffers 8519680 bytessql> create controlfile Reuse Databa Se ' 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;
The control file has been created. --Continue to try to restore sql> RECOVER DATABASE; Media recovery. sql> ALTER DATABASE OPEN; The database has changed.

--open success in this recovery, the main is to rebuild the control files, and then directly restore success. Assuming that the redo is damaged, it may be necessary to use not to completely recover. Then use Resetlogs to open the database

Ora-00600:internal error code, arguments: [Kcratr_nab_less_than_odr], [1], [1498], [18713], [18720]