oracle错误之ORA-00600

启动数据库时报如下错误
SQL> startup
ORACLE 例程已经启动。

Total System Global Area  744910848 bytes
Fixed Size                  1374696 bytes
Variable Size             369100312 bytes
Database Buffers          369098752 bytes
Redo Buffers                5337088 bytes
数据库装载完毕。
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [17], [5379],
[5384], [], [], [], [], [], [], []

第一步：打开到OPEN状态
SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [17], [5379],
[5384], [], [], [], [], [], [], []

第二步
查看日志文件存放的路径同时查看日志信息
SQL> show parameter user

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
license_max_users                    integer     0
parallel_adaptive_multi_user         boolean     TRUE
redo_transport_user                  string
user_dump_dest                       string      d:\app\qilin\diag\rdbms\qilin\
                                                 qilin\trace
alert_qilin.log的主要内容：
Tue Mar 13 09:48:30 2012
alter database open
Beginning crash recovery of 1 threads
 parallel recovery started with 3 processes
Started redo scan
Completed redo scan
 read 21211 KB redo, 0 data blocks need recovery
Errors in file d:\app\qilin\diag\rdbms\qilin\qilin\trace\qilin_ora_5472.trc  (incident=255416):
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [17], [5379], [5384], [], [], [], [], [], [], []
Incident details in: d:\app\qilin\diag\rdbms\qilin\qilin\incident\incdir_255416\qilin_ora_5472_i255416.trc
Tue Mar 13 09:48:33 2012
Trace dumping is performing id=[cdmp_20120313094833]
Aborting crash recovery due to error 600
Errors in file d:\app\qilin\diag\rdbms\qilin\qilin\trace\qilin_ora_5472.trc:
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [17], [5379], [5384], [], [], [], [], [], [], []
Errors in file d:\app\qilin\diag\rdbms\qilin\qilin\trace\qilin_ora_5472.trc:
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [17], [5379], [5384], [], [], [], [], [], [], []
ORA-600 signalled during: alter database open...
Tue Mar 13 09:48:35 2012
Sweep [inc][255416]: completed
Sweep [inc2][255416]: completed

qilin_ora_5472.trc的主要内容：

*** 2012-03-13 09:48:31.677
Started writing zeroblks thread 1 seq 17 blocks 5379-5386

*** 2012-03-13 09:48:31.689
Completed writing zeroblks thread 1 seq 17
==== Redo read statistics for thread 1 ====
Total physical reads (from disk and memory): 22619Kb
-- Redo read_disk statistics --
Read rate (ASYNC): 21212Kb in 0.80s => 25.89 Mb/sec
Longest record: 12Kb, moves: 0/53991 (0%)
Change moves: 98/976 (10%), moved: 0Mb
Longest LWN: 837Kb, moves: 3/8046 (0%), moved: 0Mb
Last redo scn: 0x0000.0068e490 (6874256)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
WARNING! Crash recovery of thread 1 seq 17 is
ending at redo block 5379 but should not have ended before
redo block 5384
Symbol file D:\app\QiLin\product\11.2.0\dbhome_1\BIN\oracommon11.SYM does not match binary.
 Symbol TimeStamp=4bb5eaac, Module TimeStamp=0 are different
Symbol file D:\app\QiLin\product\11.2.0\dbhome_1\BIN\oraclsra11.SYM does not match binary.
 Symbol TimeStamp=4bb4cf99, Module TimeStamp=0 are different
EnumerateLoadedModules64 failed with error -1073741819
Symbol file oraclsra11.SYM does not match binary.
 Symbol TimeStamp=4bb4cf99, Module TimeStamp=0 are different
Symbol file oracommon11.SYM does not match binary.
 Symbol TimeStamp=4bb5eaac, Module TimeStamp=0 are different
Incident 255416 created, dump file: d:\app\qilin\diag\rdbms\qilin\qilin\incident\incdir_255416\qilin_ora_5472_i255416.trc
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [17], [5379], [5384], [], [], [], [], [], [], []

ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [17], [5379], [5384], [], [], [], [], [], [], []
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [17], [5379], [5384], [], [], [], [], [], [], []

通过alert和trace中的内容可以知道，数据库需要恢复到rba到5384，但是因为某种原因实例恢复的时候，只能利用1 thread 17 seq#，恢复rba到5379。从而导致数据库无法正常open

第三步 查看实例打开的状态
SQL> select status from v$instance;

STATUS
------------
MOUNTED

第四步：恢复实例并打开到OPEN状态
SQL> recover database;
ORA-00283: 恢复会话因错误而取消
ORA-00264: 不要求恢复

SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [17], [5379],
[5384], [], [], [], [], [], [], []

第五步：恢复到关闭前的状态
SQL> recover database until cancel;
ORA-10879: error signaled in parallel recovery slave
ORA-01547: 警告: RECOVER 成功但 OPEN RESETLOGS 将出现如下错误
ORA-01152: 文件 1 没有从过旧的备份中还原
ORA-01110: 数据文件 1: 'D:\APP\QILIN\ORADATA\QILIN\SYSTEM01.DBF'

第六步：创建控制文件
SQL> alter database backup controlfile to trace as 'd:/control.txt';

数据库已更改。

第七步：关闭数据并重新启动到NOMOUNT状态
SQL> shutdown abort;
ORACLE 例程已经关闭。
SQL> startup nomount;
ORACLE 例程已经启动。

Total System Global Area  744910848 bytes
Fixed Size                  1374696 bytes
Variable Size             369100312 bytes
Database Buffers          369098752 bytes
Redo Buffers                5337088 bytes

第八步：重新生成控制文件
SQL> @D:\control.sql

控制文件已创建。

第九步：恢复数据库并启动到OPEN状态
SQL> recover database;
完成介质恢复。
SQL> alter database open;

数据库已更改。

SQL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/20976446/viewspace-718411/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/20976446/viewspace-718411/