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

Heterogeneous environments


Although not heavily discussed in this book, one of the main features of GoldenGate is its support for heterogeneous databases. GoldenGate's decoupled architecture and its trail file universal data format enables heterogeneity. This is the main selling feature for Oracle because GoldenGate does not require additional gateways or any conversion software in order to extract and replicate data across environments.

The decoupled architecture allows a database-specific flavor of the same version of GoldenGate software to be installed on each source and target server, enabling trail files to be written to in a common file format. Such files are subsequently consumed by the target server's apply process.

This is illustrated in the following diagram:

GoldenGate's decoupled architecture for heterogeneous databases

Unfortunately, the decoupled nature of heterogeneous data replication provides some limited functionality—for example, DDL replication is not supported. Oracle GoldenGate...