🔹 Seamlessly Replicate Oracle On-Prem to AWS RDS with GoldenGate 🔹
As enterprises move towards cloud adoption, ensuring high availability, disaster recovery, and real-time data synchronization is critical. Oracle GoldenGate (OGG) provides a robust solution to replicate data from an on-premises Oracle database to AWS RDS for Oracle with minimal downtime.
Here’s a step-by-step guide to setting up Oracle GoldenGate replication from On-Prem to AWS RDS. 🚀
🔹 1️⃣ Prerequisites for GoldenGate Replication
✅ On-Premises Oracle DB: Running Oracle 12c/19c with ARCHIVELOG mode enabled.
✅ AWS RDS Instance: An Oracle database instance with supplemental logging enabled.
✅ Oracle GoldenGate Installed: OGG software installed on a dedicated replication server.
✅ Networking: Ensure secure connectivity (VPN, Direct Connect, or AWS DMS Replication Instance).
🔹 2️⃣ Enable Required Settings on On-Prem Oracle DB
Before configuring GoldenGate, enable ARCHIVELOG mode and supplemental logging:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER DATABASE FORCE LOGGING;
ALTER SYSTEM SWITCH LOGFILE;
📌 Why? Ensures complete redo log capture for replication.
🔹 3️⃣ Create GoldenGate Extract Process (On-Premises)
Login to GoldenGate Admin Console on your on-premise system:
📌 Add Extract Process
ADD EXTRACT EXT1, TRANLOG, BEGIN NOW
📌 Add Trail Files
ADD EXTTRAIL ./dirdat/lt, EXTRACT EXT1
📌 Register Extract with the Database
REGISTER EXTRACT EXT1 DATABASE;
🔹 4️⃣ Create GoldenGate Pump to Send Data to AWS RDS
Create the Data Pump process to route extracted data to AWS:
ADD EXTRACT DPUMP1, EXTTRAILSOURCE ./dirdat/lt
ADD RMTTRAIL /ggs/dirdat/rt, EXTRACT DPUMP1
📌 Edit Parameter File (DPUMP1.prm)
EXTRACT DPUMP1
RMTHOST , MGRPORT 7809
RMTTRAIL /ggs/dirdat/rt
TABLE SCOTT.*;
📌 Why? The pump process pushes data to AWS RDS for Oracle.
🔹 5️⃣ Configure AWS RDS as GoldenGate Target
On AWS RDS, configure GoldenGate Integrated Replicat:
📌 Enable Supplemental Logging on RDS
EXEC RDSADMIN.RDSADMIN_UTIL.ALTER_SENSITIVE_SUPPLEMENTAL_LOGGING(p_action => ‘ADD’);
📌 Add Replicat Process on AWS RDS
ADD REPLICAT REP1, EXTTRAIL /ggs/dirdat/rt
📌 Configure Replicat Parameter File (REP1.prm)
REPLICAT REP1
TARGETDB , USERIDALIAS ggadmin
MAP SCOTT., TARGET SCOTT.;
📌 Why? The Replicat process applies transactions on AWS RDS.
🔹 6️⃣ Start GoldenGate Processes
Start the processes to begin real-time replication:
START EXTRACT EXT1;
START EXTRACT DPUMP1;
START REPLICAT REP1;
📌 Monitor Status:
INFO ALL;
📌 Check Replication Lag:
LAG REPLICAT REP1;
🚀 Benefits of Using Oracle GoldenGate for On-Prem to AWS RDS Replication
✔ Minimal Downtime Migration – No need for extended outages.
✔ Real-Time Replication – Keeps databases in sync with low latency.
✔ Cross-Cloud Flexibility – Supports multi-cloud and hybrid architectures.
✔ Scalability & Performance – Handles high-volume transactions efficiently.