Overview of Oracle Golden Gate:
Oracle GoldenGate is a comprehensive software package for real-time data replication, transformation, and synchronization across heterogeneous systems. It is widely used in enterprise environments for high availability, disaster recovery, and data integration.
🔍 Key Features of Oracle GoldenGate
- Real-Time Data Replication
GoldenGate captures and delivers data changes (DML and DDL) in real time with minimal latency. - Heterogeneous Support
It supports a wide range of databases including Oracle, MySQL, SQL Server, PostgreSQL, DB2, and more. - High Availability & Disaster Recovery
Ensures business continuity by replicating data to standby systems. - Data Transformation
Allows transformation of data during replication using mapping and filtering rules. - Scalability
Designed to handle large volumes of data with minimal impact on source systems. - Security
Supports encryption, authentication, and secure data transfer.
History of Oracle GoldenGate
- 1995: GoldenGate Software was founded in San Francisco, named after the iconic Golden Gate Bridge. The company specialized in real-time data replication solutions.
- 2009: Oracle Corporation acquired GoldenGate Software, integrating its technology into Oracle’s data management ecosystem. This marked the beginning of Oracle GoldenGate as a core product for real-time data integration and replication.
What are the different types of Oracle Golden Gate(OGG) Architecture?
Types of OGG Architecture:
Oracle Golden Gate Classic Architecture – It’s based on GGSCI command prompt, Depreciated from Oracle 21c.
Oracle Golden Gate Microservices – We can start using GUI to setup, manage and troubleshoot Golden Gate from 12.3c version. Initially it only support Oracle database, then from Oracle 19c its start supporting DB2, MSSQL, Postgres and MySQL. Up to 21c version, both GGSCI and UI both available.
Difference in Architecture
| Feature | Classic Architecture | Microservices Architecture |
|---|---|---|
| License Type | Same Oracle GoldenGate license | Same license |
| Administration | Command-line (GGSCI) | Web UI + REST APIs |
| Deployment | On-premises, limited cloud support | Cloud-ready, container-friendly |
| Support Status | Deprecated in newer versions (21c+) | Actively developed and recommended |
Note: Golden gate works on committed transaction which capture data from Oracle Redo files or archive files, but redo files and archive files contain committed and uncommitted data both.
Types of Extracts and Replicates Process in Oracle Golden Gate
In Oracle GoldenGate, Extracts and Replicats are the core processes responsible for data movement. Each has different types based on the architecture and use case.
Types of Extracts
1. Classic Extract
- Used in Classic Architecture.
- Captures data changes from the transaction logs of the source database.
- Suitable for non-integrated environments.
- Works well with non-Oracle databases.
2. Integrated Extract
- Works with Oracle databases only and released in 11.2.0.4 GG, DB support 11.2.0.3
- Uses Oracle LogMiner to mine redo logs.
- Offers better performance and scalability.
- Supports compressed and encrypted data.
3. Initial Load Extract
- Used for bulk data movement during initial setup.
- Extracts the entire dataset from source tables.
- Often used in combination with change data capture (CDC) for seamless cutover.
Types of Replicats
1. Classic Replicat
- Used in Classic Architecture.
- Applies changes using SQL statements.
- Suitable for simple replication scenarios.
2. Coordinated Replicat
- Designed for high-volume environments. Version GG 12.2
- Uses multiple threads to apply changes in parallel.
- Maintains transactional consistency.
3. Integrated Replicat
- Works with Oracle databases only with GG version 12.1
- Uses Oracle Streams to apply changes.
- Supports parallelism, DDL replication, and conflict detection.
4. Parallel Replicat (Microservices Architecture)
- Introduced in Microservices Architecture.
- Offers fine-grained parallelism.
- Ideal for cloud and high-throughput environments.