Re: force clean database shutdown

<div class="mail">
<address class="headers">
<span id="from">
<dfn>From</dfn>: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
</span>
<span id="date"><dfn>Date</dfn>: Fri, 09 Jun 2006 12:06:08 +0200</span>
<span id="message-id"><dfn>Message-ID</dfn>: <nshi821nod949s5qdria832ktn21clofm8_at_4ax&#46;<!--nospam-->com>
</span>
</address>

<br>

On Fri, 09 Jun 2006 09:55:15 +0200, maxim2k <maxim2k_at_gmail&#46;<!--nospam-->com> wrote:

<i class="quotelev1">>On 6/8/06 9:32 PM, Brian Peasland wrote:</i><br>
<i class="quotelev2">>> Another option is to have your shutdown script perform SHUTDOWN ABORT, </i><br>
<i class="quotelev2">>> followed by STARTUP RESTRICT, followed by SHUTDOWN IMMEDIATE. This is </i><br>
<i class="quotelev2">>> not a preferred solution but it does work.</i><br>
<i class="quotelev1">></i><br>
<i class="quotelev1">>Thanks, I'll give it a try.</i><br>
<i class="quotelev1">></i><br>
<i class="quotelev1">>Can I ask why it's not a preferred solution? Is there anything that can </i><br>
<i class="quotelev1">>go wrong with it?</i><br>
<i class="quotelev1">></i><br>
<i class="quotelev1">>Thanks.</i><br>
<br>

if you really want to be quick

startup open force restrict

which is equivalent
<br>

to
<br>

shutdown abort
<br>

startup restrict

But then again, in both cases you just crash the instance, and you'll get crash recovery when starting up (look in your alert to verify this).
<br>

That can go wrong, but also it takes time.

--
Sybrand Bakker, Senior Oracle DBA


<span id="received"><dfn>Received on</dfn> Fri Jun 09 2006 - 05:06:08 CDT</span>

</div>