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@xxxxxxxxxxx> Sent by: oracle-l-bounce@xxxxxxxxxxxxx 07/03/2007 01:35 PM Please respond to jeremiah@xxxxxxxxxxx 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. --