GG TRANDATA vs SCHEMATRANDATA

Oracle 12c Golden Gate Masterclass

Introduction to Oracle Golden Gate

Oracle Golden Gate Architecture

Golden Gate vs Data Guard (18:45)
Golden Gate Flow (8:46)
Golden Gate Extract Process (43:00)
Golden Gate Manager Process (3:20)
Golden Gate Checkpoint (16:05)
Classic Capture vs Integrated Capture (14:03)

Practice Lab Setup

Setup First Single Table Replication

Navigating Golden Gate

Golden Gate Initial Load & Change Sync

GG Initial Load Overview (8:43)
Revisiting GG Architecture (4:37)
Initial Load Methods (3:19)
Single Table Initial Load (46:44)
Assignment (20:17)

Golden Gate Advance Administration

GG Parameter Files (3:09)
Parameter File Rules (14:33)
Activity (29:08)
Replication When Table Structure is Different (49:28)
Replication When Table Structure is Semi-Different (21:38)

Handling Collisions Inside GG

Golden Gate Functions

Data Conversion With GG (6:22)
Golden Gate Functions (2:42)
Condition Based Functions (10:57)
Handling Missing Columns (3:59)
Date & Arithmetic Functions (3:39)
Numbers & Character Functions (5:21)
How to Use Functions (9:57)

Data Filtering in Golden Gate

Why Filter Data? (15:01)
Types of Data Filters (17:04)
Filter Functions (11:25)
GG Filter Functions Activity (55:52)
Assignment (13:36)

Golden Gate DDL Replication

What is DDL Replication? (2:24)
Supported Objects (9:06)
DDL Scope (9:12)
DDL Restrictions (8:27)
DDL Replication Activity (8:08)
GG Schema Replication - Scenario 1 (32:17)
Assignment (2:23)
GG Schema Replication - Scenario 2 (17:08)

GG Bidirectional Replication

GG Performance Tuning

Golden Gate Monitoring

Student Interaction (9:03)
Golden Gate Management Pack (8:46)
Golden Gate Director (7:32)
Install Golden Gate Monitor (4:06)
Golden Gate OEM Plug-in (2:24)
Golden Gate Veridata (6:21)

Golden Gate Upgrade

Project Work - Oracle Golden Gate for Different Databases

Summary

Bonus Section

Lecture content locked

If you're already enrolled, you'll need to login.