Re: Query Database while shutdown in progress

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: "Andrew Kerber" <andrew.kerber@xxxxxxxxx>
  • Date: Wed, 27 Jun 2007 10:55:36 -0700

On 6/27/07, Andrew Kerber <andrew.kerber@xxxxxxxxx> wrote:

Sometime shutdown abort is necessary.  However, its not recommended.  I
would rather not risk having to recover a database w/o a good reason.  If
all that is needed is to monitor a shutdown immediate. there are a lot of
ways to handle that.  If  nothing else, you can tail the alert log, and see
the id thats keep the instance form shutting down, then kill that session.
That would be much safer than an abnormal termination of the instance.


Why is shutdown immediate safer than shutdown abort?


--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: