Having problems in Recovery :-|

From: Rama Malladi <rmalladi_at_inteliant.com>
Date: Thu, 19 Oct 2000 12:29:08 -0700
Message-Id: <10654.119807@fatcity.com>

Hi
DB Version: 8.0.5
O/S: Sun Solaris 2.6

Scenario: The Archive directory is getting full. So one of the Operators backed up the Archive files to Tape (A Standard procedure). But by mistake the operator also selected the System Datafile (Sys*.dbf) file and moved it to the Tape. Then he copied it back from Tape to the system.

The Database continued to run for another 4-5 hours (with the Out of Synch datafile!). Around midnight database could not be shutdown for the backups. This is the message ...

SVRMGR> ORA-01122: database file 1 failed verification check ORA-01110: data file 1: '/u01/oradata/ecorder/sys01.dbf' ORA-01208: data file is an old version - not accessing current version SVRMGR>
Server Manager complete.
Database "ECORDER" shut down.

This morning, the database did not get started (as it could not be shutdown). This is the message ...

Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/oradata/ecorder/sys01.dbf' SVRMGR>

Then I tried the following
SVRMGR> connect internal
Connected.
SVRMGR> startup mount
ORACLE instance started.
SVRMGR> recover database
ORA-00283: recovery session canceled due to errors ORA-00600: internal error code, arguments: [3020], [4194716], [1], [204], [135386], [96], [], []

SVRMGR> recover datafile 1
ORA-00283: recovery session canceled due to errors ORA-00600: internal error code, arguments: [3020], [4194716], [1], [204], [135386], [96], [], []
SVRMGR>

I am in the process of restoring from the cold backups 2 days ago... Any Received on Thu Oct 19 2000 - 14:29:08 CDT