Given that RMAN does not backup the online redo logs, one might consider that this is the ultimate word on the subject from Oracle. :-) Robert -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx To: mark.bobak@xxxxxxxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Sent: 10/4/2004 12:00 PM Subject: Re: Question in HOT BACKUP NEVER? Come on Mark, you should know that one never wants to say "never". usually, mostly, generally ... Exceptions off the top of my head for your assertion: 1. prior to applying patchset or performing migration. 2. to move database to another server and resetlogs is no desired. 3. Client wants to test disaster recovery restore/recovery without dba involvement 4. It depends ... Paul On Mon, 4 Oct 2004 09:43:58 -0400, Bobak, Mark <mark.bobak@xxxxxxxxxxxxxxx> wrote: > The argument I generally use here is: > 1.) In the case of a hot backup, there is no mechanism > by which you can get a consistent copy of on-line redo. > 2.) In the case of a cold backup, step 1 is ALWAYS a=20 > clean, normal (non-aborted) shutdown. If that's true, > then the on-line redo doesn't contain any useful information. > > Given that, never, ever, backup your on-line redo log. > > -Mark -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l