Re: Killing pmon service - does Oracle backout?

And if it doesn't clean up on the way up do another shutdown immediate or normal and let it take as long as it needs to clean up.

Ruth
----- Original Message -----
From: "Koivu, Lisa" <lkoivu_at_qode.com>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, January 16, 2001 11:20 AM Subject: RE: Killing pmon service - does Oracle backout?

> Tony, could you not do a shutdown abort?
>
> Killing pmon or smon is pretty much the equivalent of a shutdown abort
> (instance crash). 99.99% of the time the database will clean itself up
when
> you bring it back up after a shutdown abort. Only once has a shutdown
abort
> put one of my (production) databases into recovery mode.
>
>
> Lisa Rutland Koivu
> Oracle Database Administrator
> Qode.com
> 4850 North State Road 7
> Suite G104
> Fort Lauderdale, FL 33319
>
> V: 954.484.3191, x174
> F: 954.484.2933
> C: 954.658.5849
> http://www.qode.com
>
> "The information contained herein does not express the opinion or position
> of Qode.com and cannot be attributed to or made binding upon Qode.com."
>
>
> -----Original Message-----
> Sent: Tuesday, January 16, 2001 9:37 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Hi!!,
>
> I recently hosed our test system and could not get into any utility
> applications (SQLPLUS, SVRMGRL, ..) and I needed to bring down some hung
> instances. (The system is Sun Solaris release 2.6 using Oracle 8.1.6) I
> ended up canceling the PMON task of the various instances to get them to
> come down. They all terminated and I was sure that I was going to have to
> do a recovery to get them to come back up. To my surprise all the
instances
> came up fine after getting everything functionable.
>
> Does anyone know what happens when you cancel PMON that allowed this
> to happen? Did SMON clean things up before the instances terminated? I
> hope I don't have a false sense of comfort!?
>
> Thanks in advance for your input!!!
>
> Tony Barker
> DBA - State of Indiana
> tbarker_at_doit.state.in.us (317)232-0719
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Barker, Tony
> INET: tbarker_at_doit.state.in.us
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Jan 16 2001 - 10:43:00 CST