Course outline
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
10. Filtering and Data Selection
11. Additional Transformation Concepts
12. Configuration Options
13. Bidirectional Replication
14. DDL Replication
