Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Recover with RESETLOGS

Re: Recover with RESETLOGS

From: Howard J. Rogers <howardjr_at_www.com>
Date: Sun, 19 Aug 2001 08:26:13 +1000
Message-ID: <3b7eea8a@usenet.per.paradox.net.au>


Yes you can.
HJR "Prince Kumar" <gspk_at_yahoo.com> wrote in message news:629275ba.0108171042.1dab8dd0_at_posting.google.com...
> I guess "john.darrah" is talking about gracefull switch over. With
> "ResetLogs" I don't think it is possible to recover beyond the
> resetlogs. (u can not combine the backup prior and after the reset
> logs for recovery)
>
> Prince..
>
> john.darrah_at_usa.net (John Darrah) 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.
> >
> >
> > "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:26:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US