Oracle GoldenGate Training
Oracle GoldenGate Training online course is designed to make you an expert in gathering and examine the evidence to solve problems, diagnose their cause and find methods of solution to troubleshoot the issue using GoldenGate software.
Oracle GoldenGate Online Training Curriculum
Introduction to Oracle Golden Gate
Introduction to Oracle Golden Gate
Understanding Oracle Golden Gate Replication Solutions for Live Reporting, Real Time Data Warehousing, Live Standby Database, and High Availability.
Supported databases and platforms
Advantages of Oracle Golden Gate
Installing Oracle Golden Gate
Downloading the software
Installing Oracle Golden Gate
Explaining Subdirectories
Enabling supplemental logging
Oracle Golden Gate Technology and Architecture
Understanding Golden Gate Components: Processes and Files
Process Data Flow
GoldenGate Architecture
Design Considerations
Configuring & Preparing the Environment
Configuring the Manager process
Describing the Manager Parameters
Starting the Manager process
Configuring GLOBALS file
Configure Initial Load
Data Definitions File
Overview of Data Definitions File
When to use Data Definitions Files
Types of Data Definitions File
Configuring Data Definitions File
Configuring Change Capture Delivery – With and Without Data Pump
Preparing a source database for transaction capture
Describing the high-level configuration steps
Explaining change capture and delivery with a data pump
Explaining change capture and delivery without a data pump
Comparing batch and online operation
Explaining Oracle Golden Gate Checkpoints
Describing the Extract process
Configuring and starting an Extract process
Adding local and remote trails
Configuring and starting a data pump
Explaining the Replicate process
Configuring a Replicate process
Starting a Replicate process
Describing GGSCI commands
Describing Extract trails and files
Configuring Change Capture Delivery – DDL Replication
Overview of DDL synchronization
Preparing a source database for transaction capture
Describing the high-level configuration steps
Configuring Extract and Replicate for DDL replication
Oracle Golden Gate Commands
Running Golden Gate commands from the GGSCI prompt
Running Golden Gate commands from the obey files
Running Golden Gate commands from the OS shell
Identifying the types of GGSCI commands available
Oracle Golden Gate
Managing trail files
Automating process startup
Using reporting and statistics
GoldenGate Security Features
Using message, trail and password encryption
Controlling command permissions – CMDSEC file
Advanced Configuration: Mapping and manipulating data
Overview of data mapping and manipulation
Deciding where data mapping and conversion will take place Data Selection and Filtering
Data Transformation.