About Oracle Golden gate

 

What is golden gate?

  • Oracle Golden Gate is a tool used to replicate, filter and transform data from one database to another database, It may be to any database which is in any operating system.
  • This Golden gate tool is used to replicate data between oracle databases to any other type of databases.
  • The replication of data may be full replication of data or it may be the filtered form of data.
  • This Golden Gate is used for zero/minimal downtime when up-gradation or migration is done.

o   The replication database can be used as Disaster recovery database or for report generating database.

Export and Import can also be used for replication but it is a onetime replication. Async mode and no online sync or roll forward is allowed

o   Export and Import process is, the data is extracted from source oracle database as a .dmp file to the operating system,

o   And then Its transferred to the target server and then injected the data to the target oracle database.

But using oracle Golden gate the replication process can be done continuously in sync mode -- it can be a continuous process.

 

Golden gate benefits

  • Oracle Golden Gate enables the continuous and real-time capture, routing, transformation, and delivery of transnational data across heterogeneous environments.
  • As new or updated data is committed at the source system, it is continuously captured and applied to one or more target systems with low latency.
  • Zero or minimum downtime upgrade or migration.
  • OS and RDBMS independent.
  • Partial or full disaster recovery solution.

For disaster recovery and DB upgrades oracle database provides three different types of approaches which are:

        1. RMAN backup.

        2. Oracle active Data Guard

            Advantages: Data protection and availability solution, active-passive(inactive) replication mode

        3. Oracle golden gate

            Advantages: Flexible logical replication solution active-active replication mode, least down time when compared to other solutions. One-way(uni-directional) or (bi-directional) two-way replication

Comments

Post a Comment

Popular posts from this blog

Architecture for Oracle Golden gate

Image
  Components of the golden gate: Source database. Manager process @ source database/target database- manages all GG operations Capture process or Extract process (Local Extract) Source Trail / Trail files @ Source db side Pump process @ source database. Network (high speed network to avoid replication lagging) Remote Trail / Trail files @ Target db side Delivery process or Replicat process Target database. Manager process @ target database. Source Data base: The oracle database or any other database from which the data will be replicated. Target Database: The oracle or any other database where the data need to be replicated. Manager process: This is the common process which is present at both source golden gate and target golden gate tool, which needs to be started before any other process needs to be started. Manager process is used for coordination of tool, if manager process is not running rest of the process will not work/start. The Manager process is the first Golden Gate p...
Read more