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