Oracle GoldenGate – Replicat Process

The Replicat process runs on the target system. Multiple Replicat processes can be used with multiple Extract processes in parallel to increase throughput.

Oracle recommends that you use the parallel Replicat unless a specific feature requires a different type of Replicat.

Replicat can:

  • Read data out of Oracle GoldenGate trails.
  • Perform data filtering by table, row, or operation.
  • Perform data transformation.
  • Perform database operations just as your application perform them

Types of Replicat:

  • Classic (nonintegrated) Replicat
  • Coordinated Replicat
  • Integrated Replicat
  • Parallel Replicat (I – Integrated or NI – Nonintegrated)

In order to avoid any data inconsistencies, foreign key constraint violation and referential integrity, this is highly recommended to keep parent and child tables together in the same group, as opposed to dividing them.
Note: A barrier transaction is a transaction that contains the row LCR that is applied after all of the other transactions with lower SCN/CSCN/CSN values. For example, a barrier transaction occurs when there are updates to a primary key value.

Barrier Transaction Examples:

  • Write After Write Transaction
  • Updates to Primary Keys
  • DDL
  • Parent/Child dependencies are a special case that require a foreign key.

Replicat Features: Batch Processing (BatchSQL), Barrier Transactions, Dependency Computation, Auto-Parallelism, DML Handler, Auto-CDR, Procedural Replication, Dependency Aware Transaction Split, Cross-RAC-node processing AllowDupTargetMap.

Parallel Replicat (in Integrated Mode) supports all of features.

Integrated Replicat also support all of the features except Dependency Aware Transaction Split and Cross-RAC-node processing.

Coordinated Replicat does not support Dependency Computation, Auto-Parallelism, DML Handler, Auto-CDR, Procedural Replication and Dependency Aware Transaction Split.

Classic Replicat does not support Barrier Transactions, Dependency Computation, Auto-Parallelism, DML Handler, Auto-CDR, Procedural Replication, Dependency Aware Transaction Split and Cross-RAC-node processing.

Auto-CDR for Active-Active environment.
CDR – Conflict Deduction Resolution.
AllowDupTargetMap – Multiple Mapping in the same table.

 

 

Share This

Muhammad Rawish Siddiqui

Master in Computer Science (Database Engineering) and PGD in Management Information System.
45+ Online Certifications, which includes EDRP (EC-Council Disaster Recovery Professional), Data Management, Security+, DBaaS - Cloud Certified Expert, Oracle Cloud Autonomous Database Specialist, Oracle Database Cloud Certified Professional, Oracle Cloud Infrastructure, OCP 7.3, 10g, 11g, 11i, R12, OCE/OCS 11i System Administration, Solaris, Linux and Real Application Cluster 10g, 11g, Oracle Autonomous Database, Real Application Cluster, Oracle Data Guard and Performance Tuning etc. .

Foremost interested areas include, Data Management, Oracle Databases and EBS Health Checks, Real Application Cluster, Disaster Recovery, GoldenGate and Oracle Cloud.
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments