ORA-01578 in sysaux tablespace
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 ?