Re: shutdown immediate

From: Roman Podshivalov <roman.podshivalov_at_gmail.com>
Date: Fri, 25 Jul 2008 16:10:23 -0400
Message-ID: <55f303590807251310sa2429aif030cdf533a79082@mail.gmail.com>


Hi,

I saw this happening in the scenario like:

- there is a long running transaction running in the database
- somebody shutdown abort the instance
- startup
- shutdown immediate right after the startup when we still have instance
recovery running

In such situation shutdown immediate will wait until instance recovery completes.

--romas

On 7/25/08, genegurevich_at_discover.com <genegurevich_at_discover.com> wrote:
>
> Hello.
>
> I am trying to shutdown immediate a database (10.2.0.3). Normally it takes
> couple of minutes. this time it has been
> running for about 25 min. When I look at the alert.log, I see already 4 log
> switches ( I have 3 logfile groups) and I
> wonder what could be the reason it is taking such a long time. I also don't
> remember seeing all the logswitches
> after the shutdown immediate.
>
> Would appreciate any thoughts
>
> thank you
>
> Gene Gurevich
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jul 25 2008 - 15:10:23 CDT

Original text of this message