RE: shutdown abort / startup restrict / shutdown vs. shutdown imm

I don't necessarily agree that shutdown immediate is quicker. If you force a checkpoint prior to the shutdown abort the subsequent crash recovery upon startup is usually pretty fast. Parallel recovery could be a factor as well.
- Rich

-----Original Message-----
Sent: Tuesday, July 23, 2002 1:14 PM
To: Multiple recipients of list ORACLE-L immedia

For openers, shutdown immediate is generally quicker than the combination of shutdown-abort/startup-restrict/shutdown-normal. It is also gentler. Consider the analogy of shutting down a Windows desktop computer. Is it preferable to do a standard software shutdown (and maybe tell Windows that you really want to end that hung process) or is it preferable to yank the plug out of the wall then plug it back in again, start up the machine, then shut it down gracefully? I always try to shut Windows down gracefully and only pull the plug when the damn thing is too stupid or brain dead to figure out what shutdown means. I do the same with Oracle. Kevin Kennedy
First Point Energy Corporation

-----Original Message-----
Sent: Monday, July 22, 2002 7:53 PM
To: Multiple recipients of list ORACLE-L

> -----Original Message-----
> From: April Wells [ mailto:awells_at_csedge.com <mailto:awells_at_csedge.com> ]
>
> The solutions (the ones that I got) aren't good ones.
>
> Shutdown abort/startup restricted/ shutdown immediate... (a 'VALID
> solution'???)

This might be a naive question, but why is -> shutdown immediate
better than
-> shutdown abort / startup restrict / shutdown normal ?

(That is assuming of course that no user / job will try to sneak in after you do the startup restrict)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gesler, Rich
  INET: RGesler_at_lexington.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).