Курс: Oracle GoldenGate 11g: Advanced Configuration for Oracle

Продолжительность курса: 32 ак. ч.

Формат обучения:
• Очно - на территории нашего учебного центра или на территории Заказчика (для корпоративных клиентов)
• Онлайн обучение с помощью вебинаров в режиме "здесь и сейчас"
• Дистанционно с помощью системы СДО в любое удобное для вас время

Описание курса:
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. 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. Integrate your organization's disparate data across heterogeneous databases for improved decision-making. Become more efficient at configuring and implementing Oracle GoldenGate. 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. 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.

Аудитория:
• Database Administrators
• Database Designers
• Architect
• System Integrator
• Process Developer
• Data Warehouse Administrator

Необходимая подготовка:
• Knowledge of Oracle Golden Gate version 11.2.1.

Результат обучения:
После изучения курса слушатель будет уметь:
• 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

Программа курса:
Модуль 1. Oracle GoldenGate Integrated Capture
• How to Prepare a Database for Integrated Capture – Creation of Users, Assignments of Roles and Privileges, etc
• Configuring an Extract Process to Perform Change Data Capture Using Integrated Capture
• Oracle GoldenGate Integrated Capture Deployment Modes
• Comparing and Contrasting Classic Capture vs. Integrated Capture
• Why it is Needed and What Additional Replication Features it Makes Possible
• What is Oracle GoldenGate Integrated Capture?
• Extracting Parameters Relevant to Integrated Capture

Модуль 2. Oracle GoldenGate 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
• Starting, Suspending, Stopping Processes, performing a Transformation, Reporting Statistics, and Capturing Lag History Using the Event Marker System
• 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

Модуль 3. Data Mapping, Data Selection/Filtering and Data Transformation
• COLMAP and COLMATCH Options
• 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)
• SQLEXEC Parameter to Invoke Stored Procedures or to Perform Native SQL Queries

Модуль 4. Custom Behavior Through User Exits
• The CUSEREXIT Parameter and its Options
• Connecting to the Java Subsystem Through the Java Native Interface (JNI)
• JMS and Flat File Using Oracle GoldenGate Application Adapters
• Oracle GoldenGate Callback Routines Invoked Through ERCALLBACK
• User Exit Mandatory Parameters: EXIT_CALL_TYPE, EXIT_CALL_RESULT and EXIT_PARAMS
• The usrdecs.h “C” Include File
• The EXIT_CALL_PROCESS_RECORD Function

Модуль 5. Configuring Zero-Downtime Migration Replication
• Configuring Initial Setup and Required Steps
• Zero-Downtime Migration Topology
• Configuring Primary Extract, Data pump and Replicat for Fallback
• Zero-Downtime Migration Prerequisites

Модуль 6. Bidirectional Replication: Two-Node Configuration
• Creating and Populating Exception and Discard Tables
• Exceptions MAP Statement
• Data Conflict Types
• Handling UPDATEROWEXISTS in Conjunction with USEDELTA, USEMAX, and IGNORE
• Bi-Directional Replication
• Getting Before Image Information from Source Database
• Multi-Master Replication
• Using RESOLVECONFLICT

Модуль 7. Conflict Detection and Resolution – Custom Techniques
• Workload Partitioning
• Custom Conflict Resolution Techniques: Quantitative Methods for Conflict Resolution and Data Convergence
• Primary Key Generation
• Automatic Data Convergence of Numeric Values Based on Additive Value or Average Value
• Automatic Conflict Resolution Based on Time stamp or Trusted Source
• Geographic or Topic-Based Segmentation

Модуль 8. Multi-Master Replication Topology – Three-Node Configuration
• Handling Multi-Master Configurations: Additional Limitations Compared to Active-Active
• Resolving Simple Conflicts Using RESOLVECONFLICT with USEMIN, USEMAX and USEDELTA
• Increasing Troubleshooting Information Captured in Error and Discard Tables Using Oracle GoldenGate Facilities
• Minimizing Data Conflict by Minimizing Latency
• Dealing with the Lack of Support for DDL Replication
• Data Convergence and Latency in a Multi-Master Topology
• Combining RESOLVECONFLICT with UPDATEROWEXISTS, INSERTROWEXISTS, DELETEROWEXISTS, UPDATEROWMISSING and DELETEROWMISSING Clauses to Identify Source of Conflict Errors
• Decreasing Complexity by Enabling Segmentation and Node-Based Partitioning in the Application

Модуль 9. Administering a Multi-Master Configuration
• Adding Process Groups to Active Configurations
• Reinitializing the Transaction Log
• Performing Administrative Operations on a Multi-Master Replication Environment
• Changing Database Attributes