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
  • 1.92 MB
Activity Guide
  • 2.11 MB

Introduction to Oracle GoldenGate

Introduction to Oracle GoldenGate
  • 38 mins
  • 51.5 MB
Preview

Oracle GoldenGate Architecture

About Oracle GoldenGate Architecture
  • 15 mins
  • 20.7 MB
Preview
Overview of Microservices Architecture
  • 22 mins
  • 32.7 MB
Preview
Components of GoldenGate MA Architecture
  • 10 mins
  • 14.8 MB
About Deployments
  • 7 mins
  • 10.1 MB
Components of Data Replication - Extract, Replicat
  • 38 mins
  • 54.4 MB
Types of Extracts and Replicats

    Oracle GoldenGate MA Installation

    Link to download Pre-built VMs
      Preparing the Practice Environment
      • 13 mins
      • 26.8 MB
      Installing GoldenGate MA Software
      • 27 mins
      • 56.1 MB
      Adding Deployment
      • 38 mins
      • 68.7 MB

      Configuring Databases and GoldenGate for Replication

      Configuring Databases and GoldenGate for Replication
      • 19 mins
      • 27 MB
      Lab Practice: Configuring Databases and GoldenGate for Replication
      • 39 mins
      • 91.1 MB

      Configuring Online Change Synchronization (Unidirectional Active-Passive Replication)

      Also called Active - Passive Replication

      Configuring Online Change Synchronization
      • 53 mins
      • 85.1 MB
      How Start/Stop GoldenGate System
      • 7 mins
      • 14.4 MB

      Understanding GoldenGate MA Installation

      Understanding GGMA Installation
      • 52 mins
      • 109 MB

      Configuring Initial Change Synchronization (Initial Load)

      Overview of Initial Load
      • 20 mins
      • 23.3 MB
      Lab Practice: Implementing Initial Load
      • 20 mins
      • 31 MB

      Configuring DDL Synchronization

      Overview of DDL Synchronization
      • 13 mins
      • 18.2 MB
      Lab Practice: Implementing DDL Synchronization
      • 11 mins
      • 22.9 MB

      Configuring Bi-directional Replication

      Overview of Bi-directional Replication
      • 20 mins
      • 29.3 MB
      Lab Practice: Configuring Bi-directional Replication
      • 30 mins
      • 66.3 MB

      Admin Client

      Using Admin Client
      • 15 mins
      • 32.3 MB

      Performance Metrics Service

      About Performance Metrics Service
      • 15 mins
      • 28.5 MB

      Enroll and Start Learning Now...

      1 Year Unlimited Access, Support for Doubt Clarifications