In this Document
The error is raised when we fail to find a row piece, i. e., the block is fine, but the row does not exist.
This error is new in 10g, in 9i we didn't raise this error and the corruption was unnoticed.
We raise ORA-600[kdsgrp1] assert during table/index full scans if a row piece is not found.
The error is raised only if Event 10231 or SKIP_CORRUPT_BLOCKS is not set.
/* Check table number, whether the row slot exists, whether row exists */
/* if row doesn't exist, and neither 'skip corrupt block' nor
** 'user rowid' bits are set, then raise error kdsgrp1.
Error may be caused if:
1. A row referenced in an index does not exist in the table.
In this case 'analyze table
2. An unexistent rowid pointed by a chained row.
In this case analyze will not fail.
In this case error can be eliminated by skipping the "corruption", however
before doing anything like this you should verify if there is actually any data in the
referenced blocks that are getting errors and will be skipped.
Please involve Oracle Support to see if it's possible to extract the data.
Trace file generated by ora-600[kdsgrp1] will show at the beginning something similar to:
Please dump the block in order to retrieve the data:
SQL> alter system dump datafile 32 block 2523519;
In order to skip the error one of these two w/a can be used:
1) set event 10231 and export the good rows or use 'create table as select ..'
Setting the event in a Session
Setting the event at Instance level
Edit your init
export the table or use 'create table .. as select ..'
2) run DBMS_REPAIR.SKIP_CORRUPT_BLOCKS() procedure on the table
Connect as a SYSDBA user and mark the table as needing to skip corrupt blocks thus:
After this you can export the table or run 'create table .. as select ..'.
You can find the lost rows from the corrupted blocks by comparing the corrupted table with the new table.
Once you have the rowid of the skipped rows you can use DBMS_ROWID package to find the file# and block#, and dump the block to retrieve the data:
SQL> alter system dump datafile
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15747463/viewspace-736168/，如需转载，请注明出处，否则将追究法律责任。