Oracle GoldenGate : Integrated Replicat – How it Works

Integrated Replicat (also known as Integrated Apply or Integrated Delivery) provides the following features:

  • Leverages database parallel apply servers via the inbound server for automatic, dependency-aware parallel apply
  • Uses a streaming protocol with asynchronous processing
  • Applied source transactions in parallel based on dependencies between transactions
  • Has a single Replicat, so @RANGE or THREAD or other manual partitioning is not necessary
  • Detects and Resolve conflicts by using CDR, REPERROR, and HANDLECOLLISIONS
  • Replicat
    Reads the trail file
    Constructs LCRs
    Transmits LCRs to Oracle Database via the lightweight streaming API
  • Inbound Server (Database Apply Process)
    Receiver: Reads the LCRs
    Preparer: Computes transaction dependencies
    Coordinator: Coordinates transactions maintains the order between applier processes
    Applier: Performs changes for assigned transactions, including conflict detection and error handling


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.
Notify of
Inline Feedbacks
View all comments