Oracle GoldenGate Online Training: Oracle GoldenGate Online Training

ORACLE GOLDENGATE ONLINE TRAINING @ VIVANTA IT LABS

Oracle GoldenGate Online Training course designed to make you an expert in gathering and examine evidence to solve case problems, diagnose their cause and find methods of resolution troubleshoot the issue using GoldenGate software.

Oracle GoldenGate Online Training is a comprehensive software package for real-time data integration and replication in heterogeneous IT environments. The product set enables high availability solutions, real-time data integration, transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems. Oracle GoldenGate 12c brings extreme performance with simplified configuration and management, tighter integration with Oracle Database, support for cloud environments, expanded heterogeneity, and enhanced security.

Oracle GoldenGate 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 Replicat 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