| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: problem with recovery
Just try cancelling the recovery. If it is an online redo log the database
should open.
HTH,
Ruth
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Adams, Matthew (GE
Consumer & Industrial)
Sent: Sunday, August 22, 2004 1:34 PM
To: oracle-l_at_freelists.org
Subject: problem with recovery
While all tablespaces were in backup mode, Oracle reported corruption in the controlfiles and crashed.=20
A checksum of the controlfiles found them to be identical,=20 so I re-created them. Then I took the datafiles out of backup mode.
When I went to open the database, oracle tells me that the datafiles still need recovery, and that the archive file needed is sequence #15339. But this is the online redo logfile that was the current file at time of crash.
How do I get Oracle to see the online file rather than=20 looking for an archive file?
I cannot use 'alter system switch logfile' to=20 get oracle to archive the onlines because the database is not open.
I've also attempt
alter database archive log file '....';
alter database recover logfile '...';
Both of these commands are invalide after re-creating the controlfile.
I even tried copying the online file to the correct name in=20 the archive directory. Nothing seems to work.
Any ideas?
 |
 |