Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Immediate v. Abort

Re: Immediate v. Abort

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Fri, 04 Apr 2003 03:23:37 -0800
Message-ID: <F001.0057A3C0.20030404032337@fatcity.com>

There have been a number of emails on this thread a few months ago. Check the archives.
Some people [including me] are comfortable with SHUTDOWN ABORT,STARTUP RESTRICT, SHUTDOWN NORMAL
while others are NOT comfortable with the SHUTDOWN ABORT. It depends on your experiences with SHUTDOWN ABORT situations.

I do have my production databases going down "quickly" with ABORT,RESTRICT,NORMAL. Hemant
At 06:33 PM 03-04-03 -0800, you wrote:
>I'm sensing a great opportunity here. It seems like the discussion is more
>about what people do and don't do, instead of being a technical discussion
>of what happens in a shutdown immediate v. a shutdown abort, what are the
>pros and cons, what are the risks to each approach.
>
>I would love to see this issue addressed by the very knowledgeable in the
>matters of recovery in a detailed and supported manner. I think this
>approach will provide people on each side with the information they need
>to make a rational decision, whether it is to stay the course or change.
>
>Anyone accept the challenge? I'll put up a bottle of good Scotch (no Black
>Adder Raw Cask) or one of my pictures (ask Rachel) to the person who
>changes my mind or reinforces my current view.
>
>--
>Daniel W. Fink
>http://www.optimaldba.com
>
>IOUG-A Live! April 27 - May 1, 2003 Orlando, FL
> Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL
> Thursday, May 1 1:00pm - 2:00pm - Automatic Undo Internals
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Daniel W. Fink
> INET: optimaldba_at_yahoo.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).

Hemant K Chitale
My personal web site is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

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 Fri Apr 04 2003 - 05:23:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US