Home » Server Options » Data Guard » Oracle background processes and Dataguard (Oracle 10g)
Oracle background processes and Dataguard [message #275842] Tue, 23 October 2007 00:25 Go to next message
kaustubh
Messages: 26
Registered: June 2007
Junior Member
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
Re: Oracle background processes and Dataguard [message #276013 is a reply to message #275842] Tue, 23 October 2007 12:18 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Your Dataguard is in real time?
These are some DG processes
Quote:


ARC0 Archiver
DMON Data Guard Monitor
FAL Fetch Archive Log
LCR: Logical Change Record
LGWR Log Writer backend process
LSP: Logical Standby Process aka SQL Apply (logical)
MRP Managed Recovery Process aka Redo Apply (physical)
RFS Remote File Server (receives undo)
TAF Transparent Application Failover


You can check either it by querry weather the logs are applying succesfully or not

SQL> SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG
       ORDER BY SEQUENCE#;


In Real Mode when transactions are running on primary

     On the standby :
     
     SQL>SELECT  PROCESS, STATUS,SEQUENCE#,BLOCK#,BLOCKS,                               DELAY_MINS FROM 
               V$MANAGED_STANDBY;
     
     Notice the block# for the RFS and MRP0 increasing



You should monitor alertlog frequently as well.
Previous Topic: Data guard requirement
Next Topic: log miner session not started
Goto Forum:
  


Current Time: Thu Mar 28 14:28:40 CDT 2024