Database Administration (MOSC)

MOSC Banner

corrupt block

edited May 27, 2009 12:19AM in Database Administration (MOSC) 4 commentsAnswered ✓
 Hi,
I see 2 corrupted blocks in v$database_block_corruption but I can't find any object using this blocks.
Will v$database_block_corruption be cleared if i.e an index is rebuild and the corruped block isn't used any more
or is there a way to do it manualy?



SYS@racft10g >select * from v$database_block_corruption;

                FILE#                BLOCK#                BLOCKS    CORRUPTION_CHANGE# CORRUPTIO
--------------------- --------------------- --------------------- --------------------- ---------
                   15                229993                    86             111142736 LOGICAL
                   15                235853                     9             111216091 LOGICAL

SYS@racft10g >SELECT tablespace_name, segment_type, owner, segment_name
  2       FROM dba_extents
  3       WHERE file_id = 15
  4       and 229993 between block_id AND block_id + blocks - 1;

no rows selected

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