Oracle GoldenGate 12c: Advanced Configuration for Oracle Training Logo

Oracle GoldenGate 12c: Advanced Configuration for Oracle Training

Live Online & Classroom Enterprise Certification Training

Powered By

Oracle Logo

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

ATP_Authorized Logo

Powered By

Oracle Logo

Looking for a private batch ?

REQUEST A CALLBACK

Need help finding the right training?

Your Message

  • Certified Trainer

  • Authorized Courseware

  • Completion Certificate from ATP

  • Enterprise Reporting

  • Lifetime Access

  • CloudLabs

  • 24x7 Support

  • Real-time code analysis and feedback

What is 12c: Advanced Configuration for Oracle Certification Training about?

Enrolling in this Oracle GoldenGate 12c 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.

upon completing this course, you'll be able to utilize the more advanced features of Oracle GoldenGate 12c, including: integrated capture, integrated delivery, 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. In addition, you will 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.

What are the objectives of 12c: Advanced Configuration for Oracle Certification Training ?

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

Who is 12c: Advanced Configuration for Oracle Certification Training for?

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

What are the prerequisites for 12c: Advanced Configuration for Oracle Certification Training?

Suggested Prerequisite

  • Oracle GoldenGate 12c: Fundamentals for Oracle

Required Prerequisite

  • Oracle GoldenGate 12c: Fundamentals for Oracle
  • Oracle GoldenGate 12c: Troubleshooting and Tuning

Available Training Modes

Live Online Training

32 Hours

Classroom Training

4 Days

Course Outline Expand All

Expand All

  • 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
  • Integrated Replicat: How it works
  • Integrated Replicat/Apply Architecture
  • What is Oracle GoldenGate Integrated Capture?
  • Oracle GoldenGate Integrated Capture Deployment Modes
  • Integrated Delivery in Detail
  • Oracle GoldenGate and the Oracle Database File System (DBFS)
  • Oracle GoldenGate Used in Combination with Oracle RAC
  • Oracle DBFS and Oracle Clusterware
  • Configuring Oracle GoldenGate using the DBFS file systems
  • Oracle RAC, Oracle GoldenGate and Business Continuity
  • Activating Tracing Following the Exceeding of a Data Threshold
  • Extracting Details Analysis of the TABLE, MAP, FILTER, WHERE and SQLEXEC Statements
  • Invoking Stored Procedures When Specific Events Occur Using SQLEXEC
  • Starting, Suspending, Stopping Processes, Performing a Transformation, Reporting Statistics, and Capturing Lag History Using the Event Marker System
  • Implementing Event Marker Actions on the Extraction Side and on the Delivery Side of Replication
  • Running OS Shell Commands at the Occurrence of Specific Data-Driven Events
  • Data Transformation Functions: Enabling Concatenation, Substitution, Case Changing, Numeric Conversion and Date Conversion
  • TABLE (for Extract) and MAP (for Replicat) Options Which Allow for Data Selection
  • Exploring Simple Filtering (Achieved Through the WHERE Clause) and Complex Filtering (Using the FILTER Clause)
  • COLMAP and COLMATCH Options
  • SQLEXEC Parameter to Invoke Stored Procedures or to Perform Native SQL Queries
  • The EXIT_CALL_PROCESS_RECORD Function
  • JMS and Flat File Using Oracle GoldenGate Application Adapters
  • User Exit Mandatory Parameters: EXIT_CALL_TYPE, EXIT_CALL_RESULT and EXIT_PARAMS
  • The CUSEREXIT Parameter and its Options
  • Connecting to the Java Subsystem Through the Java Native Interface (JNI)
  • The usrdecs.h C Include File
  • Oracle GoldenGate Callback Routines Invoked Through ERCALLBACK
  • Configuring Primary Extract, Data pump and Replicat for Fallback
  • Simulating fallback
  • Zero-Downtime Migration Topology
  • Configuring Initial Setup and Required Steps
  • Zero-Downtime Migration Prerequisites
  • Exceptions MAP Statement
  • Using RESOLVECONFLICT
  • Bi-Directional Replication
  • Creating and Populating Exception and Discard Tables
  • Getting Before Image Information from Source Database
  • Data Conflict Types
  • Handling UPDATEROWEXISTS in Conjunction with USEDELTA, USEMAX, and IGNORE
  • Workload Partitioning
  • Geographic or Topic-Based Segmentation
  • Custom Conflict Resolution Techniques: Quantitative Methods for Conflict Resolution and Data Convergence
  • Automatic Data Convergence of Numeric Values Based on Additive Value or Average Value
  • Automatic Conflict Resolution Based on Time stamp or Trusted Source
  • Primary Key Generation
  • Resolving Simple Conflicts Using RESOLVECONFLICT with USEMIN, USEMAX and USEDELTA
  • Increasing Troubleshooting Information Captured in Error and Discard Tables Using Oracle GoldenGate Facilities
  • Dealing with the Lack of Support for DDL Replication
  • Handling Multi-Master Configurations: Additional Limitations Compared to Active-Active
  • Combining RESOLVECONFLICT with UPDATEROWEXISTS, INSERTROWEXISTS, DELETEROWEXISTS, UPDATEROWMISSING and DELETEROWMISSING Clauses to Identify Source of Conflict Errors
  • Data Convergence and Latency in a Multi-Master Topology
  • Minimizing Data Conflict by Minimizing Latency
  • Decreasing Complexity by Enabling Segmentation and Node-Based Partitioning in the Application
  • Data Guard Fast Start Fail Over (FSFO)
  • Oracle Bundled Agent (XAG)
  • Oracle Bundled Agent – The Key to Maximum Availability
  • Role Transition Complexity – Oracle GoldenGate to the Rescue

Who is the instructor for this training?

The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

Course Logo

12c: Advanced Configuration for Oracle Certification Training - Certification & Exam

  • SpringPeople is the Authorized Training Partner of Oracle.
  • The training fees is exclusive of exam cost.
  • For any queries; feel free to reach us at oracle@springpeople.com

Reviews