Database Administration (MOSC)

MOSC Banner

Block corruption in the SYSAUX tablespace.

edited Sep 8, 2009 6:51AM in Database Administration (MOSC) 12 commentsAnswered
 Hi All

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.

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