Re: RE: RE: Online vs offline backups

Ganesh Raja£¬ÄúºÃ£¡

     I little addon:
	You need not do a open resetlogs action, which invalidate your old backup, just do clear logfile/or add new drop old to open the database without resetlogs. right?

Good luck!

            chaos
            chaospku_at_163.net

zhu chao
DBA of Eachnet.com
86-021-32174588-667

ÔÚ 2002-06-19 06:48:00 You wrote:
>If you are not backing up the redo logs also youcan do a simple Alter
>database Open Restelogs before Opening the database. So that the redo logs
>are created. If you copy the Online Redo Logs This Step can be avaoided.
>
>HTH
>
>Best Regards,
>Ganesh R
>Tel : +971 (4) 397 3337 Ext 420
>Fax : +971 (4) 397 6262
>HP : +971 (50) 745 6019
>============================================
>Live to learn... forget... and learn again.
>============================================
>
>
>
>-----Original Message-----
>Sent: Wednesday, June 19, 2002 6:28 PM
>To: Multiple recipients of list ORACLE-L
>
>
>I disagree. Always backup the online redo logs when doing a cold backup.
>Rama Valpuri's book Oracle Backup and Recovery chapter 3 on physical backups
>says "...use the os backup utility to copy all the onine redo log files,
>databases files and control files."
>
>
>-----Original Message-----
>Sent: Wednesday, June 19, 2002 9:38 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Ferenc Mantfeld$B!$(J
>
>>The same person that advocated a cold backup
>>did not back up the online redo logs, so what use was it anyway, since
>>the only way they would force open their DB is with a resetlogs option
>>anyway.
> For cold backup, oracle does not recommend backup the online redo
>log. And if you restore the whole cold backup, why need the online redo log?
>I am sure people doing cold backup will do shutdown normal/immediate, not
>shutdown abort.So there is no need to backup the online redo log at all!
>Backup the online redo log also take the risk of damage the current online
>redo log when you want to do full recovery.
> So, never backup the online redo log when doing cold backup.
>
> $BCW(J
>$BNi!*(J
>
> chal_ping
> chaospku_at_163.net
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: chal_ping
> INET: chaospku_at_163.net
>
>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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Taylor, Shirley
> INET: TaylorSI_at_mar.dfo-mpo.gc.ca
>
>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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Ganesh Raja
> INET: ganesh_at_gtfs-gulf.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: chaos
  INET: chaospku_at_163.net

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).