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