Block corruption in the SYSAUX tablespace.
Thank you very much for looking into my issue.
There is a data block corruption in the Development Database using Enterprise Edition Oracle 10.2.0.4 in RHEL5.
The block corruption is reported in a SYSAUX tablespace. DBVerify has reported errors in two blocks, the extract of which is as under:
'/v1/u32/oradata/PROD1/sysaux02.dbf'- Two Blocks Corrupt
CORRUPT SEGMENT: TABLE
Table:'WRI$_ADV_OBJECTS'
Tablespace: SYSAUX
Owner: SYS
CORRUPT SEGMENT: IOT INDEX
INDEX: SYS_IOT_TOP_8866
TABLE: AQ$_ALERT_QT_T
Tablespace: SYSAUX
Owner: SYS
The database is in the no archive log mode. There hasnt been any latest backup taken of this database. I tried using the dbms_repair package on 'WRI$_ADV_OBJECTS' but it errors out ORA-01578 along with ORA-06512. DBMS_REPAIR is not supported for IOT s hence not applicable for SYS_IOT_TOP_8866.