When using Oracle GoldenGate in mission-critical systems, you need to have the following high availability (HA) considerations:
1. Oracle GoldenGate Instance HA When Running from a Single Server
The single server high availability of Oracle GoldenGate is configured by the AUTOSTART parameter in the GoldenGate manager process. This requires the Oracle GoldenGate manager to be up-and-running. If the manager process id down, then you need to restart the manager process. 2. Oracle GoldenGate Instance HA When Running on a Server Cluster
Please refer to Oracle Support Note 1313703.1 [1][3] to find out the official update on this topic.This requires the Oracle GoldenGate instance running on different server share the followings:
3. Oracle GoldenGate HA When Source Database Fails Over
The supported configuration requires the following configurations [4]:
What is DBFS? Oracle Database File System (DBFS) is a file system in the Oracle database. Files are stored as SecureFiles LOBs. PL/SQL procedures implement file system access primitives such as create, open, read, write, and list directory. Please refer to TWP [4] [5] for the detailed setup.
Additional Read Case Study - High Availability across AWS Regions
This is a case study of a cross-region high availability (HA) for Oracle Databases on AWS EC2.
Solution 1: If you can lose transactions during the lag time of the Oracle GoldenGate replication, you can have the following setup:
Solution 2: If you can't lost data in regional fail-overs, you need the following setup:
4. Oracle GoldenGate HA During the Target Database Failover
This is simple if the replication is not bi-directional. For bi-directional replication, the practices described in section 3 applies. In this case, use the checkpoint table and just restart the Oracle GoldenGate to apply to the new standby database. |
Reference
- Oracle MAA Technical White Paper (TWP): Oracle GoldenGate With Oracle Real Application Clusters Configuration, August 2013
- Oracle MAA Technical White Paper: Disaster Recovery for Oracle Database Zero Data Loss Recovery Appliance, Active Data Guard and Oracle GoldenGate, April 2015
- Oracle Support Document 1313703.1 - Oracle GoldenGate Best Practices: Oracle GoldenGate High Availability Using Oracle Clusterware, August 30, 2016
- Oracle MAA Technical White Paper: Transparent Role Transitions With Oracle Data Guard and Oracle GoldenGate, February 2015
- Oracle GoldenGate Best Practices: Configuring Oracle GoldenGate with Oracle Grid Infrastructure Bundled Agents (XAG), April 8, 2013
Created 4/12/2016, Last Updated 2/13/2018