Database Administration (MOSC)

MOSC Banner

ORA-01578: ORACLE data block corrupted sysaux

edited Feb 19, 2018 3:29AM in Database Administration (MOSC) 27 commentsAnswered ✓

Hello,

I noticed in the alert.log messages: ORA-01578: ORACLE data block corrupted (file # ORA-01578: ORACLE data block corrupted (file # 3, block # 576939)

File 3 is SYSAUX datafile


I ran the following queires

SQL> select * from v$database_block_corruption;

     FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTIO     CON_ID

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

         3     576939          1                  0 CHECKSUM           0

SQL> SELECT tablespace_name, segment_type, owner, segment_name FROM dba_extents WHERE file_id=3 and 576939 BETWEEN block_id AND block_id + blocks - 1;

TABLESPACE_NAME                SEGMENT_TYPE       OWNER                                                                                                                            SEGMENT_NAME

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

SYSAUX                         TABLE              SYS                                                                                                                              WRH$_SQL_PLAN

How i understand a corrupted block is in the WRH$_SQL_PLAN?

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