OraFAQ Forum: Data Guard » Oracle background processes and Dataguard

Home » Server Options » Data Guard » Oracle background processes and Dataguard (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle background processes and Dataguard [message #275842]

Tue, 23 October 2007 00:25

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

Report message to a moderator

Re: Oracle background processes and Dataguard [message #276013 is a reply to message #275842]

Tue, 23 October 2007 12:18

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.

Report message to a moderator

Previous Topic:	Data guard requirement
Next Topic:	log miner session not started

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 08 18:16:21 CST 2025