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
GG TRANDATA vs SCHEMATRANDATA
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock