Just try cancelling the recovery. If it is an online redo log the database should open. HTH, Ruth -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Adams, Matthew (GE Consumer & Industrial) Sent: Sunday, August 22, 2004 1:34 PM To: oracle-l@xxxxxxxxxxxxx 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? ---- Matt Adams - GE Appliances - matt.adams@xxxxxxxxxxx If C gives you engouth rope to hang yourself, then C++ gives you enough rope to hang yourself, your dog, your co-workers, and everyone in your neighborhood. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------