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.
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.
-- //www.freelists.org/webpage/oracle-l