Re: Recover with RESETLOGS

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 16 Aug 2001 20:06:44 +0200
Message-ID: <997985206.4879.0.pluto.d4ee154e@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 Thu Aug 16 2001 - 13:06:44 CDT