Re: recovering offline redos

From: Howard J. Rogers <howardjr_at_www.com>
Date: Tue, 5 Jun 2001 21:45:38 +1000
Message-ID: <3b1cc684$1@news.iprimus.com.au>

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.

Regards
HJR

--
=============================!!=============================
The views expressed are my own only, and definitely NOT those of Oracle
Corporation
=============================!!=============================


"Rolf Sapler" <bud_socks_at_gmx.net> wrote in message
news:9fid7c$cb0$01$1_at_news.t-online.com...


> Hi there,

>

> i need to restore a db from a ArchServ NT-Backup.

>

> This backup was taken on 01/27.

>

> Furthermore  i need to roll forward till 01/29. All necessary

 offline-redos


> up to

> 01/30  are available without interruption.

>

> How can i do a point in time recovery up to the desired time (01/29,

 06.00h)


> ?

> Is it possible at all ?

>

>

> Thanks for help

>

> Rolf

>

>

>

Received on Tue Jun 05 2001 - 06:45:38 CDT