Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rebuild an index of owner SYS

Martin1Jul 4 2007 — edited Jul 5 2007

Hi,

in a 10g R1 database i have determined data block corruptions in the alertLog:
ORA-01578: ORACLE data block corrupted (file # 3, block # 35251) and
ORA-01578: ORACLE data block corrupted (file # 3, block # 39766)

After querying dba_extents i can determine that the data block corruptions belongs to indexes of SYS:
- SYS_C002467 (Normal Unique Index on SYS.ALERT_QT)
- SYS_IOT_TOP_8564 (IOT-TOP Unique Index on SYS.AQ$_ALERT_QT_H)

What's the recommended action to rebuild thes indexes?

Any tipps are welcome.

Best regards,
Martin

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 2 2007

Added on Jul 4 2007

#general-database-discussions

4 comments

1,166 views