Re: Backup stuff

Thanks for correcting me, Neil. I stand corrected.

In article <slrn6litnv.env.oracle_at_tchp2.tcamuk.stratus.com>,   oracle_at_tchp2.tcamuk.stratus.com (Neil Chandler) wrote:
>
> In article <6jal0d$evv$1_at_nnrp1.dejanews.com>, cmohan_at_iname.com wrote:
> >Redo log files are only used for instance recovery.
> >While running noarchivelog,(you do cold backups) in case of a database
crash,
> >you can bring the database only up to the point in time you performed
> >the back up. So redo log files are useless.
>
> If performin a cold backup, ALL files relating to the Oracle database should
> be backed-up - including the REDO logs. I would like to see you start a
> database without them...
>
> However, in ARCHIVELOG mode, doing a log switch and then backing up the
> archived logs is a good idea. Do not backup REDO logs whilst the database
> is up - not a good idea.
>
> Good reading for backup and recovery is:
> Oracle Backup and recovery handbook by Rama Velpuri. It tells you some
things
> it should not but that is just Rama showing off IMHO. ISBN-0-07-882106-1
>
> regs
>
> Neil Chandler
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu May 14 1998 - 16:41:49 CDT