Re: Recover when Online Redo Log lost.

> 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. Received on Fri Aug 13 2004 - 23:15:22 CDT