Re: Recover with RESETLOGS

Not true... the Backup and Recovery course contains instructions on just how to do this... the basic step is that you backup the controlfile you've got (ie from after the resetlogs), and restore the one from before the resetlogs (together with all data files). You then roll forward to the SCN at which the resetlogs was issued (hopefully, your alert log with that info is still avaolable). Instead of then opening the database, you swap back the controlfile from after the resetlogs, and perform a complete recovery as normal.

That course material also contains the comment that if you follow the normal advice, which is to backup AFTER EVERY RESETLOGS, you should never have to perform this tricky sequence of events!

Regards
HJR "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:997985206.4879.0.pluto.d4ee154e_at_news.demon.nl...
>
> "Sven Morling" <sven.morling_at_ivz.de> wrote in message
> news:3B7BA947.26D4C14B_at_ivz.de...
> > Hello NG,
> >
> > there is a big problem in our company. I hope, one of you can help us.
> > At first I will describe the problem.
> >
> > In our database occured a ORA-01578 "ORACLE data block corrupted". This
> > is failure which came through a disk failure.
> >
> > After this we made an RECOVER UNTIL .... with a ALTER DATABASE OPEN
> > RESETLOGS. Then the database ran one week. Now there are the problems
> > in the datafiles(blocks).
> >
> > So we have probably an safe backup two weeks ago. And there is our
> > problem. Between now and then is an RESETLOGS.
> >
> > Now my question: Is it possible to restore the safe backup and roll
> > forward until the RESETLOGS-time and then roll again forward with the
> > new offline redologs and the new SCN´s.
> >
> > If there is somebody who can help us, i would thank him, if he contact
> > me personally.
> >
> > sven morling
> >
> > germany
> >
>
> Sorry but you can't get beyond a resetlogs
>
> Period.
>
> Regards,
>
> Sybrand Bakker, Senior Oracle DBA
>
>
>
Received on Sat Aug 18 2001 - 17:25:59 CDT