Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
Oracle 12c Golden Gate Masterclass
Introduction to Oracle Golden Gate
Course Overview (31:29)
Golden Gate Overview (23:01)
Important replication terms (5:14)
When to use Golden Gate? (12:31)
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
Create VMs and Install Oracle Database (91:32)
Create Database & Install Golden Gate (139:24)
Setup Golden Gate for Replication (38:50)
Setup First Single Table Replication
Single Table Replication (51:07)
Single Table Replication Cont. (55:50)
Add Lag on Target REPLICAT
Assignment
Navigating Golden Gate
GG Process, Trail Files & Directory Structure (41:09)
GG Reporting Commands (22:11)
GG Trail Files (24:09)
Delete Extract, Pump & Replicat
Assignment
Defining Total GG Processes (13:12)
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
How to Handle Collisions? (19:25)
What are Collisions? (8:19)
HANDLECOLLISIONS Parameter (26:06)
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
What is Bidirectional Replication? (20:20)
Bidirectional Replication Activity (9:40)
GG Performance Tuning
GG Best Practices (13:54)
Batch Transactions (3:25)
Optimizing Stream Pool (3:50)
Range Splitting (22:22)
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
Zero Downtime GG Migration (14:43)
Rollback Plan with Golden Gate (3:31)
Golden Gate 12.1 to 12.2 Upgrade (51:24)
Project Work - Oracle Golden Gate for Different Databases
Project 1 - Oracle to MYSQL Replication (94:38)
Project 2 - MS SQL Server to Oracle Replication (67:43)
Summary
GG TRANDATA vs SCHEMATRANDATA
Golden Gate COLMATCH Parameter
Purge Old Trail Files
Oracle Golden Gate Cloud Service and High Availability (115:42)
Important - How to upgrade classic capture to integrated capture
GG connection with multiple databases on a server
Bonus Section
Oracle Golden Gate Certification
Golden Gate Interview Questions
Golden Gate DBA Resume Points
Why Filter Data?
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock