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.
- 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
- 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.