Detailed Course Outline
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