Book Image

Oracle Goldengate 12c Implementers Guide

By : John P Jeffries
Book Image

Oracle Goldengate 12c Implementers Guide

By: John P Jeffries

Overview of this book

The book is aimed at Oracle database administrators, project managers, and solution architects who wish to extend their knowledge of GoldenGate. The reader is assumed to be familiar with Oracle databases. No knowledge of GoldenGate is required.
Table of Contents (16 chapters)
12
A. GGSCI Commands
13
B. GoldenGate Installed Components
14
C. Acronyms
15
Index

Oracle GoldenGate solutions

Oracle GoldenGate provides seven data replication solutions:

  1. High availability:
    • Live standby for an immediate failover solution that can later resynchronize with its primary source
    • Active solutions for continuous availability and transactional load distribution between two or more active systems
  2. Zero downtime upgrades and migrations:
    • Eliminates downtime for upgrades and migrations
  3. Live reporting:
    • Feeding a reporting database to not burden the source production systems with BI users or tools
  4. Operational BI:
    • Real-time data integration to operational data stores or data warehouses directly or via Extract, Load, and Transform (E-LT) tools
    • Trickle fed data warehouses that eliminate batch or Extract, Load, and Transform processes
  5. Transactional Data Integration:
    • Real-time data feeds to messaging systems for business activity monitoring, business process monitoring, and complex event processing
    • Uses event-driven architecture and service-oriented architecture (SOA)
  6. Cloud and On-Premises:
    • Real-time bidirectional data feeds between On-Premises and public Clouds that are both secure and reliable
  7. Support for Big Data:
    • Real-time, noninvasive data consolidation into Big Data targets
    • Interfaces with industry standard software components to offer access to semi-structured data

The following diagram shows the simplified architecture for the various solutions available from GoldenGate software:

Oracle GoldenGate solutions

We have discovered that there are many solutions where GoldenGate can be applied. Now, we can dive into how GoldenGate works, the individual components, processes, and the data flow that is adopted for all.