Just as a side note:
I have used in the past the following:
startup force restrict
shutdown immediaate
This seems to work well, but I have had some folks cringe at using the startup
force command. Anyone have any comments on this?
Thanks
Tom Tyson
- "Koivu, Lisa" <lkoivu_at_qode.com> wrote:
> 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-----
> Sent: Thursday, December 07, 2000 10:34 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> 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).
>
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
Received on Fri Dec 08 2000 - 22:15:52 CST
