Re: Different backup procedure.

My understanding is that you need the current control file to recover to the current time.

David

On Mon, 10 Aug 1998 15:47:31 -0400, Devinder Pal Singh <Devinder_Pal.Singh_at_pharma.novartis.com> wrote:

>Dear Robert Prendin
>Saw your article over the net and found it very interesting. I have some
>confusion regarding the hot backup and archivelog mode backup.Please
>bear with me.
>If your database is running in archive log mode, thenis it necessary to
>take hot backup also or achive log along with cold backup will suffice.
>Let us say we take cold backup on sunday and backup of offline redolog
>files everyday. If on tuesday or wednesday (assume) whole of the system
>crashes ( you lose every datafile, every control file) and you have to
>roll forward you database from scratch. The onvious thing would be to
>put the cold backup into the machine and apply your redo logs. But (the
>catch) when you put cold backup and mount your database and give recover
>database command, wont it say that no recovery required. Since
>everything is in sync, the control file, datafiles etc, they have the
>same time stamp, same SCN. Can you enlighten me on this thing, I tired
>and failed to roll forward the databse.
>I am having great hopes and anticipations from your side, please do
>reply.
>Reagrds
>Devinder
Received on Mon Aug 10 1998 - 20:02:49 CDT