Database Administration (MOSC)

MOSC Banner

Problem of a corrupted block on an IOT

edited May 28, 2009 3:25AM in Database Administration (MOSC) 3 commentsAnswered
Hi,

I have a corrupted block in the sysaux tablespace :

ORA-01578: ORACLE data block corrupted (file # 3, block # 35516)
ORA-01110: data file 3: '/Data_Lifera_Fresco_Synchrony/AXWAYD/sysaux01.dbf'

The corrupted block is an index :

SQL> SELECT SEGMENT_TYPE,OWNER||'.'||SEGMENT_NAME FROM DBA_EXTENTS  WHERE 3 = FILE_ID AND 35516 BETWEEN BLOCK_ID AND BLOCK_ID+BLOCKS -1;

SEGMENT_TYPE
------------------
OWNER||'.'||SEGMENT_NAME
--------------------------------------------------------------------------------
INDEX
SYSMAN.MGMT_METRICS_RAW_PK

The problem is that I can't rebuild it :

SQL> alter index SYSMAN.MGMT_METRICS_RAW_PK rebuild tablespace SYSAUX;
ERROR at line 1:
ORA-28650: Primary index on an IOT cannot be rebuilt

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