Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Question in HOT BACKUP

RE: Question in HOT BACKUP

From: Freeman Robert - IL <FREEMANR_at_tusc.com>
Date: Mon, 4 Oct 2004 12:10:52 -0500
Message-ID: <F5E885BEF9540D47A7BDC03CF16880870A7D5177@tuscil_ex1>


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=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
Received on Mon Oct 04 2004 - 12:06:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US