| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> FW: Having problems in Recovery :-|
After nearly 15 hour of work, this database is up, with incomplete recovery.
Almost 95% of the work is recovered. I could not go any further as the
database could not recover data from on-line logs. I started getting the
following errors when attempted to get the data from on-line logs...
ORA-00600: internal error code, arguments: [3020], [4194716], [1], [204], [135386], [96], [], []
Oracle Support has recommended stopping recovery at that point. Losing System datafile is really a mess, and I am glad that we did not lose a lot ...
Rama
-----Original Message-----
From: Parekh, Ketan [mailto:KParekh_at_ea.com]
Sent: Thursday, October 19, 2000 1:01 PM
To: 'rmalladi_at_inteliant.com'
Subject: RE: Having problems in Recovery :-|
HI!
Rama,
Ora-600 is one error we would not like to see okay try to check the alert log as to the time the system datafile actually got copied from the database to the tape. Next : what u need to do is get the last hot or cold backup - retrieve the system datafile and recreate the database with backup control file.
hope this helps..
ketan
-----Original Message-----
From: Rama Malladi [mailto:rmalladi_at_inteliant.com]
Sent: Thursday, October 19, 2000 3:29 PM
To: Lazy DBA (E-mail)
Cc: ORACLE-L (E-mail)
Subject: Having problems in Recovery :-|
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 ...
This morning, the database did not get started (as it could not be shutdown). This is the message ...
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], [], []
I am in the process of restoring from the cold backups 2 days ago... Any Ideas would help
Thank you
Rama
 |
 |