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

Yes, I WHOLE heartedly agree, and we do a shutdown immediate now, but the point is... Oracle SUPPORT seems to be of the opinion that rather than trying to figure out what is 'wrong' we should just do a shutdown abort it 'Is a valid solution'. I'm guessing there IS a REASON it is doing this... and that it is only doing it in one of my three financials instances CONSISTENTLY... and NOT the one that was the source of the recent clone.  

ajw

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

The differences are
1. shutdown abort - is more drastic, no new users are allowed to log in, disconnects current sessions without rollback, recovery however would have to be done when restarted.
2. shutdown immediate - no new users are allowed to log in, terminating current connections, transactions terminated are rollbacked, recovery would not happen at restart
3. shutdown normal - no new users are allowed to log in, transactions in progress are rollbacked, but would wait for all existing transactions to finish and users to log off, so if a user is logged in when shutdown normal is executed, it would wait forever.  

So shutdown immediate is much quicker and safer. ...Ishrat  

-----Original Message-----
Sent: Monday, July 22, 2002 9: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: April Wells
  INET: awells_at_csedge.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).



text/plain attachment: InterScan_Disclaimer.txt