🔹 Looking to replicate your on-prem Oracle database to Google Cloud with real-time changes? Oracle GoldenGate (OGG) provides a seamless solution for heterogeneous replication with minimal latency.
👉 In this post, I’ll walk you through a step-by-step process to configure Oracle GoldenGate replication from an On-Premises Oracle database to Google Cloud (Cloud SQL / Bare Metal DB).
💡 Why Oracle GoldenGate for this setup?
✅ Real-time data replication
✅ Zero downtime migration
✅ Supports heterogeneous databases
✅ High availability & scalability
🔹 Step 1: Prepare Source Database (On-Prem Oracle DB)
✅ Enable supplemental logging
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER DATABASE FORCE LOGGING;
✅ Grant required permissions
GRANT CREATE SESSION, ALTER SYSTEM, SELECT ANY DICTIONARY TO ogg_user;
✅ Add extract user
CREATE USER ogg_user IDENTIFIED BY “YourStrongPassword”;
GRANT CONNECT, RESOURCE TO ogg_user;
🔹 Step 2: Install & Configure Oracle GoldenGate on On-Prem Server
✅ Configure Extract Process
cd $OGG_HOME
./ggsci
ADD EXTRACT ext1, TRANLOG, BEGIN NOW
ADD EXTTRAIL ./dirdat/lt, EXTRACT ext1
✅ Edit Extract Parameter File
EDIT PARAMS ext1
EXTRACT ext1
USERID ogg_user, PASSWORD YourStrongPassword
TRANLOGOPTIONS DBLOGREADER
EXTTRAIL ./dirdat/lt
TABLE schema_name.*;
✅ Start Extract
START EXTRACT ext1
🔹 Step 3: Set up Google Cloud (Cloud SQL / Bare Metal DB)
✔️ Cloud SQL: Enable connectivity & create an instance
✔️ Bare Metal DB: Install Oracle and configure networking
✅ Create target schema & user
CREATE USER ogg_target IDENTIFIED BY “TargetPassword”;
GRANT CONNECT, RESOURCE TO ogg_target;
🔹 Step 4: Configure Replicat Process on Google Cloud
✅ Configure Replicat
ADD REPLICAT rep1, EXTTRAIL ./dirdat/lt
✅ Edit Replicat Parameter File
EDIT PARAMS rep1
REPLICAT rep1
USERID ogg_target, PASSWORD TargetPassword
ASSUMETARGETDEFS
MAP schema_name.* , TARGET schema_name.*;
✅ Start Replicat
START REPLICAT rep1
🔹 Step 5: Monitor & Validate
✅ Check Extract & Replicat Status
INFO ALL
✅ Validate Data Consistency
SELECT COUNT() FROM source_table; SELECT COUNT() FROM target_table@ggcloud;
🔹 💡 Key Takeaways:
✔ Oracle GoldenGate ensures real-time replication
✔ Works seamlessly with Google Cloud SQL or Bare Metal DB
✔ Ideal for hybrid cloud migration & disaster recovery
🔥 Have you implemented GoldenGate for cloud migration? Let’s discuss in the comments! 👇