• Oracle GoldenGate 11g Fundamentals for Oracle 培訓
  Oracle GoldenGate 11g Fundamentals for Oracle 培訓
  培訓大綱：
  1. Oracle GoldenGate 11gR1 Introduction
  Oracle GoldenGate Features and Functionality
  Oracle Middleware for Business Intelligence
  Oracle GoldenGate High Availability and Disaster Tolerance Solutions
  Oracle GoldenGate Real-time Data Integration Solutions
  2. Oracle GoldenGate: Overview
  Oracle GoldenGate Functionality and Components
  Supported Databases and Platforms
  Oracle GoldenGate Product Line
  3. Oracle GoldenGate Architecture
  Oracle GoldenGate Process Groups
  Change Capture and Delivery (with and without a Data Pump)
  Initial Data Load
  Contrasting Batch and Online Operation
  Oracle GoldenGate Checkpointing
  Commit Sequence Number (CSN)
  Oracle GoldenGate Files
  4. Installing Oracle GoldenGate
  Installing Oracle GoldenGate on Linux
  Preparing the Operating System
  Running GoldenGate Commands from the GGSCI Prompt
  Using Obey Files and OS Shell
  Get Help Information on GGSCI Commands
  Types of GGSCI Commands Available
  5. Configuration Overview and Preparing the Environment
  High-Level Configuration Steps
  Configuring and Starting the Manager Process
  Generating a Source Definitions File
  Preparing a Source Database for Transaction Capture
  6. Configuring Change Capture
  Extract Process
  Marking Tables with TRANDATA
  Configuring Extract to Access Logs on Oracle ASM
  Configuring and Starting an Extract Process
  Adding Local and Remote Trails
  Configuring and Starting an Extract Data Pump
  7. Configuring Initial Load
  Oracle GoldenGate Initial Load Methods
  Variety of Database-Specific Methods
  Advantages of Oracle GoldenGate Methods
  Configuring an Initial Load Using Oracle GoldenGate
  8. Configuring Change Delivery
  Replicat Process
  Adding, Configuring, and Starting a Replicat Process
  Avoid and Handle Collisions Between Changes and the Initial Load Data
  9. Extracting Trails and Files
  Extract Trails vs. Files
  Investigating Different Formats
  Viewing Extract Trails and Files with Logdump
  Reversing the Sequence of Operations in an Extract Trail or File to Back Out Changes
  10. Working with Parameters
  Editing Parameter Files
  Contrasting GLOBALS with Process Parameters
  Commonly-Used Parameters for GLOBALS, Manager, Extract, and Replicat
  11. Using Data Selection and Filtering
  Selecting and Filtering Data for Replication
  Mapping Columns Between Different Schemas
  Using Built-In Functions
  Using SQLEXEC to Interact Directly with a Database
  12. Using Additional Transformation Concepts
  Creating and Invoking Macros
  Setting and Retrieving User Tokens
  Running User Exits in GoldenGate Processes
  Replicating Oracle Sequences
  13. Configuration Options
  Using BATCHSQL to Speed Delivery
  Data Compress Across the Network
  Enabling Message, Trail, and Password Encryption
  Using Event Records to Automatically Trigger Actions
  14. Configuring Bidirectional Replication
  Bidirectional Configuration
  Detecting and Avoid Loops
  Avoiding, Detecting, and Handling Conflicts
  Handling Identity Types
  15. Setting Up DDL Replication
  Concept of DDL Replication
  Requirements for Oracle DDL Replication
  GoldenGate Options for DDL Replication
  DDL String Subsitution
  16. Tuning and Troubleshooting
  Controlling Command Permissions
  Managing Trail Files
  Automating Process Setup
  Restarting Oracle GoldenGate
  Handling TCP/IP Errors
  Using Reporting and Statistics
  Monitoring Processes, Lags, and Error Messages
  Features of GoldenGate Management Pack
  ?
  ?
  ?
• 
  ?
  ?

?
?

?

?

?

?

?
?

?
?

?

?

?

?
???

?

?
?

?

?