Re: Recovery from Archived Redo Logs

You will have to perform incomplete recovery since you have lost your online redo
logs. You can perform a recover database until cancel and pass the location of each archive log as it is needed. This will bring your database to the point in time of
your last archived redo log. You will have lost the transactions that were still
in any of the redo logs that had not been archived.

hth.. others in the thread may have different solutions..

"Zoltan" <zoto29_at_hotmail.com> wrote in message news:8f64800e.0112201807.16733555_at_posting.google.com...
> I've been looking at backup/recovery scenarios and have come across
> one that I can't solve.
>
> Regular cold backups are done, including the redo logs, but after a
> disk crash, the database is gone, including the online redo logs, but
> the archived redo logs are still there (different disk). Unfortunately
> the latest backup is a day old and doesn't reflect the work done
> today, otherwise it works fine.
>
> The question is:
> Can the day's work be recovered from the archived redo logs?
>
> I've tried a "recover database" but Oracle claims it doesn't need
> recovery, due I suppose, to the restored online redo logs being at the
> same level as the database.
Received on Thu Dec 20 2001 - 23:06:25 CST