Object with Block Corruption

From NazimWIKI
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;