Oracle data block corruption errors have been found in the alert log

First time I’ve seen this:

Wed Mar 16 00:30:03 2011
Corrupt Block Found
         TSN = 36, TSNAME = TS_UK_MYSCHEMA_DATA
         RFN = 33, BLK = 1939619, RDBA = 140351651
         OBJN = 631282, OBJD = 631282, OBJECT = I_MYSCHEMA_2, SUBOBJECT =
         SEGMENT OWNER = MYSCHEMA, SEGMENT TYPE = Index Segment
Errors in file /u01/app/oracle/diag/rdbms/db1/db12/trace/db12_j003_5565.trc  (incident=335735):
ORA-01578: ORACLE data block corrupted (file # 33, block # 1939619)
ORA-01110: data file 33: ‘/oradata/DB1/DB1/ts_myschema_data01.dbf’

I resolved by dropping the Index which was in the corrupt block, and then recreating the index. The refresh job is working ok now.

The next step would be to run a DB Verify against all databases to make sure there isn’t any other corruption and hasn’t been hit by a query yet.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: