RE: Question in HOT BACKUP
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <FREEMANR@xxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 4 Oct 2004 14:00:00 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Freeman Robert - IL
Sent: Monday, October 04, 2004 1:11 PM
To: 'oracle-l@xxxxxxxxxxxxx '
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@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=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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
