I seem to remember something in the Rama Velpuri Backup and Recovery
book discussing recovery through resetlogs. Do you or does anyone
else have this book available to confirm this? I can't find my copy
anywhere and its been driving me crazy not to know one way or the
other whether this type of recovery is possible. I thought the steps
went something like this:
recover until blah,
open database resetlogs,
shutdown database,
replace current controlfile with a backup controlfile from before
resetlogs was issued,
open database mount,
recover database using backup control file.
I could having a false memory here but I remember reading about this
somewhere and I thought it was that book.
"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 Fri Aug 17 2001 - 09:33:32 CDT
