Re: Question in HOT BACKUP

From: Paul Drake <bdbafh_at_gmail.com>
Date: Mon, 4 Oct 2004 13:00:19 -0400
Message-ID: <910046b4041004100044cd1bc7@mail.gmail.com>

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_at_il.proquest.com> 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

Received on Mon Oct 04 2004 - 11:55:54 CDT