I have two instance are running in sun unix box. How do I find, which oninit belongs which instance. and also how to find if database is running in archive log mode or not

Thanks

On itself prettyu easy: onstat -g glo will print vp info like process id of the oninit processes.

What do you mean with archive log mode, do you mean you want to see if logical log backup is set up? In this case a onstat -c|grep LTAPEDEV will do. If it reads /dev/null (UNIX) or NUL (windows) then the answer is no, othwerwise yes.

Lots of fun,

Rob Prop

Is there a way to identify the instance oninit process from the Unix prompt using the grep command?