High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Corrupt block exists even after table corruption is corrected

 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’); 

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