RE: Question in HOT BACKUP

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Mon, 4 Oct 2004 14:00:00 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF275A9A88@AABO-EXCHANGE02.bos.il.pqe>

Yes, I thought about that point, Robert. Just another good argument against backing up on-line redo.

My favorite argument is:
Please describe a valid backup/recovery scenario where a backup copy of on-line redo is required to succeed. (Hint, there isn't one!)

Also, I'd argue that anyone who backs it up "just because" or "because we want it", is simply demonstrating a lack of underatanding of basic backup and recovery principles.

Ok, that last statement will probably ruffle some feathers.... Sorry, I don't accept "I don't want to type 'resetlogs'" as a=20 valid argument.

-Mark

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Freeman Robert - IL Sent: Monday, October 04, 2004 1:11 PM
To: 'oracle-l_at_freelists.org '
Subject: RE: Question in HOT BACKUP

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_at_freelists.org
To: mark.bobak_at_il.proquest.com
Cc: oracle-l_at_freelists.org
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_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=3D20
> clean, normal (non-aborted) shutdown. If that's true,
> then the on-line redo doesn't contain any useful information.

>=20

> Given that, never, ever, backup your on-line redo log.
>=20
> -Mark

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 04 2004 - 12:55:34 CDT