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
- Follow-Ups:
- RE: Query Database while shutdown in progress
- From: Robert Freeman
- References:
- Query Database while shutdown in progress
- From: Sinardy Xing
- Re: Query Database while shutdown in progress
- From: Jared Still
- Re: Query Database while shutdown in progress
- From: Andrew Kerber
- Re: Query Database while shutdown in progress
- From: Jared Still
- Re: Query Database while shutdown in progress
- From: Andrew Kerber
Other related posts:
- » Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
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.
- RE: Query Database while shutdown in progress
- From: Robert Freeman
- Query Database while shutdown in progress
- From: Sinardy Xing
- Re: Query Database while shutdown in progress
- From: Jared Still
- Re: Query Database while shutdown in progress
- From: Andrew Kerber
- Re: Query Database while shutdown in progress
- From: Jared Still
- Re: Query Database while shutdown in progress
- From: Andrew Kerber