corrupt block
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
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
0