读书人

ORA-00600异常

发布时间: 2013-01-08 14:02:13 作者: rapoo

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加我试试看

读书人网 >oracle

热点推荐