Re: recover after lost online redo-log

In article <01bd0c8a$2e985fc0$fc7f3f8f_at_khome>,   "Kevin Brand" <kbrand_at_gtetel.com> wrote:
>
>
> Has anyone figured out a way to recover an instance after loosing an online
> redo-log? A cold backup will recover to some point in time before the
> loss. Is it possible to trick Oracle into letting me then restore a Hot
> backup and roll the logs forward up to the log that was lost?
>
> -Kevin Brand

So if you only lost one online redo log, you can startup the database using resetlogs and voila all works fine. BUT if you have lost any datafiles too, you have to use the hot backup and do an incomplete recovery (up to the missing online redo log). Then you have to startup with resetlogs.

But mention after doing resetlogs in both cases : No further recovery is possible cause the information is lost!!! Be aware and back up all your files prior to using one of this methods.

Andreas

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet