Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Query Database while shutdown in progress

RE: Query Database while shutdown in progress

From: Robert Freeman <>
Date: Wed, 27 Jun 2007 14:55:04 -0600
Message-ID: <>

And there is a *very* good point made in that page. If you work in an environment where 9 nines is the target, shutdown abort might well be the only way to achieve that when you are needing to shutdown the database. A shutdown immediate can take FOREVER to run in a number of different situations.

Besides.... if the database isn't going to recover from a shutdown abort, it isn't going to recover from having the power pulled on it. Either way, it's a BUG, a BAD BAD BUG and should be corrected post-haste.

One should never make an operational decision (as this is in my opinion) without all the facts. This is a discussion that has come up more times that I can count. I'm fairly certain you will not be able to find me a recognized Oracle expert that agrees with the opinion "Don't do a shutdown abort". I believe (and if you all know otherwise let me know) that at various times I've seen threads from Tom Kyte, Cary Millsap, Jonathan Lewis and other folks well versed on Oracle on this topic... Nay, even should I say experts, going back several years.

Me, I'm just a spurt. No Ex about me.


Robert G. Freeman
Oracle Consultant/DBA/Author
Principal Engineer/Team Manager
The Church of Jesus Christ of Latter-Day Saints Father of Five, Husband of One,
Author of various geeky computer titles
from Osborne/McGraw Hill (Oracle Press)
Oracle Database 11g New Features Now Available for Pre-sales on! Sig V1.1

  -----Original Message-----
  From: Jared Still []   Sent: Wednesday, June 27, 2007 2:46 PM   To:
  Subject: Re: Query Database while shutdown in progress

  On 6/27/07, <> wrote:     However, (Not from Oracle), I have heard oracle has gotten a lot better with abort – as in not as dangerous or fearsome. I just like synchronizing all the file headers etc…. Does killing the session stop the rollback? If not, then monitoring the alert log for the offending user is nice but doesn't save very many minutes.


  Jared Still
  Certifiable Oracle DBA and Part Time Perl Evangelist

Received on Wed Jun 27 2007 - 15:55:04 CDT

Original text of this message