Course Details
Oracle Golden Gate Online Training
Oracle Golden Gate Course Overview:
Oracle Golden Gate Course Content:
- Introduction to Oracle Golden Gate 11g: Fundamentals for Oracle
- Objectives
- Oracle Golden Gate 11g
- Key Capabilities & Technology Differentiators
- Value Propositions for Oracle Golden Gate
- Oracle Golden Gate Topologies
- Oracle middleware for Business Intelligence
- Oracle Data Integrator EE & Oracle Golden Gate
- Oracle Golden Gate for Real-Time Data Warehousing
- Oracle Golden Gate Solutions for Oracle Database
- Oracle Golden Gate for Oracle Database Eliminate down Time for Migrations and Application upgrades
- Oracle Golden Gate for Oracle Database Eliminate down Time during Oracle Database upgrades
- Oracle Golden Gate for Oracle Database Eliminate up planned Down Time with Active Data Guard and Oracle Golden Gate
- Oracle Golden Gate for Oracle Database Improve Production System Performance and Lower costs
- Oracle Golden Gate for Operational Reporting
- Oracle Golden Gate for Oracle Database Increase Returns on Investment on Existing Servers and Synchronize Global Data
Technology Overview
- Oracle Golden Gate: Modular Building Blocks
- Supported Databases and Operating systems
- Oracle Golden Gate Product Line
- Oracle Golden Gate Veridata
- Oracle Golden Gate Director: Overview
- Oracle Golden Gate Monitor: Overview
- Adapter Integration Options for Oracle Golden Gate
- Oracle Golden Gate for Flat File
- Oracle Golden Gate Application Adapter for Java
- JMS Messaging Capture
Oracle Golden Gate Architecture
Objectives
- Oracle Golden Gate Uses
- Oracle Golden Gate Components
- Oracle Golden Gate Logical Architecture
- Oracle Golden Gate Process Groups
- GGSCI
- Parameter Files
- Change Data Capture and Delivery
- Change Data Capture and Delivery using a Data Pump
- Running an Initial Load
- Initial Load
- Checkpoints
- Check pointing
- Commit Sequence Number (CSN)
Installing Oracle Golden Gate
- System Requirements
- Operating System Requirements
- Downloading Oracle Golden Gate
- Installation on UNIX, Linux or Z/OS
- Installation on Windows
- Oracle Golden Gate Directories
- Oracle Golden Gate Documentation
- GGSCI Command Interface
- GGSCI Commands
- GGSCI Command Examples
- OBEY Files
- New Oracle Golden Gate 11g R1 GGSCI Miscellaneous Commands
- Running Oracle Golden Gate from the OS Shell
Configuration Overview and Preparing the Environment
- Configuring Oracle Golden Gate
- Preparing the Environment: Oracle Database
- Preparing the Environment: Manager Overview
- Preparing the Environment: Configuring Manager
- Preparing the Environment: Sample Manager Parameter File
- Preparing the Environment: Overview of Source Definitions
- Preparing the Environment: Running defgen
Configuring Change Capture
- Step 2: Change Capture
- Extract Overview
- Data pump Overview
- Data pump: One-to-many Trails
- Data pump: One-to-many Target Systems
- Setting up Change Capture
- Add Extract Command
- Add Extract Examples
- Editing Extract Parameters
- Passive Alias Extract
- Overview of Trails
- Adding a Local or Remote Trail
- Starting the Extract
- Primary Extract Configuration for Oracle
- Data pump Configuration for Oracle
- Automatic Storage Management (ASM)
- Ensuring ASM Connectivity
Configuring Initial Load
- Objectives
- Initial Load: Advantages of Oracle Golden Gate Methods
- Initial Load: Resource Limitations
- Prerequisites for Initial Load
- Initial Load: Oracle Golden Gate Methods
- Initial Load: File to Replicate
- Initial Load: File to Database Utility
- Initial Load: Direct Load
- Initial Load: Direct Bulk Load (to Oracle)
Configuring Change Delivery
- Step 4: Change Delivery
- Replicate Overview
- Change Delivery Tasks
- Checkpoint Table
- Sample Configuration
- Avoiding Collisions with Initial Load
- Handling Collisions with Initial Load
Extract Trail and Files
- Overview of Extract Trails and Files
- Extract Trails and Files Distribution
- Extract Trails and Files Contents
- Extract Trails and Files Clean up
- Trail Format
- Record Header Area
- Record Data Area
- Setting the Compatibility Level
- Alternative Trail Formats
- FORMATASCII
- FORMATASCII Sample Output
- FORMATSQL
- FORMATSQL Sample Output
- FORMATXML
- FORMATXML Sample Output
- Log dump Utility
- Opening a Trail
- Setting up a View
- Viewing the Trail file Header
- Viewing Trail Records
- Counting Records in the Trail
- Filtering by a File name
- Locating a Hex Data Value
- Saving Records to a new Trail
- Keeping a Log of Your Session
- Overview of the Reverse Utility
- Overview Process of the Reverse Utility
- Reverse: Overview Process
- Sample Parameter Files
Oracle Golden Gate Parameter
- Oracle Golden Gate Parameter Files
- Using Parameter Files
- Global versus Process Parameters
- Global Parameters
- Manager Parameters: Overview
- Sample Manager Parameter File
- Manager Parameter Categories
- Extract Parameter Overvie
- Extract Parameter Defaults
- Sample Extract Parameter File
- Extract Parameter Categories
- Extract Example: Table Parameter
- Extract Example: Tranlogoptions Paramete
- Replicat Parameter Overview
- Replicat Parameter Defaults
- Sample Replicat Parameter File
- Replicat Parameter Categories
- Replicat Example: MAP Parameter
- Db options
Data Selection and Filtering
- Overview of Data Mapping and Manipulation
- Types of Definition Files
- Data Selection: Overview
- Data Selection: WHERE Clause
- Data Selection: WHERE Clause Examples
- Data Selection: FILTER Clause
- Data Selection: FILTER Clause Examples
- Data Selection: RANGE Function
- Data Selection: RANGE Function Example
- Column Mapping: Overview
- Column Mapping: Example
- Column Mapping: Building History
- Data Transformation using Functions
- Functions: Performing Tests on Column Values
- @IF Functions
- Functions: Working with Strings and Numbers
- @STRCAT Function
- STREXT Function
- Other Functions
- Overview of SQLEXEC
- SQLEXEC: Basic Functionality
- SQLEXEC: DBMS and Data Type Support
- SQLEXEC: Using with a LOOKUP Stored Procedure
- SQLEXEC: Using with a SQL Query
- SQLEXEC: Using within a TABLE or MAP Statement
- SQLEXEC: Using as a Stand-Alone Statement
Additional Transformation Topics
- Overview of Macros
- Creating Macros
- Invoking a Macros
- Reusing Parameter Sets
- Creating Macros Libraries
- Tracing Macro Expansion
- Overview of User Tokens
- Environmental Values Available to @ GETENV
- User Tokens Display
- Using User Tokens
- Viewing User Exits in Log dump
- Overview of User Exits
- Uses for User Exits
- User Exits: High-Level Processing Logic
- Implementing User Exits
- User Exit Parameters
- Sample User Exits
- Calling User Exits
- Overview of Oracle Sequences
Configuration Options Objectives
- Overview of BATCMSQL
- BATCHSQL Syntax
- BATCHSQL Results
- Compression Options
- Example: Of Compression
- Encryption Overview
- Message Encryption
- Options: Message Encryption
- Trial or Extract File Encryption
- Password Extract File Encryption Method 1
- Password Extract File Encryption Method 2
- Summary of Password
- Event Market System
- Uses for Event Actions
- Event Actions Flows Chart
- Implementing Event Actions
- Event Actions: Heartbeat Example
- Event Actions: Auto Mated Switchover Example
Bidirectional Replication
- Bidirectional Flowchart
- Capabilities of a Bidirectional Configuration
- Issues to Consider For a Bidirectional Configuration
- Preventing Data Looping
- Loop Detection Techniques
- Conflict Avoidance and Detection
- Conflict Detection by Filter
- Conflict Resolution
- Conflict Resolution: Example
- Conflict Resolution by Applying Net Differences
- Oracle Sequence Numbers
- Truncate Table Operations
DDL Replication
- Overview of DDL Replication
- DDL Replication Requirements and Restrictions
- Characteristics for DDL Replication
- DDL Scopes
- Using Unqualified Object Names
- DDL Parameter
- DDL String Substitution
- Error Handling
- DDL Options for Oracle
- Mapping Schemas
- Supporting DDL in an Active –Active Bidirectional Configuration
- Activating Oracle DDL Capture
Tuning and Troubleshooting
- Using Command Security
- Sample CMDSEZC Statements
- Managing Trail Files
- Handing TCP/IP Errors
- TCPERRS File
- Troubleshooting Oracle Golden Gate
- Oracle Golden Gate Monitor
- Obtaining Process Information through GGSCI
- Using the Error Log
- Process Reports
- Sample Extract Process Report
- Discard Files
- Using the System Logs