Oracle Golden Gate

Published by Ahmad on

What is Oracle Golden Gate ?

Oracle Golden Gate is a software product that allows you to replicate, filter, and transform data from one database to another database.

What You Can do By using Oracle Golden Gate ?

  • Using Oracle Golden Gate, you can move committed transactions across multiple heterogeneous systems in your enterprise.
  • It enables you to replicate data between Oracle databases to other supported heterogeneous database, and between heterogeneous databases.
  • You can replicate to Java Messaging Queues, Flat Files, and to Big Data targets in combination with Oracle Golden Gate for Big Data.

Oracle Golden Gate Purposes

  • A static extraction of data records from one database and the loading of those records to another database.
  • Continuous extraction and replication of transactional Data Manipulation Language (DML) operations and data definition language (DDL) changes (for supported databases) to keep source and target data consistent.
  • Extraction from a database and replication to a file outside the database.

Oracle Golden Gate Key Features

  • Data movement is in real-time, reducing latency.
  • Only committed transactions are moved, enabling consistency and improving performance.
  • Different versions and releases of Oracle Database are supported along with a wide range of heterogeneous databases running on a variety of operating systems.
  • You can replicate data from an Oracle Database to a different heterogeneous database.
  • Simple architecture and easy configuration.
  • High performance with minimal overhead on the underlying databases and infrastructure.

Golden Gate supports Heterogeneous Environments

  • Different platforms (Linux, Windows, etc.)
  • Different databases (Oracle, MySQL, SQLServer, etc.)
  • Different database versions

Oracle Golden Gate Components

  • Extract
  • Data pump
  • Replicat
  • Trails or extract files
  • Checkpoints
  • Manager
  • Collector

Oracle Golden Gate Logical Architecture

When Do You Use Oracle Golden Gate?

The most common use cases are

  • Business continuity and high availability
  • Initial load and database migration and upgrades with zero downtime
  • Data integration
  • Decision support and data warehousing.

How Do You Use Oracle Golden Gate?

There are many different architectures that can be configured; which range from a simple uni-directional architecture to the more complex peer-to-peer.

No matter the architecture, Oracle Golden Gate provides similarities between them, making administration easier.

Oracle Golden Gate Supported Topologies


I Hope this post will give you much information.

Your comments are always welcome.

Cheers !!!!


With Best Wishes !!!!



Oracle Consultant

OCE (11gR2 RAC)

OCP (11gR2/10gR2/9iR2)

 OracleRide Team !!!!


Reference-: Oracle Doc



Rauf · October 23, 2019 at 8:12 pm


Mohd Qadar · October 23, 2019 at 8:14 pm

MashaALLAH very nice Ahmad Bhai, keep posting

Mohammed Anzar Khan · October 23, 2019 at 9:08 pm

Indeed, i was thinking that it will be very tough to learn but after reading your blog. Now, I got clear idea and main concepts of GG.

    Ahmad · October 23, 2019 at 9:23 pm

    Thanks for your feedback.

Zaheer · October 24, 2019 at 9:28 pm

Great Overview …

Md saddam siddiqui · November 12, 2019 at 10:01 pm

After reading this article i am clear now about GG..
Thank you ahmad Sir..

Abdul Zakir · January 17, 2020 at 12:37 am

This article is so informative
Thank you Ahmad Sir

Pravin · April 15, 2020 at 10:06 pm

Hi Ahmad Sir,
Really great info,helped me alot..

Shahdab · May 21, 2020 at 6:07 pm

Good informative for beginners…cheers

Syed Sohail Ahmed · July 16, 2020 at 10:36 pm

Mashallah very informative article on golden gate. Got a clear picture That what is golden gate. And how it’s use. And what also how it works. Thanks for sharing this valuable post

Sreenivas Erukulla · August 23, 2020 at 9:53 pm

Nicely explained, Looking forward to upgradation/Migration scenario demo using Golden gate

Leave a Reply

Your email address will not be published. Required fields are marked *