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@xxxxxxxxxxxxxxx
www.proquest.com
www.csa.com
ProQuest...Start here.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Jeremiah Wilton
Sent: Tuesday, July 03, 2007 1:47 PM
To: jkstill@xxxxxxxxx
Cc: randyjo@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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
