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

One vote for:

SHUTDOWN immediate
STARTUP RESTRICT
(practive backup of control file)
SHUTDOWN NORMAL
<BACKUP>

Cheers,

Earl

On Fri, 08 Dec 2000 07:51:36
 Kevin Kostyszyn wrote:
>RE: shutdown for backup : pro's and con'sPersonally, we do a shutdown
>immediate. As far as I know, if you don't do it this way and then say try
>to bring the database up on another machine with using the same name and the
>datafiles and init file, the redo logs will be corrupt and the database will
>not come up. I would go with the shutdown immediate.
>
>Kevin Kostyszyn
>DBA, Dulcian, Inc
> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Koivu, Lisa
> Sent: Friday, December 08, 2000 8:26 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: shutdown for backup : pro's and con's
>
>
> Hi Pat,
>
> I have to use SHUTDOWN ABORT/STARTUP RESTRICT/SHUTDOWN IMMEDIATE.
>Otherwise our databases hang due to some refresh jobs that run continually,
>and my backups never start. I haven't had any problems. Think about it -
>If you startup and shutdown nice after a shutdown abort, the database has a
>chance to clean itself up.
>
> HTH
>
> Lisa Rutland Koivu
> Oracle Database Administrator
> Qode.com
> 4850 North State Road 7
> Suite G104
> Fort Lauderdale, FL 33319
>
> V: 954.484.3191, x174
> F: 954.484.2933
> C: 954.658.5849
> http://www.qode.com
>
> "The information contained herein does not express the opinion or position
>of Qode.com and cannot be attributed to or made binding upon Qode.com."
>
>
>
> -----Original Message-----
> From: Pat Howe - Contractor [mailto:pat.howe_at_Terabeam.com]
> Sent: Thursday, December 07, 2000 10:34 PM
> To: Multiple recipients of list ORACLE-L
> Subject: shutdown for backup : pro's and con's
>
>
>
>
> I would like to be convinced one way or the other on the following issue :
> What is the best way to take a database down for a cold backup ?
>
> SHUTDOWN ABORT
> STARTUP RESTRICT
> SHUTDOWN NORMAL
> <BACKUP>
>
> or
>
> SHUTDOWN IMMEDIATE
> <BACKUP>
>
> I have seen both widely used.
> I have always stayed away from the ABORT option because I am uneasy about
> taking any database down this way (hard).
> I am looking for a dialog on the pro's and con's of each approach.
> ie: Any horror stories about taking down with the ABORT option ?
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Pat Howe - Contractor
> INET: pat.howe_at_Terabeam.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).
>
>

Great Gift Idea! FREE cell phone, internet ready at Lycos Marketplace Received on Fri Dec 08 2000 - 10:10:34 CST