Oracle GoldenGate 12c: Advanced Configuration for Oracle Training

3896 Learners

Oracle GoldenGate12c: Advanced Configuration for Oracle training provides deeper understanding on the installation and configuration processes. The aspirants will learn the advanced features of Oracle GoldenGate used together with the Oracle RDBMS 12c. The guidance of expert mentor will enable the learners to develop the skills for integrating disparate data across heterogeneous databases, resulting into consolidated data and improved decision-making. In case of node failure, how to maintain data replication using Oracle GoldenGate Clusterware is also explained along with its benefits to the participants.

By the end of the Oracle GoldenGate 12c: Advanced Configuration for Oracle course, you will inculcate the following skills:

  • Elucidate Oracle GoldenGate Advanced Configuration options
  • Perform zero-downtime database migration
  • Work on Advanced Data Transformation techniques and Integrated Capture feature for the extraction and compression of complex data types
  • Implement two-way and three-way active-active replication configurations
  • Work on conflict detection and resolution (CDR) techniques
  • Improve data delivery by using the Integrate Replicat feature and  Integrated Extract Groups
  • Enable data transformation by configuring and implementing the Oracle GoldenGate Event Marker system
  • Integrate Oracle GoldenGate with Oracle cluster configurations
Target audience
  • Database Designers
  • Database Administrators
  • Data Warehouse Administrator
  • Process Developer
  • Architect
  • System Integrator
  • Data Scientist
Prerequisites

Oracle GoldenGate 12c: Fundamentals for Oracle

Oracle GoldenGate12c: Advanced Configuration for Oracle training provides deeper understanding on the installation and configuration processes. The aspirants will learn the advanced features of Oracle GoldenGate used together with the Oracle RDBMS 12c. The guidance of expert mentor will enable the learners to develop the skills for integrating disparate data across heterogeneous databases, resulting into consolidated data and improved decision-making. In case of node failure, how to maintain data replication using Oracle GoldenGate Clusterware is also explained along with its benefits to the participants.

By the end of the Oracle GoldenGate 12c: Advanced Configuration for Oracle course, you will inculcate the following skills:

  • Elucidate Oracle GoldenGate Advanced Configuration options
  • Perform zero-downtime database migration
  • Work on Advanced Data Transformation techniques and Integrated Capture feature for the extraction and compression of complex data types
  • Implement two-way and three-way active-active replication configurations
  • Work on conflict detection and resolution (CDR) techniques
  • Improve data delivery by using the Integrate Replicat feature and  Integrated Extract Groups
  • Enable data transformation by configuring and implementing the Oracle GoldenGate Event Marker system
  • Integrate Oracle GoldenGate with Oracle cluster configurations
Target audience
  • Database Designers
  • Database Administrators
  • Data Warehouse Administrator
  • Process Developer
  • Architect
  • System Integrator
  • Data Scientist
Prerequisites

Oracle GoldenGate 12c: Fundamentals for Oracle

Oracle GoldenGate 12c: Advanced Configuration for Oracle Training Course Content

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

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

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

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

5. 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)

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

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

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

9. 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 and DELETEROWMISSING Clauses to Identify Source of Conflict Errors
  • Increasing Troubleshooting Information Captured in Error and Discard Tables Using Oracle GoldenGate Facilities

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

Learning Partner

Drop Us a Query

+91 9810306956

Available 24x7 for your queries

Oracle GoldenGate 12c: Advanced Configuration for Oracle Training Course Certificate

Our Training Certificates Get The Job Done

Multisoft Systems is the “one-top learning platform” for everyone.

Get trained with certified industry experts and receive a globally-recognized training certificate.

Multisoft Training Certificate Features :
  • Globally recognized certificate with complete name of the candidate
  • Course ID & Course Name
  • Certificate with Date of Issuance
  • Name and Digital Signature of the Awardee
certificate-sample

Oracle GoldenGate 12c: Advanced Configuration for Oracle Corporate Training & Certification Prog

Employee training and development programs are essential to the success of businesses worldwide. With our best-in-class corporate trainings you can enhance employee productivity and increase efficiency of your organization. Created by global subject matter experts, we offer highest quality content that are tailored to match your company’s learning goals and budget.

Learn from the experts

Customized Training

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements of your workforce. You can even choose a trainer from our team of certified industry experts.

Learn from the experts

Expert Mentors

Get trained from our team of highly skilled and certified trainers, who are officially accredited professionals with relevant industry experience and adept in providing the knowledge and skills required to be successful.

Learn from the experts

360º Learning Solution

Engage your employees with our all-inclusive learning platform. Avail benefits of 24/7 access to the learning management system, industry-certified mentors, assessments & mock tests, real-time learning and more.

Learn from the experts

Learning Assessment

Check test score and performance with our skills analysis tools. Our detail scoreboard displays scores, areas of strength, detailed answer of questions and more for each employee.

Download Corporate Brochure

What Attendees are Saying

+

+91 9810306956

Available 24x7

Multisoft
Online

Multisoft
Hi there 👋

How can I help you?
1:40
×
Chat with Us