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
- 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
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
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