Downloading the software

Installing Oracle GoldenGate

Explaining Subdirectories

Enabling supplemental logging

Understanding GoldenGate Components: Processes and Files

Process Data Flow

GoldenGate Architecture

Design Considerations

Configuring the Manager process

Describing the Manager Parameters

Starting the Manager process

Configuring GLOBALS file

Configure Initial Load

Overview of Data Definitions File

When to use Data Definitions Files

Types of Data Definitions File

Configuring Data Definitions File

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

Comparing batch and online operation

Explaining Oracle GoldenGate 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

Overview of DDL synchronization

Preparing a source database for transaction capture

Describing the high-level configuration steps

Configuring Extract and Replicate for DDL replication

Running GoldenGate commands from the GGSCI prompt

Running GoldenGate commands from the obey files

Running GoldenGate commands from the OS shell

Identifying the types of GGSCI commands available

Managing trail files

Automating process startup

Using reporting and statistics

Using message, trail and password encryption

Controlling command permissions – CMDSEC file

Overview of data mapping and manipulation

Deciding where data mapping and conversion will take place Data Selection and Filtering

Data Transformation