RE: anyway to restart mmon after database shutdown is cancelled?
Date: Fri, 10 Jun 2011 07:26:48 -0400
Message-Id: <4DF1C7380200000B004D62B6_at_groupwise.gcrta.org>
Due to a memory leak in MMON, we kill it nightly and the database automatically restarts it.
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
Information Systems
1240 W. 6th Street
Cleveland, Ohio 44113
>>> "Bobak, Mark" <Mark.Bobak_at_proquest.com> 6/9/11 6:20 PM >>>
Ah, that actually makes sense. It does seem an odd state to be in.
Honestly, if it was me, I'd take my lumps, get approved to do a 'startup force' (likely the quickest way to complete bounce) and be comfortable that there are no lurking surprises....:-)
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Thomas A. La Porte
Sent: Thursday, June 09, 2011 6:01 PM
To: ORACLE-L
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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
>
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 10 2011 - 06:26:48 CDT