Message-Id: <10704.124104@fatcity.com> From: Janardhana Babu Date: Fri, 8 Dec 2000 11:42:23 -0800 Subject: RE: shutdown for backup : pro's and con's What about ... SHUTDOWN IMMEDIATE Wait/pause for 15 minutes.. If the DB STATUS is -1 or hung then SHUTDOWN ABORT STARTUP RESTRICT SHUTDOWN NORMAL else nothing end if; -- Janardhana Babu -----Original Message----- From: Joseph S. Testa [mailto:teci@oracle-dba.com] Sent: Friday, December 08, 2000 5:47 AM To: Multiple recipients of list ORACLE-L Subject: Re: shutdown for backup : pro's and con's how about a variation on a theme, alter system checkpoint SHUTDOWN ABORT STARTUP RESTRICT SHUTDOWN NORMAL joe thats that i use in a non0terminal based script. Pat Howe - Contractor wrote: > > 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 > > > -- Joe Testa http://www.oracle-dba.com No you can't fix an ORA-600 error, call Oracle Support. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: teci@oracle-dba.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).