recover with RMAN

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Tue, 06 Sep 2005 15:59:34 -0500
Message-ID: <BAY107-F11DDB440D3CABAD5A53FEA97A70@phx.gbl>

I have a test database that is 9.2.0.5.0 on Solaris 8. A disk is failing according to the syslogd log file and we rebooted the box and everything came up. I had to blockrecover because there was corrupted blocks in the undo tablespace. That fixed that problem.

The problem now is in the alert log I am getting:

ora-600 [4193]
ora-600 [4097]

this means:

A mismatch has been detected between Redo records and Rollback (Undo) records.

We are validating the Undo block sequence number in the undo block against the Redo block sequence number relating to the change being applied.

After recovering blocks from within the undo tablespace the redo and undo are mismatched.

How do I sync the redo and undo up without recreating the instance?

RMAN does a full db backup with the archive logs at night.

Would I:

rman> restore database;
rman>recover database until cancel;
rman>alter database open resetlogs;

Any help is appreicated.
thanks.

Don’t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 06 2005 - 16:01:38 CDT