Oracle GoldenGate 12c: Advanced Configuration for Oracle | IT Training & Certification | Info Trek
Respect Your Dreams
Follow through on your goals with courses

Oracle GoldenGate 12c: Advanced Configuration for Oracle

Location

Format What’s this?
  1. 4 Days
  1. All of our private classes are customized to your organization's needs.
  2. Click on the button below to send us your details and you will be contacted shortly.

Oracle GoldenGate 12c: Advanced Configuration for Oracle

WHAT YOU WILL LEARN

Enrolling in this Oracle GoldenGate 12c training will help you develop your installation and configuration skills. By interacting with top Oracle Instructors, you will be able to ask questions as you learn to solidify your understanding.

Learn To:

  • Explain Oracle GoldenGate advanced configuration options
  • Describe and take advantage of the Integrated Capture feature and the recently introduced Integrated Replicate feature to replicate complex data types and compressed data
  • Integrate the Database File System (DBFS) with Oracle GoldenGate to achieve Maximum Availability
  • Configure and implement the Oracle GoldenGate Event market system
  • Enable data transformation based on event records in the transaction logs or in the trail files
  • Perform zero-downtime database migration
  • Set up and manage advanced deployment models, like 3-node multi master replication configuration
  • Master Oracle GoldenGate facilities to detect and resolve data conflicts in active-to-active replication implementations
  • Use a simulated Oracle RAC configuration to experiment with the Oracle GoldenGate Clusterware-aware facilities, which ensure seamless data replication in case of node failure

AUDIENCE

  • Architect
  • Data Scientist
  • Data Warehouse Administrator
  • Database Administrators
  • Database Designers
  • Process Developer
  • System Integrator

PREREQUISITES

Before attending this course, students must have:

  • Oracle GoldenGate 12c: Fundamentals for Oracle

METHODOLOGY

This program will be conducted with interactive lectures, PowerPoint presentations, discussions and practical exercises

COURSE OBJECTIVES

Upon completion of this program, participants should be able to :

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

Expand All

Modules

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 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
Custom Behavior Through User Exits
  • The CUSEREXIT Parameter and its Options
  • User Exit Mandatory Parameters: EXIT_CALL_TYPE, EXIT_CALL_RESULT and EXIT_PARAMS
  • The EXIT_CALL_PROCESS_RECORD Function
  • Oracle GoldenGate Callback Routines Invoked Through ERCALLBACK
  • The usrdecs.h "C" Include File
  • JMS and Flat File Using Oracle GoldenGate Application Adapters
  • Connecting to the Java Subsystem Through the Java Native Interface (JNI)
Configuring Zero-Downtime Migration Replication
  • Zero-Downtime Migration Prerequisites
  • Zero-Downtime Migration Topology
  • Configuring Initial Setup and Required Steps
  • Configuring Primary Extract, Data pump and Replicat for Fallback
  • Simulating fallback
Bidirectional Replication: Two-Node Configuration
  • Bi-Directional Replication
  • Data Conflict Types
  • Getting Before Image Information from Source Database
  • Using RESOLVECONFLICT
  • Handling UPDATEROWEXISTS in Conjunction with USEDELTA, USEMAX, and IGNORE
  • Exceptions MAP Statement
  • Creating and Populating Exception and Discard Tables
Conflict Detection and Resolution – Custom Techniques
  • Workload Partitioning
  • Geographic or Topic-Based Segmentation
  • Primary Key Generation
  • Custom Conflict Resolution Techniques: Quantitative Methods for Conflict Resolution and Data Convergence
  • Automatic Conflict Resolution Based on Time stamp or Trusted Source
  • Automatic Data Convergence of Numeric Values Based on Additive Value or Average Value
Multi-Master Replication Topology – Three-Node Configuration
  • Handling Multi-Master Configurations: Additional Limitations Compared to Active-Active
  • Dealing with the Lack of Support for DDL Replication
  • Data Convergence and Latency in a Multi-Master Topology
  • Decreasing Complexity by Enabling Segmentation and Node-Based Partitioning in the Application
  • Minimizing Data Conflict by Minimizing Latency
  • Resolving Simple Conflicts Using RESOLVECONFLICT with USEMIN, USEMAX and USEDELTA
  • Combining RESOLVECONFLICT with UPDATEROWEXISTS, INSERTROWEXISTS, DELETEROWEXISTS, UPDATEROWMISSING Increasing Troubleshooting Information Captured in Error and Discard Tables Using Oracle GoldenGate Facilities
Active Data Guard and Oracle GoldenGate. How to achieve Maximum Availability
  • Data Guard Fast Start Fail Over (FSFO)
  • Role Transition Complexity – Oracle GoldenGate to the Rescue
  • Oracle Bundled Agent (XAG)
  • Oracle Bundled Agent – The Key to Maximum Availability
Oracle Certified Trainer

Oracle Certified Trainer

Read More

Course Reviews

No Remarks

0

0 Ratings