Skip to main content

Oracle GoldenGate: Overview, Architecture, and Silent Installation

🪄 Oracle GoldenGate: Overview, Architecture, and Silent Installation

Oracle GoldenGate (OGG) is a real-time data replication and integration tool. It enables the replication of data across heterogeneous systems, ensuring high availability, disaster recovery, and data distribution for analytics or migration purposes.

📌 What is Oracle GoldenGate?

Oracle GoldenGate captures transactional data changes from a source system and applies them to a target system in real-time. It supports unidirectional, bidirectional, and cascading replication setups.

  • Real-time replication
  • Heterogeneous platform support
  • Low impact on source system

📤 Extract Process in GoldenGate

Extract is a data capture process that reads changes from the source database.

🔹 Types of Extract

  • Classic Extract: Reads redo/archived logs from Oracle database. Used in non-integrated mode.
  • Integrated Extract: Uses Oracle Streams infrastructure for better performance and support of complex data types. Works with Oracle 11g R2 and above.
  • Initial Load Extract: Captures data for initial load purposes without tracking changes.

📥 Replicat Process in GoldenGate

Replicat reads trail files and applies the data to the target database.

🔹 Types of Replicat

  • Classic Replicat: Applies SQL operations to target in commit order.
  • Integrated Replicat: Works with Oracle’s apply engine for performance and scalability.
  • Coordinated Replicat: One Replicat group managing multiple threads for performance.
  • Parallel Replicat: Similar to Coordinated, but with parallel execution from extract to apply.

🚀 What is the Pump Process?

The Data Pump is a secondary Extract group. It reads the local trail created by the primary Extract and sends it to the target system.

  • Ensures no data is lost during network failures
  • Reduces load on source system
  • Supports filtering and transformation

🛠 GoldenGate 21c Silent Installation Steps

📂 Step 1: Prepare Directories and Permissions

mkdir /acfs01/ogg21c
chown -R ggudb:oinstall /acfs01/ogg21c

mkdir -p /opt/app/ogg21c
chown -R ggudb:oinstall /opt/app/ogg21c

📦 Step 2: Copy and Unzip GoldenGate Binary

cp 213000_fbo_ggs_Linux_x64_Oracle_shiphome.zip /acfs01/ogg21c/
cd /acfs01/ogg21c
unzip 213000_fbo_ggs_Linux_x64_Oracle_shiphome.zip

📝 Step 3: Update the Response File

Edit the oggcore.rsp file at /acfs01/ogg21c/fbo_ggs_Linux_x64_Oracle_shiphome/Disk1/response

INSTALL_OPTION=ORA21c
SOFTWARE_LOCATION=/opt/app/ogg21c
START_MANAGER=FALSE
MANAGER_PORT=7809
DATABASE_LOCATION=/opt/oracle/product/19.3.0/db_1
INVENTORY_LOCATION=/opt/app/oraInventory
UNIX_GROUP_NAME=oinstall

🖥️ Step 4: Run the Silent Installer

cd /acfs01/ogg21c/fbo_ggs_Linux_x64_Oracle_shiphome/Disk1

./runInstaller -silent -showprogress -waitforcompletion -ignoreSysPrereqs \
-responseFile /acfs01/ogg21c/fbo_ggs_Linux_x64_Oracle_shiphome/Disk1/response/oggcore.rsp

🔁 Step 5: Verify the Installation

cd /opt/app/ogg21c/
./ggsci

✅ Conclusion

  • GoldenGate is a powerful and flexible replication solution.
  • Extract captures changes, Replicat applies them, and Pump safely transports them.
  • With silent installation, you can easily automate deployments.

Now you're ready to replicate data with Oracle GoldenGate like a pro! 🚀

Labels:

Comments

Post a Comment