Re: Shutdown Abort

From: <JApplewhite_at_austinisd.org>
Date: Tue, 3 Jul 2007 14:49:15 -0500
Message-ID: <OFFD7DC257.63168DF1-ON8625730D.006C5629-8625730D.006CFD01@austinisd.org>

I never saw my lttle contribution to this during the last thread ("Query Database while shutdown in progress"), so here it is again - only because it shows that Oracle Corp. RECOMMENDS Shutdown Abort in their RMan docs. Of course we all know that Startup Force does a Shutdown Abort as the first step.

Startup Force IS, actually, recommended. Check out the 9i RMan demo file case1.rcv in $ORACLE_HOME/rdbms/demo. Also, in your 10g docs, check out Backup and Recovery Advanced User's Guide ...6 Making Backups with RMAN: Advanced Topics ......Backing Up in NOARCHIVELOG Mode: Example

In both cases Oracle recommends a Startup Force / Shutdown Immediate / Startup Mount sequence to get your NoArchivelog database properly ready for its RMan backup.

Works for us in all our Dev and Test DB RMan backups.

Jack C. Applewhite - Database Administrator Austin (Texas) Independent School District 512.414.9715 (wk) / 512.935.5929 (pager)

I'll just sit back in the shade while everyone gets laid. That's what I call Intelligent Design. -- God ("Origin of Species": Chris Smither)

Jeremiah Wilton <jeremiah_at_ora-600.net>
Sent by: oracle-l-bounce_at_freelists.org
07/03/2007 01:35 PM
Please respond to
jeremiah_at_ora-600.net

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

Received on Tue Jul 03 2007 - 14:49:15 CDT