Message-Id: <10704.124032@fatcity.com> From: Satar Naghshineh Date: Fri, 8 Dec 2000 07:34:53 -0800 Subject: RE: shutdown for backup : pro's and con's This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C0612C.69359F90 Content-Type: text/plain To me, both options are acceptable. I would prefer shutdown immediate because it involves fewer steps. Regards, Satar > -----Original Message----- > From: Pat Howe - Contractor [SMTP:pat.howe@Terabeam.com] > Sent: Friday, December 08, 2000 3:34 AM > 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 > > > or > > SHUTDOWN IMMEDIATE > > > 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@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@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). ------_=_NextPart_001_01C0612C.69359F90 Content-Type: text/html Content-Transfer-Encoding: quoted-printable RE: shutdown for backup : pro's and con's

To me, both options = are acceptable. I would prefer shutdown immediate because it involves = fewer steps.

Regards,
Satar

    -----Original Message-----
    From:   Pat Howe - Contractor = [SMTP:pat.howe@Terabeam.com]
    Sent:   Friday, December 08, 2000 3:34 AM
    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@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@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 =