Object with Block Corruption
Jump to navigation
Jump to search
Identifying which object is corrupt in a block corruption ....
ORA-01578: ORACLE data block corrupted (file # 54, block # 18689)
select * from dba_extents where file_id = 54 and block_id between 18687 and 18690;
A variation of this ...
select * from dba_extents where file_id = 54 and block_id between 18689 and block_id + blocks -1;
Match up with DBA Block Corruption View ...
select dbe.*, (dbe.block_id + dbe.blocks) as end_block from dba_extents dbe, v$database_block_corruption bc where dbe.file_id = bc.file# and bc.block# between dbe.block_id and (dbe.block_id + dbe.blocks);
Also listed in ...
select * from v$database_block_corruption;