Oracle 12c Golden Gate Masterclass
Replicate data between databases with millisecond lag
Count
Low latency. High performance. Keep data in sync.
The ultimate data replication tool is here. Oracle Golden Gate replicates data with millisecond lag in a heterogeneous environment along with uncompromizing performance. The modular architecture allows you to customize every module to suit your data replication requirement. Whether on premises or on cloud, Golden Gate is an unbeatable data replication tool.
What you will learn
Setup Golden Gate for Unidirectional and Bi-directional replication
Identify and fix common Golden Gate performance tuning issues
Experience the difference between Classic capture and Integrated capture
Zero downtime Golden Gate migration along with upgrade
Introduction to Oracle Golden Gate
31:29
Course Overview
23:01
Golden Gate Overview
05:14
Important replication terms
12:31
When to use Golden Gate?
Oracle Golden Gate Architecture
18:45
Golden Gate vs Data Guard
08:46
Golden Gate Flow
43:00
Golden Gate Extract Process
03:20
Golden Gate Manager Process
16:05
Golden Gate Checkpoint
14:03
Classic vs Integrated Capture
Practice Lab Setup
01:31:32
Setup Virtual Machines
02:19:24
Install Golden Gate
38:50
Setup Golden Gate Replication
Setup First Single Table Replication
51:07
Single Table Replication
55:50
Single Table Replication Cont.
Add Lag on Target REPLICAT
Navigating Golden Gate
41:09
GG Process, Trail & Directory
22:12
GG Reporting Commands
24:09
GG Trail Files
Delete Extract, Pump & Replicat
Assignment
13:12
Defining Total GG Processes
Golden Gate Initial Load & Change Sync
08:43
GG Initial Load Overview
04:38
Revisiting GG Architecture
03:19
Initial Load Methods
46:44
Single Table Initial Load
20:17
Assignment
Golden Gate Advance Administration
03:09
GG Parameter Files
14:33
Parameter File Rules
29:08
Activity
49:28
Replicat Different Table Structure
21:38
Replicat Semi-Different Table Structure
Handling Collisions Inside GG
19:25
How to Handle Collisions
08:19
What are Collisions
26:06
Handle Collisions
Golden Gate Functions
06:22
Data Conversion With GG
02:42
Golden Gate Functions
10:57
Condition Based Functions
03:59
Handling Missing Columns
03:39
Date & Arithmetic Functions
05:21
Number & Char Functions
09:57
How to Use Functions
Data Filtering in Golden Gate
15:01
Why Filter Data
17:04
Types of Data Filters
11:25
Filter Functions
55:52
GG Filter Functions
13:36
Assignment
Golden Gate DDL Replication
02:24
What is DDL Replication
09:06
Supported Objects
09:12
DDL Scope
08:27
DDL Restrictions
08:08
DDL Replication Activity
32:17
Schema Replication #1
02:23
Assignment
17:08
Schema Replication #2
GG Bidirectional Replication
20:20
What is Bidirectional Replication?
09:40
Bidirectional Replication Activity
GG Performance Tuning
13:54
GG Best Practices
03:25
Batch Transactions
03:50
Optimizing Stream Pool
22:22
Range Splitting
Golden Gate Monitoring
09:03
Student Interaction
08:46
Golden Gate Management Pack
07:32
Golden Gate Director
04:06
Install Golden Gate Monitor
02:24
Golden Gate OEM Plug-in
06:21
Golden Gate Veridata
Golden Gate Upgrade
14:43
Zero Downtime GG Migration
03:31
Rollback Plan with Golden Gate
51:24
GG 12.1 to 12.2 Upgrade
Project Work - Oracle Golden Gate for Different Databases
18:48
Oracle to MYSQL Replication
18:48
Oracle to MYSQL Replication - 2
01:07:43
MS SQL Server to Oracle
Summary
TRANDATA vs SCHEMATRANDATA
COLMATCH Parameter
Purge Old Trail Files
01:55:42
OGG Cloud Service
Upgrade Classic to Integrated Capture
GG Multi DB Connection