Re: recovering offline redos

From: I hate Spam <tbf_at_cn.stam.dk>
Date: Tue, 05 Jun 2001 21:26:52 +0200
Message-ID: <0nbqhtgpljscdmg4jrqp84nr6itthsuhc7@4ax.com>

On Tue, 5 Jun 2001 21:45:38 +1000, "Howard J. Rogers" <howardjr_at_www.com> wrote:

>Yes it's possible, in theory.
>
>Unfortunately, if you simply restore everything from the backup, you will
>have a beautifully consistent database at time January 27th, and recovery
>will not be prompted for, nor possible.
>
>What you need is the control file and or datafiles from January 29th, then
>restore ALL the datafiles from the backup of the 27th. Then it's a simple
>'recover database until <time string>' command.
>
>If ALL you have is a consistent backup at the 27th, I can't see how you can
>provoke recovery, though.

Just a thought - how about using the consistent January 27th database to do:

ALTER DATABASE CREATE STANDBY CONTROLFILE AS 'filename';

shutdown the database and using the standby control file to start and mount it in standby mode. After that just use RECOVER STANDBY DATABASE Have not tried it, and probably overlooked something.

Yours Hans Erik Busk
tbf_at_cn.stam.dk Received on Tue Jun 05 2001 - 14:26:52 CDT