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 (Replicate)
·
Reviewing Replicat Overview
·
Configuring Replicat Tasks
·
Configuring a Sample Environment
·
Configuring New Integrated Replicate
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