RE: dbshut script - shutdown or shutdown immediate

From: Pardee, Roy E <roy.e.pardee_at_lmco.com>
Date: Thu, 03 Apr 2003 06:38:41 -0800
Message-ID: <F001.005794B8.20030403063841@fatcity.com>

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" <roy.e.pardee_at_lmco.com> 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: roy.e.pardee_at_lmco.com

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: ListGuru_at_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). Received on Thu Apr 03 2003 - 08:38:41 CST