Re: shutdown for backup : pro's and con's

From: Murali Vallath <murali_vallath_at_hotmail.com>
Date: Fri, 08 Dec 2000 13:09:02 -0500
Message-Id: <10704.124085@fatcity.com>

SHUTDOWN IMMEDIATE sometimes takes for ever. I have used the methods described, but I normally force a CHECKPOINT before SHUTDOWN ABORT.

But, now I prefer RMAN backups.

Murali Vallath
Oracle Certified DBA
http://www8.ewebcity.com/muralivallath/
http://www.summerskyus.com/

From: Jonathan Gennick <jonathan_at_gennick.com> Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: Re: shutdown for backup : pro's and con's Date: Fri, 08 Dec 2000 09:04:25 -0800

SHUTDOWN IMMEDIATE should work, but I've always used a method similar to what you describe below just for the extra piece of mind that it gives me. NEVER do a backup immediately after a SHUTDOWN ABORT. Best regards,

Jonathan
mailto:jonathan_at_gennick.com
http://gennick.com

Thursday, December 07, 2000, 10:33:55 PM, you wrote:

PHC> I would like to be convinced one way or the other on the following issue :
PHC> What is the best way to take a database down for a cold backup ?

PHC> SHUTDOWN ABORT
PHC> STARTUP RESTRICT
PHC> SHUTDOWN NORMAL
PHC> <BACKUP>

PHC> or

PHC> SHUTDOWN IMMEDIATE
PHC> <BACKUP>

PHC> I have seen both widely used.
PHC> I have always stayed away from the ABORT option because I am uneasy about

PHC> taking any database down this way (hard).
PHC> I am looking for a dialog on the pro's and con's of each approach.
PHC> ie: Any horror stories about taking down with the ABORT option ?

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jonathan Gennick

INET: jonathan_at_gennick.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).

Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com Received on Fri Dec 08 2000 - 12:09:02 CST