GoldenGate Microservices Administration

  • For existing GoldenGate Admins only

  • 100% Premium Quality

  • 1 Year Unlimited Access

Important Note

This is a Level-2 course on Oracle GoldenGate Administration and designed for existing GoldenGate Administrators who are already familiar with GoldenGate Classic Architecture.

If you are new to Oracle GoldenGate, you should enroll in Oracle GoldenGate Administration Course, instead of this course

About the Course

Oracle GoldenGate Microservices Architecture is a microservices architecture that enables REST services as part of the Oracle GoldenGate environment.

The REST enabled services provide API end-points that can be leveraged for remote configuration, administration, and monitoring through web based consoles, an enhanced command line interface, PL/SQL and scripting languages.

Oracle GoldenGate can be installed and configured to use the Oracle GoldenGate Microservices Architecture for:

  • Large scale and cloud deployments with fully secure HTTPS interfaces and Secure Web Sockets for streaming data.

  • Simpler management of multiple implementations of Oracle GoldenGate environments and control user access for the different aspects of Oracle GoldenGate setup and monitoring.

  • Support system managed database sharding to deliver fine-grained, multimaster replication where all shards are writable, and each shard can be partially replicated to other shards within a shard group.

Course Curriculum

Introduction

  • What is Oracle GoldenGate (OGG)?

  • Why do you need Oracle GoldenGate?

  • When do you need Oracle GoldenGate?

  • Topologies for Oracle GoldenGate

  • Supported Databases and Operating Systems

  • Key Features of GoldenGate

  • Oracle GoldenGate Product Family

  • History of GoldenGate

Oracle GoldenGate Architecture

  • Classic Architecture

  • Microservices Architecture

  • Classic Vs Microservices

  • Oracle GoldenGate Microservices Architecture (MA)

  • Access Points for Microservices

Components of Microservices Architecture

  • Service Manager

  • Administration Service

  • Distribution Service

  • Receiver Service

  • Performance Metrics Service

Deployments

  • What is Deployment?

  • Secure Deployment

  • Non-Secure Deployment

  • Local Deployment

  • Remote Deployment

Components of Data Replication in Oracle GoldenGate

  • Extract

  • Replicat

  • Distribution Paths

  • Trails

  • Parameter Files

  • Checkpoints

  • Checkpoint Files

  • Checkpoint Table

  • Heartbeat Tables

Types of Extracts and Replicats

  • Classic Extract

  • Integrated Extract

  • Classic Replicat

  • Integrated Replicat

  • Coordinated Replicat

  • Parallel Replicat

  • Parallel Integrated Replicat

  • Parallel Non-Integrated Replicat

Installation of Oracle GoldenGate Microservices

  • Preparing the Practice Environment

  • Downloading Oracle GoldenGate Microservices Software

  • Installing the Software

  • Adding a Deployment

Understanding GoldenGate MA Software Installation

  • Installation Directories

  • Top Level Directories

  • Software Home Directory and Files

  • Service Manager Home Directory and Files

  • Deployment Home Directory and Files

  • GoldenGate Daemon

Configuring Databases and GoldenGate for Replication

  • Enabling Force Logging

  • Enabling Supplemental Logging

  • Configuring Archive Log mode

  • Establishing GoldenGate Credentials

  • Enabling GoldenGate in Database

  • Configuring Oracle Net Service Names

Configuring Online Change Synchronization (Unidirectional)

  • Overview of Online Change Synchronization

  • Processing Groups and Naming Convention

  • Adding Extract

  • Adding Replicat

  • Adding Distribution Path

  • Testing Change Synchronization

Configuring Initial Change Synchronization (Initial Load)

What is Initial Load?

  • Prerequisites for Initial Load

  • Implementing Initial Load

  • Adding Initial Load Extract

  • Adding Replicat

  • Adding Distribution Path

Configuring DDL Replication

  • About DDL Replication

  • Enabling DLL Replication

  • Understanding DDL parameter

  • Implementing DDL Replication

Configuring Bi-directional Replication

  • Overview of Bi-directional Replication

  • Architecture of Bi-directional Replication

  • Supported Databases

  • Understanding Data Looping

  • Preventing Data Looping

Using Admin client

  • Becoming Familiar with Admin Client

  • Using Admin Client

Performance Metrics Service

  • Using Performance Metrics Service

Course Videos

Course Materials

Slides
Activity Guide

Introduction to Oracle GoldenGate

Introduction to Oracle GoldenGate
Preview

Oracle GoldenGate Architecture

About Oracle GoldenGate Architecture
Preview
Overview of Microservices Architecture
Preview
Components of GoldenGate MA Architecture
About Deployments
Components of Data Replication - Extract, Replicat
Types of Extracts and Replicats

Oracle GoldenGate MA Installation

Link to download Pre-built VMs
Preparing the Practice Environment
Installing GoldenGate MA Software
Adding Deployment

Configuring Databases and GoldenGate for Replication

Configuring Databases and GoldenGate for Replication
Lab Practice: Configuring Databases and GoldenGate for Replication

Configuring Online Change Synchronization (Unidirectional Active-Passive Replication)

Also called Active - Passive Replication

Configuring Online Change Synchronization
How Start/Stop GoldenGate System

Understanding GoldenGate MA Installation

Understanding GGMA Installation

Configuring Initial Change Synchronization (Initial Load)

Overview of Initial Load
Lab Practice: Implementing Initial Load

Configuring DDL Synchronization

Overview of DDL Synchronization
Lab Practice: Implementing DDL Synchronization

Configuring Bi-directional Replication

Overview of Bi-directional Replication
Lab Practice: Configuring Bi-directional Replication

Admin Client

Using Admin Client

Performance Metrics Service

About Performance Metrics Service

Enroll and Start Learning Now...

1 Year Unlimited Access, Support for Doubt Clarifications