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).
