Re: Recover with RESETLOGS

"John Darrah" <john.darrah_at_usa.net> wrote in message news:4af5a619.0108170633.18dc9a5d_at_posting.google.com...
> 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.
>

These steps coming from memory are amazingly accurate... but it'll be a disaster if you do an open resetlogs after the 'recover until blah'.... you're supposed at that point to perform a graceful shutdown to permit the switching of the controlfiles, and thence to performing the second part of the recovery.

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:28:49 CDT