Re: shutdown immediate hangs

From: Makbo <makbo2_at_netscape.net>
Date: Sun, 22 Sep 2002 01:08:36 GMT
Message-ID: <3D8D1813.4060608@netscape.net>

One "interesting thing" that can happen is if a tablespace is in hot backup state, it will falsely report "media recovery required" when you try to start back up. Oracle's documentation states how to clear this; nevertheless it's not a fun thing to have to do in the middle of the night. Also, under the right circumstances, I'd bet a distributed transaction could experience hiccups from this.

Recoverable, yes, supported, yes, desireable, no.

BTW, I've worked in environments both with daily "shutdown aborts" and without, my druthers are "shutdown immediate", which under Oracle 8i I have not seen hang (unlike 7.3.4). Why induce instance recovery if you don't have to?

On the other hand, I'm practical -- if "shutdown immediate" hangs in my environment and I can't come up with anything better in a reasonable time, then "shutdown abort" it is.

--Mark B.

Howard J. Rogers wrote:

> "Karen Abgarian" <abvk_at_ureach.com> wrote in message
> news:3D8C1067.BB75A82B_at_ureach.com...
>

[...]

>>There might be other interesting things related to aborting.
>>

>

[...]
>
> Unless you can come up with something better than "there might be other
> interesting things", your "argument" holds no water. As it is, it's little
> better than voodoo and being scared at shadows.
>

[...] Received on Sat Sep 21 2002 - 20:08:36 CDT