ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle错误之ORA-00600

oracle错误之ORA-00600

原创 Linux操作系统 作者:liqilin0429 时间:2012-03-13 10:35:41 0 删除 编辑
启动数据库时报如下错误
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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: oracle spatial
请登录后发表评论 登录
全部评论

注册时间:2010-08-13

  • 博文量
    100
  • 访问量
    189920