Database Administration (MOSC)

MOSC Banner

repair corrupted table partition

edited Jun 18, 2018 3:39PM in Database Administration (MOSC) 6 commentsAnswered ✓
creating EM repository failed due to the error ORA-01578: ORACLE data block corrupted (file # 19, block # 22020) . check the details and got the following:

SQL> SELECT tablespace_name, segment_type, owner, segment_name
 FROM  dba_extents
 WHERE  file_id =19
 AND 22020 between block_id AND block_id+blocks-1

TABLESPACE_NAME       SEGMENT_TYPE        OWNER     SEGMENT_NAME
------------------------------ ----------------------      -----------  -------------------------------------------
SYSAUX                          TABLE PARTITION     SYS           WRH$_ACTIVE_SESSION_HISTORY

any idea and suggestion to repair this table partition is appreciated.

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