Oracle GoldenGate Administration
- Buy now
- Learn more
Course Materials (Downloadable)

Activity Guide-v11.0
GG_slides_v7.0
Part 1: GoldenGate Classic

What you will learn?
Introduction to Oracle GoldenGate

What is GoldenGate?
Why do you need GoldenGate?
When do you use GoldenGate?
Common Deployment Topologies
Supported Databases and Operating Systems
Key Features of GoldenGate
GoldenGate Family Products
History of GoldenGate
GoldenGate Architecture

Overview of GoldenGate Architecture
Overview of Classic Architecture
Components of GoldenGate Classic Architecture

Manager
Extract
Trail
Data Pump
Collector
Replicat
GoldenGate Key Terms and Concepts

Processing Groups
About GGSCI
About Parameter Files
About Checkpoints
About CSN
Types of Extracts and Replicats

Extracts - Classic and Integrated Extracts
Replicats - Classic, Integrated, Coordinated, Parallel Replicats
Installing Oracle GoldenGate

Link to download pre-built VMs
Installing Oracle GoldenGate for Oracle Database
Becoming Familiar with GGSCI
Preparing Databases for GoldenGate
Lab Practice: Preparing Databases for GoldenGate
Configuring Online Change Synchronization (DML)

About Online Change Synchronization
Lab Practice: Configuring Online Change Synchronization
How to Start GoldenGate Processes?
Configuring Credentials Store

Configuring Credential Store
Implementing Initial Load

About GoldenGate Initial Load
Lab Practice: Implementing Initial Load
Monitoring GoldenGate Processing

Overview of Monitoring GoldenGate Processing
Lab Practice: Monitoring GoldenGate Processing
Mapping and Manipulating Data

Mapping Columns with COLMAP, COLMATCH and Transforming data with Built-in Functions
Filtering Rows, Converting SQL operations
Lab Practice: Mapping and Manipulating Data
Implementing DDL Synchronization

Configuring DDL Replication
Implementing Bidirectional Replication

Overview of Bidirectional Replication
Overview of Data Looping
Lab Practice: Implementing Bidirectional Replication
About Conflicts in Active-Active Configuration
Overview of CDR - Conflict Detection and Resolution
Lab Practice: Implementing CDR
Overview of Auto CDR
Lab Practice: Implementing Auto CDR
Customizing GoldenGate Processing

Using SQLEXEC
Using Macros
Using Event Marker System
Using User Exits
Lab Practice: Customizing GoldenGate Processing
Patching GoldenGate Classic Installation

Applying Patches to GoldenGate Classic Home
p6880880_121010_Linux-x86-64.zip
p37236684_1925000OGGRU_Linux-x86-64.zip
Configuring GoldenGate for Oracle Multitenant Container Databases

About Configuring GoldenGate for Oracle CDB databases
Hands-on: Preparing the Practice Environment
Part 2: Oracle GoldenGate Microservices

What you will learn?
Overview of Oracle GoldenGate Microservices

Overview of Oracle GoldenGate MA
Installing Oracle GoldenGate Microservices

Preparing the Practice Environment
Installing GoldenGate MA Software and Adding Deployment
Configuring Databases and GoldenGate for Replication
Configuring Online Change Synchronization

Configuring Online Change Synchronization in GGMA
Implementing Initial Load

Implementing Initial Load in GGMA
How to Stop/Start VMs with GGMA Installed?

Starting and Stopping VMs
Admin Client

Using Admin Client
Performance Metrics Service

About Performance Metrics Service

Implementing Bidirectional Replication

8 Lessons