Overview of Oracle GoldenGate High Availability Best Practices

14 Overview of Oracle GoldenGate High Availability Best Practices

Oracle GoldenGate is Oracle's strategic logical replication product and integral part of MAA's platinum architecture. By adding Oracle GoldenGate replication, a Gold MAA reference architecture is elevated to a Platinum MAA reference architecture.

The Platinum reference architecture has the potential to provide zero downtime for outages and planned maintenance activities that are not achievable with the Gold architecture. To learn more about the Platinum MAA reference architecture, see High Availability Reference Architectures.

Oracle GoldenGate provides the following benefits:

Uni-directional or bi-directional replication, allowing reads and updates in any replicated database.
Data movement is in real-time, reducing latency.
Replicated databases can run on different hardware platforms, database versions, and different database or application configurations, allowing for online migration. This flexibility also allows online database and application upgrades.
Source and target replicated databases are online, so zero downtime switch over of applications, during outages and planned maintenance activities is possible. Note, the application switchover must be customized, rather than using a built-in feature, such as Transparent Application Continuity.

The following table highlights various Oracle GoldenGate configuration best practices.

Table 14-1 Oracle GoldenGate Use Cases and Best Practices

Use Case	Oracle GoldenGate Best Practices
Database migration to Oracle Cloud	Zero Downtime Migration (ZDM) with GoldenGate (logical migration) Migration to the Oracle Cloud with an Oracle GoldenGate Hub Configuration
Database migration requiring minimal or zero downtime Database migration involving cross platform or different database versions	Oracle Database Migration with an Oracle GoldenGate Hub Configuration
Deploy Oracle GoldenGate off of the database server in a Hub configuration, offering the following benefits: Offloads Oracle GoldenGate software installation and configuration from database servers to a single server or cluster. Offloads some of the CPU and IO consumption of Oracle GoldenGate processes. Extract redo mining is still done on the database servers. Leverages Oracle GoldenGate Microservices Architecture, simplifying Oracle GoldenGate configuration, administration and management.	Oracle Maximum Availability Architecture (MAA) GoldenGate Hub
Optimize Oracle GoldenGate configuration for performance	Oracle GoldenGate Performance Best Practices
Configure Oracle GoldenGate on Real Application Cluster Configure Oracle GoldenGate on Real Application Cluster in Oracle Cloud	Oracle GoldenGate Microservices Architecture with Oracle Real Application Clusters Configuration Best Practices or Oracle GoldenGate With Oracle Real Application Clusters Configuration Oracle GoldenGate Microservices Architecture on Oracle Cloud Infrastructure
Tips to integrate other MAA technologies with Oracle GoldenGate	Oracle Exadata MAA - Platinum Tier Focused Presentation Disaster Recovery for Oracle Database: Zero Data Loss Recovery Appliance, Active Data Guard and Oracle GoldenGate - An Overview Transparent Role Transitions with Oracle Data Guard and Oracle GoldenGate
Application Failover Options for Oracle GoldenGate	Global Data Services Concepts and Administration Guide

Also see Oracle GoldenGate documentation at: https://docs.oracle.com/en/middleware/goldengate/core/21.1/

Parent topic: Oracle GoldenGate High Availability Best Practices