RE: Shutdown Abort

I'll just add, if you want a fast (abort) shutdown followed by a startup, i.e., a quick bounce, (for example to pick up some new spfile parameters), try this: Alter system checkpoint;
Startup force

If you want a clean, consistent shutdown (for a cold backup, for example), try this: Alter system checkpoint;
Startup force restrict;
Shutdown immediate;

-Mark

PS 'startup force' == 'shutdown abort' + 'startup'

--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
734.997.4059  or 800.521.0600 x 4059
mark.bobak_at_il.proquest.com
www.proquest.com
www.csa.com

ProQuest...Start here. 


-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeremiah Wilton
Sent: Tuesday, July 03, 2007 1:47 PM
To: jkstill_at_gmail.com
Cc: randyjo_at_sbcglobal.net; oracle-l_at_freelists.org
Subject: Re: Shutdown Abort

Thanks Jared.  It has taken all of my strength to not reply to some of 
the most egregious postings in this thread.  My more recent blurb on 
shutdown abort can be found on page four of my 2004 HA paper:

http://www.ora-600.net/articles/stayinalive.pdf

I will confirm that practically every site that requires very high 
availability uses 'abort' as SOP.  I am really surprised and 
disappointed by the wild theoretical conjecture that accompanies the 
steadfast resistance to 'abort'.

Speaking of wild theoretical conjecture, thanks to Alex G. for his 
recent rants on DBAs and guessing.  I have long been an opponent of the 
'guessing method' of Oracle tuning, which goes hand in hand with the 
'try a bunch of stuff' method of Oracle troubleshooting :-)

Best to all, including the guessers,

Jeremiah Wilton
ORA-600 Consulting
http://www.ora-600.net

Jared Still wrote:


> 

> Please see http://www.speakeasy.org/~jwilton/oracle/shutdown-abort-bad.html

> 

> If you are not familiar with Jeremiah Wilton, he was a DBA at Amazon.com 

> <http://Amazon.com> from early days.

> 

> Amazon has a few databases, and they were/are regularly shutdown with 

> abort.

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l