• support@conveytechlabs.com

Golden Gate

Duration
30 hrs
Type
online

This Oracle GoldenGate 12c training covers installing and configuring advanced features of the product, including active-active replication and conflict detection/resolution. Explore in more depth topics introduced in the fundamentals course, such as Event Marker and Advanced Data Transformation techniques. Implement 3-way, Multi-Master configurations and experiment with Oracle RAC, integrating Oracle GoldenGate with Oracle clusters. Configure Oracle GoldenGate replication in a Multi-tenant database supporting pluggable databases (PDBs.)

    • Duration: 35 – 40 hrs
    • Timings: Week days 1-2 Hours per day (or) Weekends: 2-3 Hours per day
    • Method: Online/Classroom Training
    • Study Material: Soft Copy
    Golden Gate Components
    • Supported Topologies
    • GoldenGate Components
    • Supported Source Databases
    • Supported Target Databases
    • Process Types
    • Commit Sequence Number
    • Replication Design Considerations
    • Loading with GoldenGate Options
    General Installation Requirements
    • Supported Databases
    • Memory Requirements
    • Disk Space Requirements
    • OS Requirements
    Installing GoldenGate Software 
    • Installing GoldenGate on Windows
    • Installing GoldenGate on Linux
    Uninstalling GoldenGate
    Preparing a Database for GoldenGate
    • Preparing Oracle Database for GoldenGate
    • Preparing SQL Server  Enterprise Edition for GoldenGate
    Setting up Basic Replication 
    • About Handling Collisions
    • Notes on Tables to Replicate in Oracle database
    • Replicate Database Connection Options in SQL Server
    • Configuring an ODBC connection to SQL Server
    • Processes Naming Convention
    • Tutorial: Basic Replication between two Oracle Databases
    Customizing GoldenGate Replication 
    • Managing the Process Report
    • Reporting Discarded Records
    • Purging Old Trail Files
    • Adding Automatic Process Startup and Restart
    • Adding a Checkpoint Table
    Securing the Replication
    • Encrypting Passwords
    • Encrypting the Trail Files
    Adding Data Filtering and Mapping
    • Filtering Tables, Columns and Rows
    • Mapping Different Objects
    Setting up Bi-directional Replication 
    • Bi-directional Replication Restrictions
    • Excluding Replicate Transactions
    • Handling conflicts using CDR feature
    • Handling Errors in CDR
    • Tutorial: Setting Up Bi-directional Replication between Oracle Databases
    Heterogeneous Replication
    • Tutorial: Oracle Database to SQL Server
    Performance Tuning in GoldenGate
    • Performance Tuning Methodology
    • Using Parallel Extracts and Replicates
    • Tutorial: Implementing Parallel Extracts and Replicates Using Table Filters
    • Tutorial: Implementing Parallel Extracts and Replicates Using Key Ranges
    • Using the Replicate Parameter BATCHSQL
    • Using the Replicate Parameter GROUPTRANSOPS
    • Tuning Network Performance Issues
    • More Oracle GoldenGate Tuning Tips
    Monitoring Oracle GoldenGate
    • Monitoring Strategy Targets
    • Monitoring Points
    • Automating the Monitoring
    Oracle GoldenGateVeridata
    • Oracle GoldenGateVeridata Components
    • Tutorial: Installing Oracle GoldenGateVeridata Server
    • Tutorial: Installing Oracle GoldenGateVeridata C-agent
    • Setting Up the Veridata Compares
    • Tutorial: Setting Up Basic Veridata Compares
    • Using Vericom Command Line
    • Setting Up Role-Based Security in Veridata
    Using Oracle GoldenGate Directory  
    • About Oracle GoldenGate Director
    • About Oracle GoldenGate Director Components
    • Tutorial: Installing Oracle GoldenGate Director on Windows
    • Tutorial: Adding a Data Source in Oracle GoldenGate Director
    • Tutorial: Using Oracle GoldenGate Director Client
    Troubleshooting Oracle GoldenGate
    • Troubleshooting Tools
    • Using Trace Commands with Oracle GoldenGate
    • Process Failures
    • Trail Files Issues
    • Discard File Issues
    • Oracle GoldenGate Configuration Issues
    • Operating System Related Issues
    • Network Configuration Issues in Oracle GoldenGate
    • Oracle Database Issues with GoldenGate
    • Data-Synchronization Issues
    Disaster Recovery Replication using GoldenGate
    • Considerations
    • Tutorial: Setting Up Disaster Recovery Replication
    Zero-Downtime Migration Replication  
    • Zero-Downtime Migration High Level Plan
    Using Oracle GoldenGate Guidelines  
    • Understanding the Requirements
    • Installation and Setup
    • Management and Monitoring
    • Tuning Performance
    • Career oriented training.
    • One to One live interaction with a trainer.
    • Demo project end to end explanation.
    • Interview guidence with resume preparation.
    • Support with the trainer through E-mail.