Re: Recover with RESETLOGS

"Re-bonjour" from Paris !

See my answer to John Darrah", there is may be a "X-files" solution to your problem.

Christophe

Hieraklion a écrit :

> "Bonjour" from Paris,
>
> When you use the RESETLOGS option to open the database, O throws away the
> redo that was not applied during the recovery, and ensure that it CAN NEVER
> BE APPLIED AGAIN.
>
> Perhaps, a "two weeks" export may help you ?
>
> "Au revoir" from Paris
> Christophe Brault
>
> Sven Morling a écrit :
>
> > 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
Received on Fri Aug 17 2001 - 10:36:10 CDT