RE: RE: ResetLogs

Yong,

I agree with you that there is a small benefit as you described. However, I would like to point out that there is also a risk when you backup online redo logs for cold backup. Let say that you need to restore part of the cold backup during a recovery. The SA might accidently (or think he heard you say that :) ) restore the online redo logs thus over writing your existing online redo logs. Now you won't be able to do a complete recovery. I think that's the reason Oracle recommend NOT to backup online redo logs for cold backup. I think Oracle support has seen enough of this happened. :)

My 2 cents

Richard Ji

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of sfaroult_at_oriole.com
Sent: Thursday, January 11, 2001 11:28 AM To: Multiple recipients of list ORACLE-L Subject: Re: RE: ResetLogs

Yong,

   The key is, as you say, 'normal shutdown'. Suppose that, for a reason or another (usual DBA on holidays, processes killed in what an unsuspecting SE thought to be 'normal shutdown' or whatever) the shutdown wasn't as normal as you expected it to be ?
You would look rather silly at the time of restore. Given that backing up the redo logs doesn't cost much, and even if it's unnecessary in 99.9% of cases, well, I feel better if this extra 0.1% is also covered. I do like Christian, and always backup them.

Regards,

Stephane Faroult
Oriole Corporation

>Hi, Christian,
>
>Why do you have to back up redo logfiles when you do cold backup? Are you
>saying there could be some remaining redo records left in redo logs, even
with
>a normal shutdown?
>
>Yong Huang
>yong321_at_yahoo.com
>
>"Trassens, Christian" wrote:
>
>No if it is a cold backup. However and in terms of recovery, if you don't
>backup the redo logs, you'll need it.
>
>Oracle recommends not to backup redo logs, but in the case of cold backups
>you should do it because of the absence of archives.
>
>__________________________________________________
>Do You Yahoo!?
>Yahoo! Photos - Share your holiday photos online!
>http://photos.yahoo.com/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: yong huang
> INET: yong321_at_yahoo.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>

--
This mail was sent through http://www.mail-inspector.de
Mail Inspector is a free service of http://www.is-fun.net CHECK OUT !

This mail was sent from host 194.3.142.126
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may