RE: anyway to restart mmon after database shutdown is cancelled?
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "sacrophyte@xxxxxxxxx" <sacrophyte@xxxxxxxxx>
- Date: Thu, 9 Jun 2011 18:28:20 -0400
Hmm…ORA-00448 doesn’t say much….
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@xxxxxxxxx]
Sent: Thursday, June 09, 2011 6:26 PM
To: Bobak, Mark
Cc: Thomas.LaPorte@xxxxxxxxxxxxxx; 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@xxxxxxxxxxxx<mailto:Mark.Bobak@xxxxxxxxxxxx>>
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@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>] 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@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
> [mailto: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
>
--
//www.freelists.org/webpage/oracle-l
--
Charles Schultz
Other related posts:
