Re: Backup stuff

From: Neil Chandler <oracle_at_tchp2.tcamuk.stratus.com>
Date: 13 May 1998 10:35:06 GMT
Message-ID: <slrn6litnv.env.oracle@tchp2.tcamuk.stratus.com>

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 Received on Wed May 13 1998 - 05:35:06 CDT