Re: Recover with RESETLOGS

"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 - 08:16:31 CDT