Database Administration (MOSC)

MOSC Banner

ORA-01578 in sysaux tablespace

edited Mar 27, 2009 5:18AM in Database Administration (MOSC) 2 commentsAnswered
 Hi,

I have a corrupted block in my sysaux tablespace :

Errors in file /u01/app/oracle/admin/AXWAYD/bdump/axwayd1_j000_4581.trc:
ORA-00604: error occurred at recursive SQL level 2
ORA-01578: ORACLE data block corrupted (file # 3, block # 37610)

The problem is I haven't a backup of the database.

The corrupted object is a sys index :

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

SEGMENT_TYPE
------------------
OWNER||'.'||SEGMENT_NAME
--------------------------------------------------------------------------------
INDEX
SYS.I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST

I there a mean to solve the problem without recreating the entire database ?

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