Oracle Goldengate Online Training :

Introduction to Oracle Golden Gate:

• 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 from Oracle website.
• Installing Oracle Golden Gate
• Explaining Subdirectories
• Preparing Oracle 11g database for data replication

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

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
• 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 and Initial Data Load

• Overview of DDL synchronization
• Preparing a source database for transaction capture
• Describing the high-level configuration steps
• Configuring Extract and Replicat for DDL replication
• Configuring Initial Data Load using Oracle GoldenGate Extract and Replicat

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

Managing Oracle Golden Gate – oracle goldengate online training

• Managing trail files
• Automating process startup
• Using reporting and statistics

Where Do We Go From Here

• Golden gate Director
• Golden Gate Veridata
• Logdump Utility
• ETL using Golden Gate

Oracle Goldengate Training Online