Visão Geral

EsteCurso Oracle 12c GoldenGate Advanced Configuration, irá equipá-lo com as habilidades necessárias para instalação e configuração. Ao interagir com os melhores instrutores Oracle, você poderá fazer perguntas enquanto aprende a consolidar seu conhecimento.

Objetivo

Após realizar este curso Oracle, você será capaz de:

• Familiarize o aluno com as técnicas de prevenção de conflitos de dados
  
• Configure e gerencie modelos de implantação avançados, como configurações de replicação de vários mestres de 3 nós
• Integre o Oracle GoldenGate com configurações de cluster Oracle
• Explique as opções de configuração avançada do Oracle GoldenGate
• Descreva e aproveite o recurso de captura integrada para extrair tipos de dados complexos e dados compactados
• Apresentar o novo recurso Integrate Replicat para entrega de dados aprimorada
• Configure e implemente o sistema Oracle GoldenGate Event Marker, para permitir a transformação de dados com base em registros de eventos nos logs de transações ou nos arquivos de trilha
• Recursos mestre do Oracle GoldenGate para detectar e resolver conflitos de dados em implementações de replicação ativo-para-ativo
• Realizar migração de banco de dados com tempo de inatividade zero

Publico Alvo

Este Curso Oracle 12c GoldenGate Advanced Configuration, destina-se a administradores de banco de dados, gerentes de configuração de sistema, administradores de data warehouse e designers de banco de dados.

Informações Gerais

• Carga horaria, 24h
• Se noturno este curso e ministrado de segunda-feira a sexta-feira das 19h às 23h, total de 6 noites,
• Se aos sábados este curso e ministrado das 09h às 18h, total de 3 sábados,
• Se in-company, este curso pode ser ministrado de acordo com as agendas de ambas as partes.

 Formato de entrega

• On-line ao vivo via Microsoft Teams na presença de um instrutor/consultor Oracle, atuando ativamente com consultoria, implementação, suporte, sustentação, treinamentos workshop,

 LAB Oracle:

• Todo aluno participante tem acesso ao um laboratório Oracle para a pratica dos exercícios proposto pelo curso em sala de aula, auxiliado por um instrutor 

Materiais

Conteúdo Programatico

Oracle GoldenGate Integrated Capture / integrated Delivery

1. What is Oracle GoldenGate Integrated Capture?
2. Why it is Needed and What Additional Replication Features it Makes Possible
3. How to Prepare a Database for Integrated Capture - Creation of Users, Assignments of Roles and Privileges, etc
4. Oracle GoldenGate Integrated Capture Deployment Modes
5. Integrated Replicat / Apply Architecture
6. Integrated Replicat: How it works
7. Integrated Delivery in Detail

Oracle Goldengate With Oracle Real Application Clusters Configuration

1. Oracle RAC, Oracle GoldenGate and Business Continuity
2. Oracle GoldenGate Used in Combination with Oracle RAC
3. Oracle GoldenGate and the Oracle Database File System (DBFS)
4. Oracle DBFS and Oracle Clusterware
5. Configuring Oracle GoldenGate using the DBFS file systems

Oracle GoldenGate Event Marker System

1. Starting, Suspending, Stopping Processes, Performing a Transformation, Reporting Statistics, and Capturing Lag History Using the Event Marker System
2. Invoking Stored Procedures When Specific Events Occur Using SQLEXEC
3. Activating Tracing Following the Exceeding of a Data Threshold
4. Running OS Shell Commands at the Occurrence of Specific Data-Driven Events
5. Extracting Details Analysis of the TABLE, MAP, FILTER, WHERE and SQLEXEC Statements
6. Implementing Event Marker Actions on the Extraction Side and on the Delivery Side of Replication

Data Mapping, Data Selection / Filtering and Data Transformation

1. TABLE (for Extract) and MAP (for Replicat) Options Which Allow for Data Selection
2. COLMAP and COLMATCH Options
3. Exploring Simple Filtering (Achieved Through the WHERE Clause) and Complex Filtering (Using the FILTER Clause)
4. Data Transformation Functions: Enabling Concatenation, Substitution, Case Changing, Numeric Conversion and Date Conversion
5. SQLEXEC Parameter to Invoke Stored Procedures or to Perform Native SQL Queries

Custom Behavior Through User Exits

1. The CUSEREXIT Parameter and its Options
2. User Exit Mandatory Parameters: EXIT_CALL_TYPE, EXIT_CALL_RESULT and EXIT_PARAMS
3. The EXIT_CALL_PROCESS_RECORD Function
4. Oracle GoldenGate Callback Routines Invoked Through ERCALLBACK
5. The usrdecs.h "C" Include File
6. JMS and Flat File Using Oracle GoldenGate Application Adapters
7. Connecting to the Java Subsystem Through the Java Native Interface (JNI)

Configuring Zero-Downtime Migration Replication

1. Zero-Downtime Migration Prerequisites
2. Zero-Downtime Migration Topology
3. Configuring Initial Setup and Required Steps
4. Configuring Primary Extract, Data pump and Replicat for Fallback
5. Simulating fallback

Bidirectional Replication: Two-Node Configuration

1. Bi-Directional Replication
2. Data Conflict Types
3. Getting Before Image Information from Source Database
4. Using RESOLVECONFLICT
5. Handling UPDATEROWEXISTS in Conjunction with USEDELTA, USEMAX, and IGNORE
6. MAP Statement exceptions
7. Creating and Populating Exception and Discard Tables

Conflict Detection and Resolution - Custom Techniques

1. Workload Partitioning
2. Geographic or Topic-Based Segmentation
3. Primary Key Generation
4. Custom Conflict Resolution Techniques: Quantitative Methods for Conflict Resolution and Data Convergence
5. Automatic Conflict Resolution Based on Time stamp or Trusted Source
6. Automatic Data Convergence of Numeric Values ​​Based on Additive Value or Average Value

Multi-Master Replication Topology - Three-Node Configuration

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

Active Data Guard and Oracle GoldenGate. How to achieve Maximum Availability

1. Data Guard Fast Start Fail Over (FSFO)
2. Role Transition Complexity - Oracle GoldenGate to the Rescue
3. Oracle Bundled Agent (XAG)
4. Oracle Bundled Agent - The Key to Maximum Availability