Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

Re: Query Database while shutdown in progress

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Wed, 27 Jun 2007 12:43:05 -0500
Message-ID: <ad3aa4c90706271043t4f9ec2ddi97b924a0849e9fc7@mail.gmail.com>


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.

On 6/27/07, Jared Still <jkstill_at_gmail.com> wrote:
>
> On 6/27/07, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:
> >
> > I dont think a startup force is a good idea. Last time I checked that
> > did a shutdown abort followed by a startup.
>
>
> Same old debate.
>
> What's wrong with shutdown abort?
>
> Sometimes it is necessary.
>
> In flight transactions get rolled back either way.
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 27 2007 - 12:43:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US