Duration: 4 Days
What you will learn
Enrolling in this Oracle GoldenGate 11g training will help you develop your installation and configuration skills. By
interacting with top Oracle instructors, you’ll 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 new Integrated Capture to replicate complex data types and compressed data.
Configure and implement the Oracle GoldenGate Event Marker 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.
Benefits to You
Integrate your organization’s disparate data across heterogeneous databases for improved decision-making. Become
more efficient at configuring and implementing Oracle GoldenGate.
Enable Zero-Downtime Migration
This course also allows you to simulate a system upgrade. You’ll develop the skills needed to survive an aborted
migration, incurring zero data loss. Hone these skills by engaging in hands-on demonstrations and exercises.
Active-Active Replication and CDR
You’ll also build two-way and three-way active-active replication configurations. Explore both basic and advanced
conflict detection and resolution (CDR). Review basic product-provided CDR, with more advanced custom CDR
techniques implemented using SQLEXEC and stored procedures.
Configure Integrated Extract Groups
The recently introduced Integrated Extract feature is also covered in depth. You’ll learn to configure integrated extract
groups operating in both local and downstream deployment modes.
Learn to Utilize Advanced Features
Upon completing this course, you’ll be able to utilize the more advanced features of Oracle GoldenGate 11g, including: integrated capture, active-active replication, conflict detection and resolution, DDL/DML replication, Oracle GoldenGate
event marker subsystem, advanced data manipulation and transformation techniques and advanced data mapping.
Audience
Architect
Data Warehouse Administrator
Database Administrators
Database Designers
Process Developer
System Integrator
Related Training
Required Prerequisites
Oracle GoldenGate 11g: Fundamentals for Oracle
Suggested Prerequisites
Oracle Database 11g : DBA en deux jours Edition 2
Oracle Database 11g: 2 Day DBA Release 2
Oracle Database 11g: Administration Workshop I Release 2 NOUVEAU- Français
Oracle Database 11g: Administration Workshop I Release 2
Course Objectives
Explain Oracle GoldenGate Advanced Configuration options
Describe and take advantage of the new Integrated Capture to replicate complex data types and compressed data,
currently unsupported by Classic Capture
Install and deploy Oracle GoldenGate Integrated Capture components
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
Course Topics
Oracle GoldenGate Integrated Capture
What is Oracle GoldenGate Integrated Capture?
Why it is Needed and What Additional Replication Features it Makes Possible
Comparing and Contrasting Classic Capture vs. Integrated Capture
How to Prepare a Database for Integrated Capture – Creation of Users, Assignments of Roles and Privileges, etc
Oracle GoldenGate Integrated Capture Deployment Modes
Configuring an Extract Process to Perform Change Data Capture Using Integrated Capture
Extracting Parameters Relevant to Integrated Capture
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 Conversio
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
Bidirectional Replication: Two-Node Configuration
Bi-Directional Replication
Multi-Master 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, UPDATEROWMIS
Increasing Troubleshooting Information Captured in Error and Discard Tables Using Oracle GoldenGate Facilities
Administering a Multi-Master Configuration
Adding Process Groups to Active Configurations
Changing Database Attributes
Performing Administrative Operations on a Multi-Master Replication Environment
Reinitializing the Transaction Log
Formateur
0.00 average based on 0 ratings