Zero Downtime Upgrade Guide for Oracle

10.3 HotFix 3

Back Next

Oracle GoldenGate Processes for ZDT

ZDT requires a set of Oracle GoldenGate processes. Some of the processes extract and replicate data from the active environment to the passive environment. The remaining processes manage a bidirectional message stream. The messages reside in the C_REPOS_ZDT_EVENT_QUEUE repository table.

The following table identifies the prefixes that are used in the process group names:

Prefix	Process Type	Purpose
E_, P_	EXTRACT	Extracts data from the MDM Hub that is located in the active environment.
R_	REPLICAT	Replicates data to the MDM Hub that is located in the passive environment.
EQ, PQ	EXTRACT	Extracts messages from the C_REPOS_ZDT_EVENT_QUEUE repository table. Runs on both environments to support a bidirectional message stream.
RQ	REPLICAT	Replicates messages to the C_REPOS_ZDT_EVENT_QUEUE repository table. Runs on both environments to support a bidirectional message stream.

For example, the following list shows the processes for ENVA and ENVB, where ENVA is the active environment.

GGSCI (hostname) 13> info all

Program     Status      Group      
MANAGER     RUNNING
EXTRACT     RUNNING     EQENVA  
EXTRACT     RUNNING     EQENVB  
EXTRACT     RUNNING     E_ENVA   
EXTRACT     RUNNING     PQENVA   
EXTRACT     RUNNING     PQENVB 
EXTRACT     RUNNING     P_ENVA 
REPLICAT    RUNNING     RQENVA 
REPLICAT    RUNNING     RQENVB  
REPLICAT    RUNNING     R_ENVB 
REPLICAT    RUNNING     R_ENVBU

Rename Saved Search

Table of Contents

Zero Downtime Upgrade Guide for Oracle

Zero Downtime Upgrade Guide for Oracle

Oracle GoldenGate Processes for ZDT

Oracle GoldenGate Processes for ZDT