Re: Oracle Recovery

"koert54" <nospam_at_spam.com> wrote in message news:IPp1c.1665970$9p3.309547_at_news.easynews.com...
> > If you opened the database with RESETLOGS, then your current database is
> > a different incarnation and the old backups from the previous
> > incarnation cannot be used.
>
> -> that seems to be the general opinion - however Lawrence To & Stefan
> Pommerenk
> have written a whitepaper some time ago called 'Recovery past resetlogs in
> Oracle7 & Oracle8'
> which shows it's possible to recover past a resetlogs using RMAN and
> old-skool recovery techniques...
>
> I have not tested it on 9i tho ...
>

Oh, it's possible. It's just tricky to pull off, that's all. RMAN aside for the moment, it requires you having binary control files from before the resetlogs. You basically restore that, perform recovery to the SCN of the resetlogs operation but do not ask to open the database, and then switch the control files to the ones you had after the resetlogs, and keep going with further recovery.

It is frankly easier to just back the database up after performing a resetlogs. Then the technique need never be used in the first place.

I gave up teaching "recovery despite resetlogs" ages ago. It's one of those "look how clever I can be" techniques, when actually the phrase that ought to spring to mind is "look how dumb I was to have to use this technique at all!"

Regards
HJR Received on Sat Mar 06 2004 - 15:16:52 CST