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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center