General
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle background processes and Dataguard

Oracle background processes and Dataguard

hi all,

We have Oracle 10g as Primary and Standby. For replication between the PRIMARY and STANDBY we use Oracle Dataguard framework.

We are planning to develop a tool which will monitor the processes that are responsible for replication. Following is the list of processes I see on our PRIMARY and STANDBY database. Could you please let me know which of these processes should I monitor on PRIMARY and STANDBY to check whether the Dataguard is working properly or not.

Following is the list of processes:

On the Primary Side:
=====================
ora_dbw0_${ORACLE_SID}
ora_lgwr_${ORACLE_SID}
ora_ckpt_${ORACLE_SID}
ora_smon_${ORACLE_SID}
ora_pmon_${ORACLE_SID}
ora_arc0_${ORACLE_SID}
ora_psp0_${ORACLE_SID}
ora_mmnl_${ORACLE_SID}
ora_mmon_${ORACLE_SID}
ora_mman_${ORACLE_SID}
ora_reco_${ORACLE_SID}
ora_cjq0_${ORACLE_SID}
ora_qmnc_${ORACLE_SID}

On the Standby Side:
====================
ora_dbw0_${ORACLE_SID}
ora_lgwr_${ORACLE_SID}
ora_ckpt_${ORACLE_SID}
ora_smon_${ORACLE_SID}
ora_pmon_${ORACLE_SID}
ora_arc0_${ORACLE_SID}
ora_psp0_${ORACLE_SID}
ora_mmnl_${ORACLE_SID}
ora_mmon_${ORACLE_SID}
ora_mman_${ORACLE_SID}
ora_reco_${ORACLE_SID}
ora_mrp0_${ORACLE_SID}

Thanks and regards,
Kaustubh Kane
1 REPLY
Ben Dehner
Trusted Contributor

Re: Oracle background processes and Dataguard

Monitoring processes will not really tell you if Dataguard is running; it will only tell you if the instance is started. That being said, I'd monitor

ora_pmon_XXX on both systems -- if pmon is not running, the instance has crashed

ora_arcN_XXX on the primary -- this is the archiver process that writes the archive files to the standby

ora_mrp0_XXX on the standby -- this is the Managed Recovery Process that applies the redo to the standby
Trust me, I know what I'm doing