Re: shutdown immediate

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: Sun, 27 Jun 1999 22:36:19 -0700
Message-ID: <Pine.OSF.4.02.9906272233050.14413-100000@gonzo.wolfenet.com>

On 24 Jun 1999, Bass Chorng wrote:

> If shutdown immediate seems to hang, shutdown abort does not
> make it any better. It will do the rollback when coming up,
> instead of going down.

Actually, in Oracle versions >= 7.3, the rollback portion of crash recovery will be deferred until after the database is open and available (this is what background TX recovery is), making SHUTDOWN ABORT a little better than SHUTDOWN IMMEDIATE if avoiding downtime is the goal.

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah Received on Mon Jun 28 1999 - 00:36:19 CDT