GoldenGate 12c: Fundamentals for Oracle

Course Fees: $4088.00 excl. GST
Printed Manual: $125.00 excl. GST
Course Duration: 4 days
Course Manual

Sorry, no course dates found

Install Oracle GoldenGate on Linux and Windows platforms.
Issue GGSCI commands.
Configure, start, stop and monitor Change Capture and Delivery processes.
Manage Extract trails and files using Data Pump and logdump.
Create parameter files to transform data.
Manage multiple Oracle GoldenGate instances.
Configuration Consultant
Data Warehouse Administrator
Data Warehouse Analyst
Data Warehouse Developer
Database Administrators
Database Designers
System Integrator
Technical Consultant
Familiarity with basic encryption techniques
Design replication solutions using Oracle GoldenGate products and environments
Install Oracle GoldenGate and prepare the source and target database (assumes Oracle-to-Oracle replication)
Issue GGSCI commands (batch Obey scripts and command-line interactive)
Configure, start, stop, and monitor Change Capture (Extract), Change Delivery (Replicat), and Initial Load
Manage Extract trails and files using Data Pump and utilities such as logdump
Control network transmission using compression and encryption
Transform data
Technology Overview
  • Creating Oracle GoldenGate Topologies
  • Reviewing Oracle GoldenGate Use Cases
  • Assembling Building Blocks
  • Listing Supported OS
  • Listing Supported Databases
  • Listing the Oracle GoldengGate Product Line
  • Describing GUI Management Options
  • Listing Non-Database Sources and Targets

Oracle GoldenGate Architecture
  • Describing Oracle GoldenGate Process Groups
  • Explaining Change Capture and Delivery (with and without a Data Pump)
  • Explaining Initial Data Load
  • Contrasting Batch and Online Operation
  • Explaining Oracle GoldenGate Checkpointing
  • Describing Commit Sequence Numbers (CSN)
  • Describing Oracle GoldenGate Files and Directories

Editing Configuration Parameters
  • Editing Parameter Files
  • Contrasting GLOBALS versus Process Parameters
  • Configuring GLOBALS Parameters
  • Configuring Manager Parameters
  • Configuring Extract Parameters
  • Configuring Replicat Parameters

Filtering and Data Selection

  • Filtering and Data Selection
  • Mapping Columns Between Different Schemas
  • Using Built-in "@" (at) Functions
  • Using SQLEXEC to Interact Directly with a Database
  • Configuring New Coordinated Replicat

Additional Transformation Concepts
  • Configuring and Using Macros
  • Configuring and Using User Tokens
  • Configuring and Using User Exits
  • Configuring and Using Oracle Sequences

Configuration Options
  • Configuring and Using BATCHSQL
  • Configuring and Using Compression
  • Configuring and Using Encryption
  • Configuring and Using Event Actions
  • Configuring New Wallet Security

Bidirectional Replication

  • Reviewing Bidirectional Considerations
  • Detecting Loops
  • Avoiding Conflicts
  • Configuring and Using Conflict Detection and Resolution
  • Describing Identity Types Issues

DDL Replication
  • Reviewing Data Description Language Replication Overview
  • Configuring and Using Options for DDL Replication
  • Configuring and Using String Substitution in DDL