Who Should Attend:

– Database Administrators (DBAs)
– PL/SQL Developers
– Oracle GoldenGate Administrators
– Technologists responsible for data replication
– High availability specialists
– Solution Architects
– Data Architects

Classic GG Course Curriculum:

1) Overview and Introduction of Oracle Database:
– Architecture
– Oracle GoldenGate replication solutions: Live Reporting, Real-Time Data Warehousing, Live Standby Database, and High Availability
– Supported databases and platforms
– Advantages of Oracle GoldenGate

2) Types of Oracle GoldenGate Architecture:
– Classic Architecture
– Microservices Architecture
– Types of Extracts and Replicats

3) Installing Oracle GoldenGate:
– Downloading the software from Oracle website
– Installing Oracle GoldenGate
– Explanation of subdirectories
– Preparing Oracle 12c database for data replication

4) Oracle GoldenGate Architecture:
– Concepts and Components
– Process Data Flow
– Design Considerations

5) Configuring & Preparing the Environment:
– Configuring the Manager process
– Describing Manager Parameters
– Starting the Manager process
– Configuring the GLOBALS file

6) DML Replication – Online Change Synchronization:
– Description and Demo
– Integrated Extract
– Integrated Replicat
– Parallel Replicat (Integrated and Classic)

7) Initial Load:
– Synchronizing two databases initially
– Direct Load and File to Replicat

8) Zero Downtime Migration and Upgrade Using GoldenGate:
– Migration and Upgrade Strategy

9) Oracle GoldenGate 19c New Features:
– Remote Capture cross-endian support

10) Upgrading Oracle GoldenGate from 12c to 19c

11) Parameter Files:
– Parameters overview
– Handling collisions with HANDLECOLLISIONS
– Understanding and configuring Parameter Files

12) DDL Replication:
– Overview of DDL synchronization: Alter, Drop, Create
– Configuring Extract and Replicat for DDL replication

13) Bidirectional Replication:
– CDR (Conflict Detection and Resolution) new feature
– Active-Active and Active-Passive configurations

14) Oracle GoldenGate Security:
– Wallet creation
– Password encryption

15) Troubleshooting Oracle GoldenGate Issues:
– Creating Discard Files
– Adding new tables to an existing GoldenGate configuration
– Adjusting Extract and Replicat based on SCN, DB logs, and Timestamp

16) Managing Oracle GoldenGate:
– Managing trail files
– Automating process startup
– Using reporting and statistics

17) Reading Trail Files:
– Logdump utility
– How to read trail files
– Resolving issues from trail files.

18) Performance Monitoring of Oracle GoldenGate:
– Monitoring GoldenGate performance and lag
– GoldenGate Heartbeat table and PMSRVR
– Checkpoint and CSN in Oracle GoldenGate

Microservice GG Course Curriculum:

– Overview and Introduction to GoldenGate Microservices

– Download and Installation of GoldenGate Microservices Architecture (MSA)

– Creating Service Manager and Deployments

– Adding Credentials to the Credential Store

– Configuration of GoldenGate MSA

– Adding Extracts, Replicats, and Distribution Servers in GoldenGate

– Bounded Recovery Concept in GoldenGate

– Parameters and Configuration of Parameter Files in GoldenGate MSA

– Recovering/Resetting the Service Manager Password

– Comparison of GoldenGate MSA Architecture with Classic/Integrated Architecture

– Initial Load in GoldenGate Microservices – File to Replicat

– Monitoring and Performance Metrics in GoldenGate MSA

– Admin Client in Microservices vs GGSCI in Classic Architecture

– Reading Trail Files in MSA (Using Logdump)

– DDL Replication in GoldenGate MSA

– Bidirectional Replication and Auto CDR Setup in GoldenGate MSA

– Directory Structure Comparison between GoldenGate Classic and MSA

– Replication from Classic Architecture (Source) to Microservices Architecture (Target)

– Replication from Microservices Architecture (Source) to Classic Architecture (Target)

– Upgrading Oracle GoldenGate Microservices

– Troubleshooting Issues in GoldenGate MSA

– Deinstallation of Oracle GoldenGate Microservices