Re: anyway to restart mmon after database shutdown is cancelled?

  • From: David Fitzjarrell <oratune@xxxxxxxxx>
  • To: Thomas.LaPorte@xxxxxxxxxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 9 Jun 2011 15:11:58 -0700 (PDT)

That was my take as well, and Mark's suggestion appears to be the best so far; 
I 
would try it if  I were in a similar situation.

David Fitzjarrell





________________________________
From: Thomas A. La Porte <Thomas.LaPorte@xxxxxxxxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Sent: Thu, June 9, 2011 3:00:34 PM
Subject: RE: anyway to restart mmon after database shutdown is cancelled?

I inferred from Charles' original message that they the shutdown of the 
database 
was inadvertent, and that they had managed to cancel it before the shutdown had 
actually completed. The database was still "up" (at least from the user's 
perspective) and he was now looking for a way that he might salvage it without 
any downtime to the end users.

-- Tom

On Thu, 9 Jun 2011, Bobak, Mark wrote:

[...]
> Finally, I’m not sure why folks are so cautious of shutdown abort and/or 
>startup force.  It should be perfectly safe to do so.
> 
> -Mark
[...]
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
>Behalf Of Charles Schultz
> Sent: Thursday, June 09, 2011 3:30 PM
> To: ORACLE-L
> Subject: anyway to restart mmon after database shutdown is cancelled?
> 
> We had a dba boo-boo today; and now I have a curious issue on my hands. MMON 
>and several other background processes are down, but the instance seems to 
>have 
>other recovered after an errant shutdown command was cancelled. So far Google 
>has not shown me anything helpful. Wondering if there any tricks out there.
> 
> Oracle Enterprise Edition, 11.1.0.7.7
> Sun Solaris 10
> 
> --
> Charles Schultz
>

Other related posts: