Re: force clean database shutdown

<div class="mail">
<address class="headers">
<span id="from">
<dfn>From</dfn>: Brian Peasland <oracle_dba_at_nospam.peasland.net>
</span>
<span id="date"><dfn>Date</dfn>: Thu, 8 Jun 2006 19:32:09 GMT</span>
<span id="message-id"><dfn>Message-ID</dfn>: <J0K3Lt.C2G_at_igsrsparc2&#46;<!--nospam-->er.usgs.gov>
</span>
</address>

<br>

maxim2k wrote:
<br>
<i class="quotelev1">> On 6/8/06 6:30 PM, Brian Peasland wrote:</i><br>
>> Does your dbshut script perform a simple SHUTDOWN or SHUTDOWN NORMAL?
<br>
<i class="quotelev1">> </i><br>
<i class="quotelev1">> The dbshut script I'm using is shipped with Oracle Database 10g R2 and </i><br>
<i class="quotelev1">> already uses SHUTDOWN IMMEDIATE.</i><br>
<i class="quotelev1">> </i><br>
<i class="quotelev1">> Any other idea?</i><br>
<i class="quotelev1">> </i><br>
<i class="quotelev1">> Thanks.</i><br>

Another option is to have your shutdown script perform SHUTDOWN ABORT, followed by STARTUP RESTRICT, followed by SHUTDOWN IMMEDIATE. This is not a preferred solution but it does work.

<strong>HTH,
</strong>
<br>

Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam&#46;<!--nospam-->peasland.net


<a href="http://www.peasland.net">http://www.peasland.net</a>


Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown


<span id="received"><dfn>Received on</dfn> Thu Jun 08 2006 - 14:32:09 CDT</span>

</div>