In previous articles, we have seen the configuration of change capture. Oracle Golden Gate architecture is mainly a collection of two main process Extract and Replicat.
Extract process runs as source side from which you want to capture data and Replicat process runs at Destination side where you want run replication process.
Each trail file generated by the associated extract process is read by the replicat process sequentially. Replicat supports a high volume of data replication activity and thus network activity is block based and not a record at a time.
Replicat process preserves boundaries of each transaction while replicating, so in case of loss of connectivity target database has the same level of integrity as a source database.
Characteristics of the Replicat process :
- The replicat process runs at the target side.
- Multiple replicat processes can be used in association with multiple extract process to increase throughput.
- The replicat process can read data from Oracle Golden Gate trail files generated by the extract process.
- The replicat process can perform data filtering by table, row or by an operation.
- We can perform data transformation using replicat.
- Replicat process replicates data in such a way it looks like your application performed that operation.
Step by step Configuration of Replicat process
Step 1: Create a checkpoint table in the target database
GGSCI (localhost.localdomain as ggs_owner@stdorcl) 5> Add checkpointtable ggs_owner.chktbls
Step 2: Create a parameter file for replicat
GGSCI (localhost.localdomain as ggs_owner@stdorcl) 6>Edit param rep2
replicat rep2 userid ggs_owner@stdorcl,password oracle table hr.* , map hr.*;
Step 3: Create a replicat group
GGSCI (localhost.localdomain as ggs_owner@stdorcl) 7> add replicat rep2,exttrail /u02/ggate/dirdat/ba,checkpointtable ggs_owner.chktbls REPLICAT added.
Step 4: Start the replicat process
GGSCI (localhost.localdomain as ggs_owner@stdorcl) 20> start rep2 Sending START request to MANAGER ... REPLICAT REP2 starting
Step 5: Check the status of the replicat process
GGSCI (localhost.localdomain as ggs_owner@stdorcl) 21> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING REPLICAT ABENDED REP1 00:00:00 23:03:57 REPLICAT RUNNING REP2 00:00:00 00:00:01
If you want to be updated with all our articles send us an Invitation or Follow us:
Telegram Channel: https://t.me/helporacle
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp