Golden Gate
- What will you learn
- Audience
- Course Topic
- Course Objective
Introduction
Objectives
- Oracle Golden Gate 11g
- Key Capabilities and Technology Differentiators
- Value Propositions for Oracle Golden Gate
- Oracle Golden Gate Topologies
- Oracle Middleware for Business Intelligence
- Oracle Data Integrator EE and 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 Migration and Application Upgrade
- Oracle Golden Gate for Oracle Database: Eliminate Down Time During Oracle
- Database Upgrades
- Oracle Golden Gate for Oracle Database: Eliminate Unplanned Down Time with Active Data Guard
- Oracle Golden Gate for Oracle Database
- Improve Production System Performance and Lower Costs
- Oracle Golden Gate for Oracle Database: Offload Redo Logs
- Oracle Golden Gate for Operational Reporting
- Oracle GG for Oracle Database: Increase ROI on Existing Servers and Synchronize Global Data
Technology Overview
Objectives • Roadmap • Oracle Golden Gate: Modular Building Blocks • Roadmap • Supported Databases • Supported Operating Systems • Roadmap • Oracle GoldenGate Product Line • Oracle Golden Gate Veridata • Oracle Golden Gate Director: Overview • Oracle Golden Gate Director • Oracle Golden Gate Monitor: Overview • Oracle Golden Gate Monitor • Enterprise Manager Cloud Control 12c • 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 • Roadmap • Uses of Oracle GoldenGate • Oracle GoldenGate Components • Oracle GoldenGate Logical Architecture • Oracle GoldenGate Process Groups • Process-Group Naming Convention • GGSCI • Parameter Files Roadmap • Change Data Capture (Extract) and Delivery • Change Data Capture (Extract) and Delivery Using a Data Pump • Extract Flavors • Distributed Topologies for Integrated Extract: Same Machine • Distributed Topologies for Integrated Extract: Different Machine, Real-Time Non-Real-Time • Supported Features Based on Source DB Version • Roadmap • Online Versus Batch Operation • Running an Initial Load • Checkpoints: Capture • Checkpoints: Pump • Checkpoints: Delivery • Commit Sequence Number (CSN)
Installing Oracle Golden Gate
Objectives • Roadmap • 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 Examples • Obey Files • New Oracle Golden Gate 11gR1 GGSCI Miscellaneous Commands • Running Oracle Golden Gate from the OS Shell
Configuration Overview and Preparing the Environment
Objectives • Configuring Oracle Golden Gate • Character Set: National Language Support (NLS) • Mixed-Case Object Names: ‘Single’ and “Double” Quotes • Configuring Oracle Golden Gate • Preparing the Environment: Oracle Database • Using Command Security • Sample CMDSEC Statements • Handling TCP/IP Errors • tcperrs File • Roadmap • TranData Command • 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 Definition • Preparing the Environment: Running defgen
Configuring Change Capture
Objectives • Step 2: Change Capture • Extract Overview • Data Pump Overview • Data Pumps: One-to-Many Trails • Data Pumps: One-to-Many Target Systems • Setting Up Change Capture (Extract) • 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 • ASM and DBLogReader • Practice 6 Overview: Configuring Change Capture
Configuring Change Delivery
Objectives • Step 4: Change Delivery (Replicate) Replicate Overview • Change Delivery Tasks • Check point Table • Sample Configuration • Avoiding Collisions with Initial Load • Handling Collisions with Initial Load • Obtaining Process Information Through GGSCI • Process Report Files • Sample Extract Process Report • Discard Files • Using the ggserr.log Error Log • Using the System Logs
Extract Trail and Files
Objectives • Overview of Extract Trails and Files • Extract Trails and Files Distribution • Extract Trails and Files Contents • Extract Trails and Files Cleanup • Trail Format • Record Header Area Record Data Area • Setting the Compatibility Level • Alternative Trail Formats • Format ASCII • Format ASCII Sample Output • Format SQL • Format SQL Sample Output • Format XML • Format XML 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 • Overall Process of the reverse Utility • reverse: Overall Process • Sample Parameter Files
Configuring the Initial Load
Objectives • Step 3: Initial Load • 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) • Practice 9 Overview: Configuring the Initial Load
Oracle Golden Gate Parameters
Objectives • Roadmap • Oracle Golden Gate Parameter Files • Using Parameter Files • GLOBALS versus Process Parameters • GLOBALS Parameters • Roadmap • Manager Parameters: Overview • Sample Manager Parameter File • Manager Parameter Categories • Managing Trail Files • Extract Parameter Overview • Extract Parameter Defaults • Sample Extract Parameter File • Extract Parameter Categories • Extract Example: Table Parameter • Extract Example: Tran Log Options Parameter • Replicat Parameter: Overview • Replicat Parameter Defaults • Sample Replicat Parameter File • Replicat Parameter Categories • Replicat Example: Map Parameter • DBOptions
Data Selection and Filtering
Objectives • Data Mapping and Manipulation: Overview • 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 Examples • Column Mapping: Overview • Column Mapping: Example • Column Mapping: Building History • Data Transformation Using Functions • Functions: Performing Tests on Column Values • @IF Function • Functions: Working with Dates • @Date Function • Functions: Working with Strings and Numbers • @StrCat Function • @StrExt Function • Other Functions • SQLEXEC: Overview • SQLEXEC: Basic Functionality • SQLEXEC: DBMS and Data Type Support • SQLEXEC: Usage with a LOOKUP Stored Procedure • SQLEXEC: Usage with a SQL Query • SQLEXEC: Usage in a Table or Map Statement • SQLEXEC: Usage as a Stand-Alone Statement
Additional Transformation Topics
Objectives • Macros: Overview • Creating Macros • Invoking a Macro • Reusing Parameter Sets • Creating Macro Libraries • Tracing Macro Expansion • User Tokens: Overview • Environmental Values Available to @GETENV • Unauthorized reproduction or distribution prohibited • User Tokens Display • Using User Tokens • Viewing User Tokens in Log dump • User Exits: Overview • Uses for User Exits • User Exits: High-Level Processing Logic • Implementing User Exits • User Exit Parameters • Sample User Exits • Calling User Exits • Oracle Sequences: Overview • Practice 12 Overview: Data Transformation
Configuration Options
Objectives • Roadmap • BatchSQL: Overview • BatchSQL Syntax • BatchSQL Results • Compression Options • Example of Compression • Compression and Ex adata • Encryption: Overview • Message Encryption • Options: Message Encryption • Trail or Extract File Encryption • Password Encryption: Method • Event Marker System • Uses for Event Actions • Event Actions Flowchart • Event Actions Order • Unauthorized reproduction or distribution prohibited • Event Actions: Heartbeat • Event Actions: Automated Switchover • Event Actions: Automated Synchronization
Bidirectional Replication
Objectives • Roadmap • Bidirectional Flowchart • Capabilities of a Bidirectional Configuration • Bidirectional Configuration Considerations • Preventing Data Looping • Loop Detection Techniques • Conflict Avoidance and Detection and Resolution • Conflict Detection by CompareCols • GetUpdateBefores, GetBeforeCols, CompareCols, and ResolveConflict • Conflict Detection by Filter • Conflict Resolution • Conflict Resolution: Example • Conflict Resolution by Applying Net Differences • Resolve Conflict Built-in Methods • Conflict Resolution Custom Methods • Oracle Sequence Numbers • Truncate Table Operations • Overview: Configuring Bidirectional Replication
DDL Replication
Objectives • Overview of DDL Replication • DDL Replication Requirements and Restrictions • Characteristics for DDL Replication • DDL Scopes • Using Unqualified Object Names • DDL Parameter • DDL String Substitution • DDL Error Handling • DDLOptions for Oracle • Mapping Schemas • Supporting DDL in an Active-Active Bidirectional Configuration • Activating Oracle DDL Capture
- Any Graduates(B.A,B.Com,B.Sc)
- Engineering Students(B.Tech, B.E, M.Tech)
- BCA,MCA
- Any Diploma Holder
- Any Working Professionals
- Data Warehouse Administrators
- Database Administrators
- Software Tester
- Project Manager
- MIS Support
Oracle GoldenGate Integrated Capture/integrated Delivery
- What is Oracle GoldenGate Integrated Capture?
- Why it is Needed and What Additional Replication Features it Makes Possible
- How to Prepare a Database for Integrated Capture – Creation of Users, Assignments of Roles and Privileges, etc
- Oracle GoldenGate Integrated Capture Deployment Modes
- Integrated Replicat/Apply Architecture
- Integrated Replicat: How it works
- Integrated Delivery in Detail
Oracle Goldengate With Oracle Real Application Clusters Configuration
- Oracle RAC, Oracle GoldenGate and Business Continuity
- Oracle GoldenGate Used in Combination with Oracle RAC
- Oracle GoldenGate and the Oracle Database File System (DBFS)
- Oracle DBFS and Oracle Clusterware
- Configuring Oracle GoldenGate using the DBFS file systems
Oracle GoldenGate Event Marker System
- Starting, Suspending, Stopping Processes, Performing a Transformation, Reporting Statistics, and Capturing Lag History Using the Event Marker System
- Invoking Stored Procedures When Specific Events Occur Using SQLEXEC
- Activating Tracing Following the Exceeding of a Data Threshold
- Running OS Shell Commands at the Occurrence of Specific Data-Driven Events
- Extracting Details Analysis of the TABLE, MAP, FILTER, WHERE and SQLEXEC Statements
- Implementing Event Marker Actions on the Extraction Side and on the Delivery Side of Replication
Data Mapping, Data Selection/Filtering and Data Transformation
- TABLE (for Extract) and MAP (for Replicat) Options Which Allow for Data Selection
- COLMAP and COLMATCH Options
- Exploring Simple Filtering (Achieved Through the WHERE Clause) and Complex Filtering (Using the FILTER Clause)
- Data Transformation Functions: Enabling Concatenation, Substitution, Case Changing, Numeric Conversion and Date Conversion
- SQLEXEC Parameter to Invoke Stored Procedures or to Perform Native SQL Queries
Familiarize the student with Data Conflict Avoidance Techniques
- Set up and manage advanced deployment models, such as 3-node multi master replication configurations
- Integrate Oracle GoldenGate with Oracle cluster configurations
- Explain Oracle GoldenGate Advanced Configuration options
- Describe and take advantage of the Integrated Capture feature to extract complex data types and compressed data
- Introduce the new Integrate Replicat feature for improved data delivery
- Configure and implement the Oracle GoldenGate Event Marker system, to enable data transformation based on event records in the transaction logs or in the trail files
- Master Oracle GoldenGate facilities to detect and resolve data conflicts in active-to-active replication implementations
- Perform zero-downtime database migration