Re: Instance , what instance.

From: Yong Huang <yong321_at_yahoo.com>
Date: 14 Aug 2001 07:33:53 -0700
Message-ID: <b3cb12d6.0108140633.5317542@posting.google.com>

So why did the database get corrupted? You mean it needs media recovery, right?

It's unusual only background processes are killed leaving shadow processes around (pulling power cord kills them all). It's even more unusual background processes are killed in the strict order of PIDs. I'm under the impression that if you init 0 (shutdown) as root, processes are killed in reverse order of PID or sort of. If shadow processes are left alone, it would be good if pmon is killed last.

Yong Huang
yong321_at_yahoo.com

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<997777377.25546.0.nnrp-02.9e984b29_at_news.demon.co.uk>...
> >> kill -9 pmon, dbwr, ckpt, smon etc, in order of PID.
> >
> >What did a 'ps -ef | grep ora' showed afterwards?
>
> All the backgrounds really are dead, I made sure
> that the only Oracle things left alive were the shadows
> (or dedicated servers to the youngsters on the group)
> viz: oracle{SID}.

[snipped] Received on Tue Aug 14 2001 - 09:33:53 CDT