ORA-00600错误
startup
ORACLE 例程已经启动。
Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 83886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
数据库装载完毕。
ORA-00600: 内部错误代码,参数: [2037], [8388765], [0], [0], [0], [0], [0], [1]
------解决方案--------------------内部bug
------解决方案--------------------找oracle的support.
------解决方案--------------------你的版本是11.2.x.x的吧?有个BUG:
Bug 14301592 Several errors by corrupt blocks shifted by 2 bytes in buffer cache during recovery caused by INDEX redo apply
文档的处理说明如下:
Workaround
========
To continue the recovery process:
Run recovery (or managed recovery if it is standby database) until it terminates when the offended block <datafile X block Y>
is encountered by ORA-600 [kdxlin: sno out of range].
Then run the recovery with ALLOW 1 CORRUPTION. This will corrupt the block - restart recovery; the corrupt block will be skipped.
To repair the block once it is marked as corrupt:
The affected index will need to be rebuilt.
Another option is for a STANDBY database:
Run analyze table <name> validate structure cascade in the PRIMARY database. If it does not produce an error in primary, then copy
the affected datafile to standby.
你可以按如下步骤处理:
SQL> RECOVER DATABASE;
选择自动处理,直到出现ORA-600 [kdxlin: sno out of range].
SQL> RECOVER DATABASE ALLOW 1 CORRUPTION;
打开数据库后再把有问题的索引重建。
------解决方案--------------------如果还没有搞定,可以qq加我试试看