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

Other related posts: