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