Informatique

Formation Oracle – Oracle GoldenGate 12c: Advanced Configuration for Oracle

Explain Oracle GoldenGate advanced configuration options.
Describe and take advantage of the Integrated Capture feature and the recently introduced Integrated Replicat 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 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.
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.

D’un ou de plusieurs membres de votre équipe, bénéficiez d’un devis personnalisé pour améliorer les compétences de vos collaborateurs.

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

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

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

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)

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

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 and DELETEROWMISSING Clauses to Identify Source of Conflict Errors

Increasing Troubleshooting Information Captured in Error and Discard Tables Using Oracle GoldenGate Facilities

Informatique

Si vous êtes une entreprise ou un particulier, vous pouvez demander un devis en cliquant sur le bouton ci-dessous.

Formations