Corrupt rollback segment

  • From: Gus Spier <gus.spier@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 7 Dec 2010 18:59:21 -0500

Solaris 10

The database' SAN suffered a mild catastrophe very early this morning.
After the storage managers, sysadmins, and network types finally restored
service, we found that the database would not open

Review of the alert log highlights an ORA-600, [4194],[4],[7],[],[] ..
Google search and MOS tell me that 4194 indicates that the redo block and
undo block do not match.  In this case, the undo is at block 4 and the redo
is at block 7.

Further examination of alert log and trc files indicate my file# 7, block
1777 is corrupt.

We have tried simple recovery, data file recovery, building a new UNDO
tablespace, but we still have an active rollback segment with a corrupt

A Severity One SR has been opened with Oracle Support, and been elevated.

We're still waiting for an update.

has anybody any useful suggestions?



Other related posts: