Oracle GoldenGate- Bespoke

• Understanding of database architecture and virtual machines
• Basic knowledge of Oracle databases

Oracle GoldenGate is a software product for real-time replication and migration across different databases. It provides a reliable, secure, and straightforward platform for transforming and integrating data on a large database.

By the end of this training, participants will be able to:

• Install and configure Oracle GoldenGate.
• Understand Oracle databases replication using the Oracle GoldenGate tool.
• Understand the Oracle GoldenGate architecture.
• Configure and perform a database replication and migration.
• Optimize Oracle GoldenGate performance and troubleshoot issues.

Introduction

• Overview of Oracle GoldenGate 19c features and architectures (Classic Architecture, Microservices Architecture)
• Understanding Oracle GoldenGate 19c processing methods and databases

Getting Started

• Setting up a practice lab
• Installing Oracle GoldenGate 19c Microservices Architecture
• Navigating the Oracle GoldenGate 19c user interface

Configuring Oracle GoldenGate

• Configuring Oracle Database 19c for Oracle GoldenGate 19c replication (accounts, privileges, parameters, modes)
• Setting up Oracle GoldenGate processes
• Monitoring Oracle GoldenGate configurations

Setting up and Implementing Replication

• Implementing an initial data load
• Implementing unidirectional replication
• Implementing bidirectional replication

Filtering and Manipulating Data

• Implementing data mapping and filtering
• Transforming data in Oracle GoldenGate 19c

Monitoring and diagnostics

• Monitoring Oracle GoldenGate 19c components and processes
• Analyzing Oracle GoldenGate 19c trail files
• Using error logs, discard files, tracing
• Performance tuning techniques