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.

  • PRIVATE
  • 10 Days
  • 0 Units
  • 0 Hrs

Select Your Currency

WOOCS 1.1.8
Drop Us A Query
[contact-form-7 id="5639" title="Drop Us A Query"]
© 2016, ALL RIGHTS RESERVED.
Create an Account