Overview

Oracle GoldenGate (OGG) OverviewDescribe OGG functional overview and common topologiesDescribe OGG Veridata and Management Pack functionalityDescribe the difference between real-time data integration replication and Data Manipulation Language (DML) replicationArchitecture OverviewDescribe OGG componentsCreate the two types of Capture processes for Oracle databaseCreate the three types of Replicat processesExplain the difference between an Extract and Pump, and local and remote trailsConfigure OGG's process recovery mechanismInstall and Configure OGGDownload and Install OGG, and differentiate between various installers (zip, OUI, tar)Synchronize source and target databases with the Initial LoadPrepare database for OGG CDC and check databases with OGG schema check scriptConfigure OGG Replication component parameter filesConfigure the OGG Command Interface to create OGG processesDescribe how to identify and resolve issues in heterogeneous replication, and provide appropriate solutionsConfigure OGG utilitiesParametersDescribe and compare GLOBALS versus MANAGER parametersCreate solutions using component parameters for replication requirementsInstall OGG parametersExplain and identify parameters specific for non-Oracle databasesMapping and Transformation OverviewImplement use cases for transformation functionsImplement macrosConfiguration OptionsDescribe OGG configuration options (Data Definition Language (DDL), compression and encryption options)Configure OGG event actions based on use casesTroubleshoot conflict detection and resolutionConfigure Integrated Capture, Replicat, and deployment optionsManaging and Monitoring Oracle GoldenGateManage OGG command and data securityImplement and troubleshoot OGG MonitoringExplain the configuration and management of the Enterprise Manager 12c plug-inImplement and troubleshoot OGG Veridata

Skills

Reviews