日期:2014-05-17  浏览次数:20928 次

求助,关于ORA-00600的内部错误
alert_sid.log中部分内容:
alter database open
Beginning crash recovery of 1 threads
 parallel recovery started with 2 processes
Started redo scan
Completed redo scan
 read 54591 KB redo, 0 data blocks need recovery
Errors in file d:\dbdms\diag\rdbms\dbdms\dbdms\trace\dbdms_ora_1724.trc (incident=810548):
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [99189], [43531], [43569], [], [], [], [], [], [], []
Incident details in: d:\dbdms\diag\rdbms\dbdms\dbdms\incident\incdir_810548\dbdms_ora_1724_i810548.trc
Tue Jan 10 21:24:53 2012
Trace dumping is performing id=[cdmp_20120110212453]
Aborting crash recovery due to error 600
Errors in file d:\dbdms\diag\rdbms\dbdms\dbdms\trace\dbdms_ora_1724.trc:
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [99189], [43531], [43569], [], [], [], [], [], [], []
Errors in file d:\dbdms\diag\rdbms\dbdms\dbdms\trace\dbdms_ora_1724.trc:
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [99189], [43531], [43569], [], [], [], [], [], [], []
ORA-600 signalled during: alter database open...


SQL> startup
ORACLE 例程已经启动。

Total System Global Area 417546240 bytes
Fixed Size 2176328 bytes
Variable Size 268438200 bytes
Database Buffers 138412032 bytes
Redo Buffers 8519680 bytes
数据库装载完毕。
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [99189],
[43531], [43569], [], [], [], [], [], [], []




环境是windows server 2008 64bit  
  oracle 11.2.0.1.0版

现在库起不来,重建了SID,不知道有没什么办法,谢谢!

------解决方案--------------------
1.做好备份
2.尝试recover database;,再尝试open
3.如果不行,recover database until cancel;,然后resetlogs
4.再不行,看情况分析


我在pub上回复过了
如果不会解决,可以联系我
qq号:107644445