Oracle GoldenGate 19c: Fundamentals for Oracle

COURSE TOPICS

Module 1 : Introduction

• Introduction
• Use Case Example
• Oracle GoldenGate for Oracle Database Offload Redo Logs
• Supported Operating Systems
• Practice 1-1: Verifying the Lab Environment

Module 2 : Oracle GoldenGate Architecture

• Oracle GoldenGate Architecture
• Oracle GoldenGate Classic Architecture
• Microservices Architecture
• Microservices Architecture: Secure and Nonsecure Deployments
• Extract Types
• Checkpoints: Capture

Module 3 :nInstalling Oracle GoldenGate Microservices Architecture

• Installing Oracle GoldenGate Microservices Architecture
• Phase 2: Creating Certificates
• Phase 3, oggca.sh Step 10: Replication Options
• Practice 3-1: Installing the Oracle GoldenGate Microservices Architecture Software
• Practice 3-2: Configuring Oracle Wallet and Client and Server Certificates
• Practice 3-3: Using oggca.sh to Configure the Service Manager and Source and Target Deployments (Part 01)
• Practice 3-3: Using oggca.sh to Configure the Service Manager and Source and Target Deployments (Part 02)
• Practice 3-4: Verifying the Successful Installation and Configuration of the MA Implementation

Module 4 : Installing Oracle GoldenGate Classic Architecture

• Installing Oracle GoldenGate Classic Architecture
• Installation on Linux Using a tar Command
• Running Oracle GoldenGate from the OS Shell
• Practice 4-1: Installing Oracle GoldenGate Classic Architecture
• Practice 4-2: Setting the Stage
• Practice 4-3: Using the GGSCI

Module 5 : Preparing the Environment

• Preparing the Environment
• Preparing the Environment: Supplemental Logging
• Handling TCP/IP Errors
• Practice 5-1: Preparing the Environment (Part01)
• Practice 5-1: Preparing the Environment (Part02)

Module 6 : Configuring the Extracts

• Configuring the Extracts
• MA Administration Server: Webpage Overview
• CA Editing Extract Parameters: ggsci Example
• Data Definition Language Replication
• Practice 6-1: Configuring Integrated Extract
• Practice 6-2: Configuring Classic and Pump Extracts

Module 7 : Oracle GoldenGate Microservices Architecture: Distribution Server

• Oracle GoldenGate Microservices Architecture: Distribution Server
• Web Page Overview
• Practice 7-1: Configuring a Path Using the adminclient

Module 8 : Oracle GoldenGate Microservices Architecture: Receiver Server

• Oracle GoldenGate Microservices Architecture: Receiver Server
• Secure GoldenGate Host Machine with Reverse Proxy
• Practice 8-1: Accessing the Receiver Server to Display Path Statistics
• Practice 8-2: Configuring Reverse Proxy (Part01)
• Practice 8-2: Configuring Reverse Proxy (Part02)

Module 9 : Configuring Initial Load

• Configuring Initial Load
• Prerequisites for Initial Load
• MA Initial Load: Oracle GoldenGate Methods
• Practice 9-1: Configuring Initial Load by Using File to Replicat Method (Part 01)
• Practice 9-1: Configuring Initial Load by Using File to Replicat Method (Part 02)
• Practice 9-2: Configuring Initial Load by Using Oracle Data Pump
• Practice 9-3: Configuring Initial Load by Using Bulk Load

Module 10 : Configuring Replicat

• Configuring Replicat
• Comparison of Replicats
• Parallel Replicat
• MA: Change Delivery Tasks
• Obtaining Process Information: adminclient or GGSCI
• Practice 10-1: Configuring Parallel Replicat Nonintegrated Mode Using adminclient
• Practice 10-2: Generating Activity and Testing Replication
• Practice 10-3: Configuring Parallel Replicat Using GGSCI

Module 11 : Managing Extract Trails and Files

• Managing Extract Trails and Files
• Alternative Trail Formats
• Counting Records in the Trail
• Practice 11-1: Using the logdump Utility

Module 12 : Oracle GoldenGate Parameters

• Oracle GoldenGate Parameters
• MA Managed Process Settings Profile
• Extract Parameter Categories
• Replicat Parameter Categories
• Practice 12-1: Configuring an Administration Server Managed Process Settings Profile and Purge Trails Task for Extract
• Practice 12-2: Configuring an Administration Server Managed Process Settings Profile and Purge Trails Task for Replicat
• Practice 12-3: Modifying Extract Parameters
• Practice 12-4: Modifying Source Manager Parameters
• Practice 12-5: Modifying Target Manager Parameters

Module 13 : Data Selection and Filtering

• Data Selection and Filtering
• MA Distribution Server Path: Filter Clause
• SQLEXEC: Usage with a LOOKUP Stored Procedure
• Practice 13-1: Configuring Filters in Extract and Replicat Groups (Part 01)
• Practice 13-1: Configuring Filters in Extract and Replicat Groups (Part 02)
• Practice 13-2: Creating a Path Filter
• Practice 13-3: Mapping Different Column and Table Names Between Source and Target (Part 01)
• Practice 13-3: Mapping Different Column and Table Names Between Source and Target (Part 02)
• Practice 13-4: Invoking Stored Procedures from Coordinated Replicat Processes

Module 14 :nData Transformation and Configuration Options

• Data Transformation and Configuration Options
• User Tokens: Overview
• Sample User Exits
• Encryption: Overview
• CA Password Encryption: Method 1
• Practice 14-1: Triggering and Executing End-of-Day Job (Database Backup) via EVENTACTIONS (Part 01)
• Practice 14-1: Triggering and Executing End-of-Day Job (Database Backup) via EVENTACTIONS (Part 02)
• Practice 14-2: Configuring CA Pump Extract to Send Changes to MA Receiver Server (Part 01)
• Practice 14-2: Configuring CA Pump Extract to Send Changes to MA Receiver Server( Part 02)

Module 15 : Oracle GoldenGate Microservices Architecture—Performance Metrics Server

• Oracle GoldenGate Microservices Architecture—Performance Metrics Server
• Replicat Group: Process Performance Analysis
• Practice 15-1: Causing Database Activity and Monitoring Through the Performance Metrics Server (Part 01)
• Practice 15-1: Causing Database Activity and Monitoring Through the Performance Metrics Server (Part 02)

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

• Database Sharding Support, Replication Lag Management, Invisible Column Support
• Oracle GoldenGate MA Sharding Advantages
• Accessing Heartbeat Statistics
• Practice 16-1: Configuring Replication Lag and Checking Lag Statistics for MA
• Practice 16-2: Configuring Replication Lag and Checking Lag Statistics for CA and MA
• Practice 16-3: Replicating Invisible Columns