Re: Instance , what instance.

The database didn't get corrupted. (Beyond a tiny glitch needing instance recovery, probably).

The point about shutdown killing pids in reverse order is a useful snippet. However, given the cyclic nature of UNIX pids it won't always guarantee that pmon will get killed last - although the odds are probably about 6,000 to 1 in favour (based on max(pid)=65535, and background pids leaving a gap of 2 all the time, and 5 pids being assigned as a typical number etc. etc. etc.)

--
Jonathan Lewis

Seminars on getting the best out of Oracle
Last few places available for Sept 10th/11th
See http://www.jlcomp.demon.co.uk/seminar.html




Yong Huang wrote in message ...


>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

>