Re: shutdown immediate

Thanks. I am pretty sure that this is the case.

thank you

Gene Gurevich

                                                                           
             "Roman                                                        
             Podshivalov"                                                  
             <roman.podshivalo                                          To 
             v_at_gmail.com>              genegurevich_at_discover.com           
                                                                        cc 
             07/25/2008 03:10          oracle-l_at_freelists.org              
             PM                                                    Subject 
                                       Re: shutdown immediate              
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           

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