Oracle GoldenGate Fundamentals

Course Description

This Oracle GoldenGate 19c: Fundamentals for Oracle training focuses on Oracle-to-Oracle database replication. Our expert Oracle trainer will deep dive into the Oracle GoldenGate product suite, walking you through various product features.
4 Days
Contact us for pricing
 

Introduction

Use Case Example
Oracle GoldenGate for Oracle Database Offload Redo logs
Supported Operating Systems

Oracle GoldenGate Architecture

Oracle GoldenGate Classic Architecture
Microservices Architecture
Microservices Architecture: Secure and nonsecure deployments
Extract types
Checkpoints: Capture

Installing Oracle GoldenGate Microservices Architecture

Installing Oracle GoldenGate Microservices Architecture
Creating certificates

Installing Oracle GoldenGate Classic Architecture

Installing on Linux using a tar command
Running Oracle GoldenGate from the OS Shell

Preparing the environment

Supplemental logging
Handling TCP/IP errors

Configuring the extracts

MA Administration Server
CA Editing extract parameters
Data definition language replication

Oracle GoldenGate Microservices Architecture: Distribution Server

Web page overview

Oracle GoldenGate Microservices Architecture: Receiver Server

Secure GoldenGate host machine with Reverse Proxy



Configuring Initial Load

Configuring
Prerequisites
MA Initial load: Oracle GoldenGate Methods

Configuring Replicat

Configuring Replicat
Comparison of Replicats
Parallel Replicat
MA Change Delivery Tasks
Obtaining Process information

Managing Extract Trails and Files

Alternative Trail formats
Counting records in the trail
Using the logdump utility

Oracle GoldenGate Parameters

MA Managed Process Settings profile
Extract Parameter Categories
Replicat Parameter Categories

Data Selection and Filtering

MA Distribution Server Path: Filter Clause
@IF Function
SQLEXEC: Usage with a LOOKUP Stored Procedure

Data Transformation and Configuration options

User Tokens: Overview
Sample User exits
Encryption: Overview

Oracle GoldenGate Microservices Architecture: Performance Metrics Server

Replicat Group: Process Performance Analysis

Database Sharding Support, Replication Lag Management, Invisible Column support

Oracle GoldenGate MA Sharding Advantages
Accessing Heartbeat statistics
OracleGoldenGateGolden Gate