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

00448, 00000, "normal completion of background process"

// *Cause:  One of the background processes completed normally (i.e. exited).
//     The background process thinks that somebody asked it to exit.
// *Action: Warm start the system.

Interesting that the suggested action seems to be to bounce the instance.

Oh well, thought the wakeup was worth a try….

-Mark
From: Charles Schultz [mailto:sacrophyte_at_gmail.com] Sent: Thursday, June 09, 2011 6:26 PM
To: Bobak, Mark
Cc: Thomas.LaPorte_at_dreamworks.com; ORACLE-L Subject: Re: anyway to restart mmon after database shutdown is cancelled?

Again, this is more of an academic question - we have already filed all the forms and dotted all the i's to bounce the database - in my opinion, that is besides the point.

I tried the wakeup, but it did not seem to do much.

Interesting that MMON was in v$bgprocess, though. Error = 448 2011/6/9 Bobak, Mark <Mark.Bobak_at_proquest.com<mailto:Mark.Bobak_at_proquest.com>> 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> [mailto: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> [mailto: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

--
Charles Schultz

--
http://www.freelists.org/webpage/oracle-l