Agreed. All that matters is the redo logs. If Oracle had named the shutdown options more accurately, that is
shutdown abort => shutdown fast shutdown immediate => shutdown hopefully shutdown transactional => shutdown when hell freezes over shutdown normal => shutdown never then I'm pretty sure I know what everyone would be using...An 'alter system checkpoint' just before the abort also helps startup times. hth connor --- Hemant K Chitale <[EMAIL PROTECTED]> wrote: > > > Comparing the shutdown scenarios with what would > happen if someone > were to "pull the plug" on the server is the best > way to explain the behaviour > of Oracle. > What if > a. Someone switched-off the server [there's a > power failure and the UPS > doesn't kick in] ? > b. The server crashes with a Unix Panic > well, the Oracle instance dies and yet, [as long as > the disks are still good, > even if you have to do an "fsck"] there's Instance > Recovery which goes through > successfully. > So what's the problem with SHUTDOWN ABORT ? Its > about the same thing, > but not as bad. > > I consistently use SHUTDOWN ABORT, STARTUP RESTRICT, > SHUTDOWN NORMAL > on Production, Mission-Critical databases. I've > never had a problem with a > SHUTDOWN ABORT. > Even a clone of an ABORTed instance can work if the > online redo logs and > current > control-file are also cloned ! > > I have seen SHUTDOWN IMMEDIATE hang very many times > [particularly when > DBMS_JOB jobs are running or the un-intelligent > Intelligent Agent is > connected]. > > Hemant > > At 05:29 PM 31-01-03 -0800, you wrote: > >Dan, > > > >If you look at Rama Velpuri's most famous treatise > on B & R - namely > >'Oracle8 Backup & Recovery Handbook' (Oracle > Press), you will see the path > >that the various shutdown options take. [Page 43, > Chapter 2: The Oracle > >Architecture and Configuration]. I belive this is > the closest that we could > >come to a published look under the covers. Some one > mentioned a switch > >logfile prior to the shutdown abort. In any case, a > shutdown abort would not > >be as bad as someone pulling the plug on the juice > (as in Cleaning lady: 'I > >need to plug in my hoover... aaah - here's a socket > I can use). The instance > >goes down not-so-gracefully, but the disk is still > safe as long as the > >server stays up. > > > >Just my $0.02. > >John Kanagaraj > >Oracle Applications DBA > >DBSoft Inc > >(W): 408-970-7002 > > > >I don't know what the future holds for me, but I do > know who holds my > >future! > > > >** The opinions and statements above are entirely > my own and not those of my > >employer or clients ** > > > > > > > -----Original Message----- > > > From: Fink, Dan [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, January 30, 2003 8:10 AM > > > To: Multiple recipients of list ORACLE-L > > > Subject: RE: Debate on rc commands Solaris and > Oracle > > > > > > > > > I know I am going to catch major grief for this, > but I avoid > > > shutdown abort > > > when possible. Shutdown immediate can take some > time, as it will do > > > transaction rollback in serial (where recovery > at startup can do it in > > > parallel and as needed). The main reason I avoid > it is that > > > there are known > > > bugs that will cause the database to be > unrecoverable when a > > > shutdown abort > > > is done while a kernel transaction is being > performed. > > > Granted, I have not > > > personally encountered this, and the chances of > encountering > > > it are slight, > > > but why take the risk? > > > > > > <Ducking and running for cover> > > > Dan Fink > > > > > > -----Original Message----- > > > Sent: Thursday, January 30, 2003 6:15 AM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > I'll echo that sentiment. > > > > > > 'shutdown abort', 'startup restrict' was a > regular part of my > > > shutdown scripts beginning in 1994 with 7.0.16, > as > > > 'shutdown immediate' wasn't all that reliable, > even in situations > > > where it should have worked. > > > > > > Jared > > > > > > On Wednesday 29 January 2003 15:53, John > Kanagaraj wrote: > > > > Rao, > > > > > > > > And where did you read that 'shutdown abort' > is not > > > recommended? This is > > > > another myth that has been busted a while ago. > A shutdown > > > abort followed > > > by > > > > a startup restrict and a normal shutdown is > the way to go > > > when dealing > > > with > > > > rogue sessions that open a connection and > never shutdown. > > > In such cases, a > > > > shutdown immediate will _never_ return > (certainly not > > > within your 5 to 10 > > > > minutes). I have been using this method for > more than 8 years now - > > > > starting at 7.0.16 fyi. The trick in this case > is to script > > > it into the rc > > > > commands. > > > > > > > > John Kanagaraj > > > > Oracle Applications DBA > > > > DBSoft Inc > > > > (W): 408-970-7002 > > > > > > > > I don't know what the future holds for me, but > I do know > > > who holds my > > > > future! > > > > > > > > ** The opinions and statements above are > entirely my own > > > and not those of > > > > my employer or clients ** > > > > > > > > > > > > -----Original Message----- > > > > Sent: Wednesday, January 29, 2003 11:49 AM > > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > Paula, > > > > > > > > Shutdown abort is not recommended as the file > checkpointing > > > is not done > > > > during shutdown abort. If you need to perform > shutdown > > > abort, then, it is > > > > preferred to bring up the db with startup > restrict (so that > > > the users > > > > wouldn't connect) and then, cleanly shutdown > the db and > > > bring it up again. > > > > > > > > Tell to your sys admins. that shutdown > immediate would take > > > some time > > > > (about 5 to 10 minutes) depending on the > activity on your > > > db. They would > > > > have to wait for that much time before calling > a DBA during > > > system boots. > > > > > > > > Rao > > > > > > > > -----Original Message----- > > > > Sent: Wednesday, January 29, 2003 11:30 AM > > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > > > > > System Administrator says he doesn't trust > that the rc > > > commands will stop > > > > if the database doesn't want to shutdown and > even if it > > > does would want to > > > > shutdown with scripts beforehand so that a DBA > could > > > connect and resolve > > > > the issue. Other DBA says this is all wrong > and rc commands should > > > include > > > > shutdown immediate of database. In the past I > had setup 2 > > > processes in > > > the > > > > system scripts for the sys admin - shutdown > immediate - > > > wait .... shutdown > > > > abort - on a read-only DSS system which of > course allows > > > some room for > > > this > > > > type of activity. I kind of would want to > know if a > > > database was going to > > > > be shutdown with an abort esp. in OLTP system > and do it myself. > > > > > > > > > > > > > > > > - any ideas > > > -- > > > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > > > -- > > > Author: Jared Still > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > > > San Diego, California -- Mailing list and > web hosting services > > > > --------------------------------------------------------------------- > > > To REMOVE yourself from this mailing list, send > an E-Mail message > > > to: [EMAIL PROTECTED] (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). > > > -- > > > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > > > -- > > > Author: Fink, Dan > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > > > San Diego, California -- Mailing list and > web hosting services > > > > --------------------------------------------------------------------- > > > To REMOVE yourself from this mailing list, send > an E-Mail message > > > to: [EMAIL PROTECTED] (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). > > > > >-- > >Please see the official ORACLE-L FAQ: > http://www.orafaq.net > >-- > >Author: John Kanagaraj > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > >San Diego, California -- Mailing list and > web hosting services > >--------------------------------------------------------------------- > >To REMOVE yourself from this mailing list, send an > E-Mail message > >to: [EMAIL PROTECTED] (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). > > Hemant K Chitale > My web site page is : http://hkchital.tripod.com > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Hemant K Chitale > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (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). > ===== Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
