Corrupt block exists even after table corruption is corrected
edited Dec 6, 2013 7:46AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 11 commentsAnswered
Hi,
I've encountered block corruption in one of our datafiles
ORA-01578: ORACLE data block corrupted (file # xxxx, block # yyyyyyyyyy)
ORA-01110: data file xxxx: '+DATA/zzz'
When I queried dba_extents, found out it to be a table
set linesize 100
col owner for a15
col segment_name for a30
col segment_type for a30
select owner,segment_name, segment_type from dba_extents
where file_id = &AFN
and &BL between block_id AND block_id + blocks - 1;
I took the datafile offline, skipped the corrupt block, datafile online
alter database datafile ‘+DATA/zzz' offline;
execute DBMS_REPAIR.SKIP_CORRUPT_BLOCKS(‘SS’,’TTT’);
0