Re: SOS: How to recover a database with missing all online redo logs

From: Rich Jesse <>
Date: Mon, 21 Apr 2008 10:50:17 -0500 (CDT)
Message-ID: <18150.>

More detailed information is needed, but I have a sinking feeling that you've already rolled your database forward past the point of recoverability. Step 2 in recovery (after assessing the situation) should be to backup what you have so that you can restart your recovery should it fail. Without knowing a detailed timeline of events, including the recovery commands, I don't believe anyone here can offer a magic bullet of recovery for you. But from what you've stated, I believe the most likely scenario to be that you will need to do a PIT recovery of your database from backup to the last completed SCN that has been archived.

I have to say that the basic recovery questions today is a little alarming. These are covered in the Oracle classes, at least when I took them back in the v8 days. And Oracle Support should also be used in recovery scenarios where the recovery plan is not known or there are issues. You *have* purchased Support for your 1.5TB DB, right???

Best of luck!


> List,
> Inadvertently one of our team member dropped all the online redo logs from
> all the file systems from one of our 1.5 tera bytes test instance. The
> instance is running on 9208,64 bit on AIX box. We failed when we tried to do
> simulate an incomplete recovery "recover database using backup control file
> until cancel;", and try to open the database using open resetlogs, but the
> recovery command fails with an error ora-01113. Please help us to recover
> this instance.
> Thanks
> Prabhu

Received on Mon Apr 21 2008 - 10:50:17 CDT

Original text of this message