Curso Oracle 12c GoldenGate Advanced Configuration
24 HorasVisã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
Português/InglêsConteúdo Programatico
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
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
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
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
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)
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
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
- MAP Statement exceptions
- Creating and Populating Exception and Discard Tables
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
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
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