Re: shutdown immediate
From: Mir M. Mirhashimali <mhyder_at_rice.edu>
Date: Fri, 25 Jul 2008 15:23:42 -0500
Message-ID: <488A364E.8060001@rice.edu>
Date: Fri, 25 Jul 2008 15:23:42 -0500
Message-ID: <488A364E.8060001@rice.edu>
If there is a long running transaction and the shutdown immediate was
issued before the transaction completes then the rollback takes some
time and a lot of redo is generated. I have seen this happen couple times.
-- Mir M. Mirhashimali Oracle Systems Manager Database Architecture, Enterprise Applications Rice University (713) 348 6365 genegurevich_at_discover.com wrote:Received on Fri Jul 25 2008 - 15:23:42 CDT
> 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
>
>
>
> !DSPAM:59,488a2df8147052001346280!
>
>
>
-- http://www.freelists.org/webpage/oracle-l