Oracle GoldenGate 12c: Fundamentals for Oracle

Course DateLocationDaysPriceRegister
Sep 5, 2017Montreal4 $3,860Register
Sep 5, 2017Ottawa4 $3,860Register
Nov 27, 2017Quebec4 $3,860Register
Sep 5, 2017Toronto4 $3,860Register
Oct 23, 2017Toronto4 $3,860Register
Dec 18, 2017Toronto4 $3,860Register
Feb 5, 2018Toronto4 $3,860Register
Apr 3, 2018Toronto4 $3,860Register


Course DateLocationDaysPriceRegister
Oct 10, 2017Live Virtual - 10:00 am Eastern4 $3,680Register
Oct 31, 2017Live Virtual - 11:00 am Eastern4 $3,680Register
Nov 27, 2017Live Virtual - 11:00 am Eastern4 $3,680Register
Aug 22, 2017Live Virtual - 12:00 pm Eastern4 $3,680Register
Sep 26, 2017Live Virtual - 4:00 am Eastern4 $3,680Register
Dec 12, 2017Live Virtual - 4:00 am Eastern4 $3,680Register
Sep 12, 2017Live Virtual - 9:00 am Eastern4 $3,680Register
Sep 11, 2017Live Virtual - 9:30 pm Eastern4 $3,680Register


Course DateLocationDaysPriceRegister
Self-Paced Learning4 $3,400Register


Oracle GoldenGate 12c: Fundamentals for Oracle

Description: This Oracle GoldenGate 12c: Fundamentals for Oracle training focuses on Oracle-to-Oracle database replication. Expert Oracle University instructors will deep dive into the Oracle GoldenGate architecture, walking you through various product features.

Duration: 4 Days

Learn to:

  • 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.

Course Objectives:

  • 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

Audience:

  • Data Warehouse Administrator
  • Data Warehouse Analyst
  • Data Warehouse Developer
  • Database Administrators
  • Database Designers
  • System Integrator
  • Configuration Consultant
  • Technical Consultant

Required Prerequisites:

  • Familiarity with Oracle Database and basic SQL using SQL*Plus
  • Familiarity with editing Linux text files using gedit or vi

Suggested Prerequisites:

  • Familiarity with basic encryption techniques

Topics:

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

Installing Oracle GoldenGate

  • Listing System Requirements
  • Performing Installation
  • Configuring Environment Variables
  • Using GGSCI
  • Running Oracle GoldenGate from the OS shell.

Configuration Overview and Preparing the Environment

  • Reviewing Configuration Overview
  • Configuring Manager Process
  • Creating Source Definitions
  • Preparing the Source Database
  • Assigning Oracle Database Roles/Privileges Required
  • Using DBMS_GOLDENGATE_AUTH Package

Configuring Change Capture (Extract)

  • Reviewing Extract Overview
  • Accessing Logs on Oracle ASM
  • Accessing Logs Remotely
  • Configuring Extract Tasks
  • Adding Extract Group
  • Editing Extract Parameters
  • Extracting Use of Archived Transaction Logs
  • Adding Trails

Configuring Change Delivery (Replicat)

  • Reviewing Replicat Overview
  • Configuring Replicat Tasks
  • Configuring a Sample Environment
  • Configuring New Integrated Replicat

Configuring Extract Trails and Files (Data Pump)

  • Reviewing Extract Trails and Files Overview
  • Describing Trail Formats
  • Using Logdump for Viewing Trails
  • Reversing the Trail Sequence
  • Configuring and Using Data Pumps

Performing Initial Load

  • Oracle GoldenGate Methods
  • Listing Database-specific Methods
  • Describing Resource Limitations
  • Listing Advantages of Oracle GoldenGate Methods
  • Configuring File Load Methods
  • Configuring Direct Load Methods
  • Handling Collisions with Initial Load

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
Course DateLocationDaysPriceRegister
Sep 5, 2017Montreal4 $3,860Register
Sep 5, 2017Ottawa4 $3,860Register
Nov 27, 2017Quebec4 $3,860Register
Sep 5, 2017Toronto4 $3,860Register
Oct 23, 2017Toronto4 $3,860Register
Dec 18, 2017Toronto4 $3,860Register
Feb 5, 2018Toronto4 $3,860Register
Apr 3, 2018Toronto4 $3,860Register


Course DateLocationDaysPriceRegister
Oct 10, 2017Live Virtual - 10:00 am Eastern4 $3,680Register
Oct 31, 2017Live Virtual - 11:00 am Eastern4 $3,680Register
Nov 27, 2017Live Virtual - 11:00 am Eastern4 $3,680Register
Aug 22, 2017Live Virtual - 12:00 pm Eastern4 $3,680Register
Sep 26, 2017Live Virtual - 4:00 am Eastern4 $3,680Register
Dec 12, 2017Live Virtual - 4:00 am Eastern4 $3,680Register
Sep 12, 2017Live Virtual - 9:00 am Eastern4 $3,680Register
Sep 11, 2017Live Virtual - 9:30 pm Eastern4 $3,680Register


Course DateLocationDaysPriceRegister
Self-Paced Learning4 $3,400Register