the problem is, if immediate hangs and you have automated the process... nothing happens. it doesn't time out so you sit. and sit and sit. and hope that whatever is keeping the database active will eventually end.
In version 7 (7.3.2) I found that while using a third party monitoring package that had a job in the job queue that ran frequently enough (and you WANT monitoring software to monitor things!) that we could never use a shutdown immediate --- "Pardee, Roy E" <[EMAIL PROTECTED]> wrote: > I am certainly not suggesting that recovery can't handle a crash--I'm > just > trying to make sure that I understand what shutdown abort does. Some > posts > have implied that it's no big deal, which is counter-intuitive to me. > To > me, crashing a program on purpose seems like a drastic measure. No > doubt > desperate times can call for desperate measures, but I would have > guessed > that optimally, you'd try immediate first & then abort if immediate > takes > too long. But I'm just learning this stuff... > > Cheers, > > -Roy > > Roy Pardee > Programmer/Analyst > SWFPAC Lockheed Martin IT > Extension 8487 > > -----Original Message----- > Sent: Wednesday, April 02, 2003 6:34 PM > To: Multiple recipients of list ORACLE-L > > > yeah so? are you suggesting that Oracle instance recovery can't > handle > a database crash? If so, better pray your server never crashes. > > > --- "Pardee, Roy E" <[EMAIL PROTECTED]> wrote: > > Well... my official oracle instructor in dba larva school said that > > it's > > tantamount to crashing the db--or so I recall anyway. This isn't > so? > > > > Peace, > > > > -Roy > > > > Roy Pardee > > Programmer/Analyst > > SWFPAC Lockheed Martin IT > > Extension 8487 > > > > -----Original Message----- > > Sent: Wednesday, April 02, 2003 2:09 PM > > To: Multiple recipients of list ORACLE-L > > > > > > On Wed, 2 Apr 2003, Chris Berry wrote: > > > > > Shutdown abort is pretty drastic, are you sure shutdown immediate > > > didn't work? > > > > What is drastic about shutdown abort? > > > > Never one to opt out of a shutdown abort thread, > > -- > > Jeremiah Wilton > > http://www.speakeasy.net/~jwilton > > > > - Uses shutdown abort exclusively > > - successful shutdowns/startups: over 10,000 > > - problems with shutdown abort: 0 > > - versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta) > > - still employed! > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Pardee, Roy E > 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). > __________________________________________________ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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).
