Re: anyway to restart mmon after database shutdown is cancelled?
- From: Charles Schultz <sacrophyte@xxxxxxxxx>
- To: Mark.Bobak@xxxxxxxxxxxx
- Date: Thu, 9 Jun 2011 17:25:40 -0500
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>
> 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]
> 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] 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:
