Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to start a background process without bouncing database?

486801Jan 31 2006 — edited Jan 31 2006
I list most of possible background processes that should exist in a healthy database instance.

For example,
when each individual background process is down and need to re-start it, how do I have to do to bring then up?

ora_arc0_<SID>
ora_arc1_<SID>
ora_smon_<SID>
ora_ckpt_<SID>
ora_snp0_<SID>
ora_reco_<SID>
ora_snp1_<SID>
ora_lgwr_<SID>
ora_dbw0_<SID>
ora_pmon_<SID>

-------

assume, ONLY archive log engine is down and the rest of background processes are still running,
to bring up archive process, you can do,
SQL> archive log start;

For the same situation, what do I do to bring each one up?

ora_smon_<SID>
ora_ckpt_<SID>
ora_snp0_<SID>
ora_reco_<SID>
ora_snp1_<SID>
ora_lgwr_<SID>
ora_dbw0_<SID>
ora_pmon_<SID>


thanks in advance!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 28 2006
Added on Jan 31 2006
1 comment
624 views