Oracle GoldenGate 12c: Fundamentals for Oracle Training

  • Overview
  • Course Content
  • Drop us a Query

Oracle GoldenGate 12c: Fundamentals for Oracle training focuses on the functions, features, architecture, parameters, and commands for the installation and configuration of Oracle GoldenGate. The training explains how to maintain Oracle-to-Oracle database replication on a Windows or Linux platform. The candidates will learn how to extract trails and files using Data Pump, create parameter files and manage Oracle GoldenGate instances.

Oracle GoldenGate 12c: Fundamentals for Oracle course will help you in the following ways:

  • Install GoldenGate and issue the Oracle GoldenGate command line interface (GGSCI) efficiently
  • Prepare the source and target database (assumes Oracle-to-Oracle replication)
  • Use Oracle GoldenGate products and environments to design the replication solutions and manage multiple Oracle GG instances
  • Configure, and monitor Change Capture (Extract), and Change Delivery (Replicat)
  • Perfom Initial Load and edit configuration parameters
  • Manage Extract trails and files using Data Pump
  • Use  encryption and compression to control network transmission
  • Use macros, user tokens, user exits, Oracle Sequences to transform data
Target audience
  • Data Warehouse Developer
  • Data Warehouse Analyst
  • Data Warehouse Administrator
  • Database Designers
  • Database Administrators
  • System Integrator
  • Technical Consultant
  • Configuration Consultant
Prerequisites
  • Basic understanding of Oracle Database and basic SQL using SQL*Plus
  • Conceptual  idea of editing Linux text files using gedit or vi
  • Knowledge of basic encryption techniques will be an added advantage

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

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

3. Installing Oracle GoldenGate

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

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

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

6. Configuring Change Delivery (Replicat)

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

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

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

9. Editing Configuration Parameters

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

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

11. Additional Transformation Concepts

  • Configuring and Using Macros
  • Configuring and Using User Tokens
  • Configuring and Using User Exits
  • Configuring and Using Oracle Sequences

12. Configuration Options

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

13. Bidirectional Replication

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

14. DDL Replication

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

Partners

A Few Things You'll Love!

What our Students Speak

+