Database Utilities (MOSC)

MOSC Banner

How to get rid of a corrupt block that has CORRUPTION_TYPE of FRACTURED on V$DATABASE_BLOCK_CORRUPTI

edited Sep 17, 2013 4:46AM in Database Utilities (MOSC) 8 commentsAnswered ✓
We've got a corrupt block as follows on a DEV database that doesn't have RMAN backups.

SQL> select * from v$database_block_corruption;

     FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTIO
---------- ---------- ---------- ------------------ ---------
         6     781711          1                  0 FRACTURED

SQL> select segment_type, owner||'.'||segment_name
  2  from dba_extents
  3  where file_id = 6 and 781711 between block_id
  4  and block_id+blocks -1;

SEGMENT_TYPE       OWNER||'.'||SEGMENT_NAME
------------------ ----------------------------------------------------------------------------------------------------------------
INDEX              SOAINFRA.MEDIATOR_INSTANCE_INDEX1

I've tried rebuilding the index to see if that will get rid of the corrupt block, but it's still saying corrupt, so I dropped it and then looked at the corrupt block again.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center