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 !