Re: Recover when Online Redo Log lost.

cnwy_at_263.net (yoke wang) wrote in message news:<42c18ceb.0408132015.7054406d_at_posting.google.com>...
> > If you shutdown immediate, and then immediately delete the online logs,
> > "recovery" would be required (to reconstuct some working redo logs). But
> > it's a fake recovery, as you imply: recover database until cancel,
> > immediately cancel, alter database open resetlogs. I suppose this is an
> > example of an incomplete recovery that actually doesn't lose any data, and
> > some people might therefore call it a complete recovery -but they'd be
> > wrong. You've still just performed an incomplete recovery, despite not
> > having lost any committed data. There should be no need to do a prior
> > restore of anything, because the data files and control files are
> > consistent with each other.
> But why oracle must open the database resetlogs?I think there is
> someting lost which was recorded in red log. Otherwise Oracle can
> recreate the redo log and open the database noresetlogs.Is it right?
>
> Thanks a million.
>
> wy.

It is not right, as you do not have all of the original redo logs present. You are missing a current redo log, thus making a noresetlogs open impossible. From the documentation:

Specify NORESETLOGS if you want Oracle to use all files in the LOGFILE clause as they were when the database was last open. These files must exist and must be the current online redo log files rather than restored backups.

Since your case involves a deleted current redo log opening the database noresetlogs is, as I stated before, impossible. You have but one choice, to open the database resetlogs and let Oracle do its work.

David Fitzjarrell Received on Sat Aug 14 2004 - 11:08:57 CDT