Re: Backup Oracle ? Online Redo Log.

From: Murali <oraclems_at_hotmail.com>
Date: 13 Jan 2002 18:13:49 -0800
Message-ID: <22e6597b.0201131813.799a0565@posting.google.com>

Han Thomas <han_at_royal.net> wrote in message news:<7p234u0ju1c5k6pvrhmom4bds7bjq6aagf_at_4ax.com>...
> On Fri, 11 Jan 2002 11:14:10 +0100, "Christian M." <cm_at_sdv.fr> wrote:
>
> >1) Restore of my hot backup of the night ( DATAFILES )
>
> Hold on, can you do that? I thought you needed cold backup files to start
> with, then apply the archived log files??

Yes, you can. No, you dont. Why cant you restore from hot backup and apply the archived logfiles ? What is the point of a hot backup if you always need a cold backup to start with. You dont need to start with your last cold backup to apply the archived logfiles.

> That's of course quite a load of files.. Imagine applying seversal months of
> redo logfiles..

You just need the archive logs from the time your last hot backup started.

Murali Received on Sun Jan 13 2002 - 20:13:49 CST