Section 1: Goldengate Architecture

GG Components

Architecture Basics

Processes

Parameters

Topologies

Role Of Datapump In GG

Integrated Extract

Data Load

Section 2: Setting Of Up Linux Server And Installation Of Oracle DB

Install Oracle Enterprise Linux Servers

Install Oracle Database Software

Setup Goldengate OS Add-On

Clone Linux Servers

Configure Oracle Databases

Goldengate Use Cases

Section 3: Install GoldenGate

Supported DB’s

OS Combinations

Software And OS Requirements

Installation – OUI

Directories

Section 4: Oracle To Oracle Configuration Basics

Steps To Configure

Preparing Environment – Character Set

Configure User – Oracle Database

Network Diagnostics

Preparing Environment – Supplemental Logging

Configuring Manager

Section 5: Extract Data

Change Capture

Datapump Options

Process Groups

Configure Wallet

Integrated Capture

Extract Trails

Start Extract

Section 6: Replicate Data

Change Delivery Basics

CDD Activities

Treat Collisions

Integrated Apply

Monitoring

Reports & Diagnostics

Section 7: Monitoring GoldenGate

What is GGSCI ?

Various GGSCI Command to Monitor Extract , Pump and Replicat Process 

Monitor Lag and Statistics

Section 8 : Trail Files

Extract Trails And Files

Formats

Substitutes

Logdump

Logging Trails

Reverse Utility

Section 9: Replication With Initial Load

Initial Load

Kick Start Load

Pre-Checks

Methods

File Based Loading

Direct Load

Section 10: Data And Configurations

GLOBAL & Manager Parameters

Extract & Replicat Parameters

Data Selection: WHERE, FILTER

Data Mapping: Columns

RANGE

SQLEXEC Functionalities

Functions Specific To Goldengate

Section 11: Other Considerations In GG

Macros & Tokens

User Exits & Sequences

Batchsql In GG

Data Compression In GG

Daa Encryption & Events

Section 12: Bi-Directional Replication Configuration ( Active - Active )

Configurations

Data Loopings

CDR ( Conflict Detection And Resolution )

Section 13: DDL Replication

About DDL Replication

Things to consider before configuring DDL Replication

Configuring DDL Replication

Configure "Sequence Number" Replication

Section 14: GoldenGate New Features

GoldenGate Microservice Architecture

Format Release parameter

Trail File Difference

Automatic Heartbeat Table

Improved Trail File Recovery

Credential Store and Useridalias

Parallel Replicate

Auto-CDR

Procedural Replication to Enable simpler migrations and upgrades

Cross Endian Support For Remote Integrated Extract

Enhanced the Heartbeat table to Include details for restarting extract