Database Backup and Recovery (MOSC)

MOSC Banner

data block corrupted

edited Apr 4, 2013 5:26PM in Database Backup and Recovery (MOSC) 3 commentsAnswered
When configure the enterprise manager during 11G upgrade, got the following error messages:

ORA-01578: ORACLE data block corrupted (file # 19, block # 4340)

ORA-01110: data file 19: 'D:\ORADB11G\ORADATA\...\SYSAUX01.DBF'

And run select statements and got the followings:

SQL> SELECT tablespace_name, segment_type, owner, segment_name

FROM  dba_extents WHERE  file_id =19 AND 4340 between block_id AND block_id+blocks-1; 

SQL>  TABLESPACE SEGMENT_TY OWNER      SEGMENT_NAME

     ---------- ---------- ---------- --------------------

     SYSAUX     INDEX      SYS        WRM$_SNAPSHOT_PK

any suggestion/idea for how to fix/repair it (we do not have backup) or any bypass so that we can configure the EM? Thanks.

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