Formation Oracle GoldenGate 19c

Module 1: Introduction

Overview of the Course Content

Introduction to Oracle GoldenGate

Understanding Use Cases and Scenarios

Exploring Oracle GoldenGate for Oracle Database Offload Redo Logs

Supported Operating Systems

Practice Session: Verifying the Lab Environment

Module 2: Oracle GoldenGate Architecture

Deep Dive into Oracle GoldenGate Architecture

Comparison between Oracle GoldenGate Classic Architecture and Microservices Architecture

Understanding the Secure and Non-secure Deployments in Microservices Architecture

Extract Types and Checkpoints for Data Capture

Module 3: Installing Oracle GoldenGate Microservices Architecture

Step-by-Step Guide to Installing Oracle GoldenGate Microservices Architecture

Creating Certificates for Secure Deployment

Configuring Replication Options with oggca.sh

Practice Sessions: Installing and Configuring Oracle GoldenGate Microservices Architecture Software

Module 4: Installing Oracle GoldenGate Classic Architecture

Installation Process of Oracle GoldenGate Classic Architecture

Installing on Linux Using a tar Command

Operating Oracle GoldenGate from the OS Shell

Practice Sessions: Installing and Configuring Oracle GoldenGate Classic Architecture

Module 5: Preparing the Environment

Preparing the Environment for Data Replication

Supplemental Logging for Data Integrity

Handling TCP/IP Errors for Seamless Integration

Practice Sessions: Preparing the Environment and Handling TCP/IP Errors

Module 6: Configuring the Extracts

Configuring Extracts for Data Capture

Overview of MA Administration Server and Webpage

Editing Extract Parameters with ggsci Example

Data Definition Language Replication Techniques

Practice Sessions: Configuring Integrated Extract and Classic and Pump Extracts

Module 7: Oracle GoldenGate Microservices Architecture: Distribution Server

Understanding Distribution Server in Microservices Architecture

Exploring the Web Page Interface for Configuration

Practice Session: Configuring Path Using the adminclient

Module 8: Oracle GoldenGate Microservices Architecture: Receiver Server

Configuring Receiver Server in Microservices Architecture

Securing GoldenGate Host Machine with Reverse Proxy

Practice Sessions: Accessing Receiver Server and Configuring Reverse Proxy

Module 9: Configuring Initial Load

Prerequisites and Methods for Initial Data Load

Configuring Initial Load Using Various Methods

Practice Sessions: Configuring Initial Load by Using File to Replicat Method and Oracle Data Pump

Module 10: Configuring Replicat

Understanding Replicat Configuration

Comparison of Replicat Types and Parallel Replicat Setup

Managing Change Delivery Tasks and Process Information

Practice Sessions: Configuring Parallel Replicat Using adminclient and GGSCI

Module 11: Managing Extract Trails and Files

Effective Management of Extract Trails and Files

Exploring Alternative Trail Formats and Counting Records

Practice Session: Utilizing the logdump Utility for Trail Management

Module 12: Oracle GoldenGate Parameters

Overview of Oracle GoldenGate Parameters

Configuring Managed Process Settings Profile for Extract and Replicat

Modifying Extract, Source Manager, and Target Manager Parameters

Practice Sessions: Configuring Managed Process Settings Profile and Modifying Parameters

Module 13: Data Selection and Filtering

Techniques for Data Selection and Filtering

Implementing Filters in Extract and Replicat Groups

Mapping Different Column and Table Names Between Source and Target

Practice Sessions: Configuring Filters and Mapping Column Names

Module 14: Data Transformation and Configuration Options

Exploring Data Transformation Techniques

Overview of User Tokens and Encryption Methods

Configuring CA Pump Extract and EVENTACTIONS for Job Triggers

Practice Sessions: Triggering End-of-Day Job and Configuring Data Transformation

Module 15: Oracle GoldenGate Microservices Architecture—Performance Metrics Server

Understanding Performance Metrics Server in Microservices Architecture

Analyzing Process Performance with Replicat Group

Practice Session: Monitoring Database Activity Through Performance Metrics Server

Module 16: Database Sharding Support, Replication Lag Management, Invisible Column Support

Advantages of Database Sharding Support in Oracle GoldenGate

Accessing Heartbeat Statistics for Replication Lag Management

Replicating Invisible Columns in Data Replication Process

Practice Sessions: Configuring Replication Lag and Replicating Invisible Columns