Oracle GoldenGate 12c : Fundamentals for Oracle - Formation Oracle


Oracle GoldenGate 12c : Fundamentals for Oracle

Prix: 2 844 €Durée: 4 joursCode de Réference: D84357 Catalogue
Print Friendly, PDF & Email

Cette formation Oracle GoldenGate 12c: Fundamentals for Oracle se concentre sur la réplication de bases de données Oracle vers Oracle. Vous découvrirez la suite de produits Oracle GoldenGate et les différentes fonctionnalités du produit. Oracle GoldenGate 12.3 pour Oracle introduit l'architecture Microservices, qui permet une interaction REST avec Oracle GoldenGate. Les architectures Classic et Microservices sont couvertes par le cours. Les élèves mettront en œuvre des environnements de réplication de bout en bout en utilisant les deux architectures, en testant les canaux de réplication établis avec des données réelles, afin de vérifier que la réplication est en cours.

Objectifs de la formation :

  • Configure, start, stop, and monitor Change Capture (Extract), Change Delivery (Replicat), and Initial Load using the Classic architecture
  • Configure, start, stop, and monitor Change Capture (Extract), and Change Delivery (Replicat) using the Microservices architecture
  • Filter, map, transform and encrypt in-transit data
  • Design replication solutions using Oracle GoldenGate products and environments
  • Install Oracle GoldenGate and prepare the source and target database for replication (assumes an Oracle-to-Oracle environment)
  • Learn and make use of GGSCI commands
  • Use the browser-based interface to configure and manage replication occurring within a Microservices architecture
  • Manage Extract trails and files using utilities such as logdump

Public :

Cette formation Oracle GoldenGate 12c s’adresse aux consultants technique, administrateurs de base de données, responsables de la configuration des systèmes, administrateurs de data warehouse, analystes de data warehouse et concepteurs de base de données.

Pré-requis :

Familiarity with Oracle Database and basic SQL using SQL*Plus, familiarity with editing Linux text files using gedit or vi.

Programme de la formation :


Uses of Oracle GoldenGate Reviewing Oracle GoldenGate Use Cases Oracle GoldenGate Use-Cases for Oracle Database Technology Overview Topologies Supported Platforms Supported Databases Oracle GoldenGate Technology Suite

Oracle GoldenGate Architecture

The Two Oracle GoldenGate Architectures Classic Architecture Extracts Initial Loads Checkpoints The Interaction Between Oracle GoldenGate and Oracle RDBMS

Installing Oracle GoldenGate

Listing System Requirements Performing Installation Configuring Environment Variables Using Oracle GoldenGate Software Command Interface (GGSCI) Running Oracle GoldenGate from the OS shell. Use Obey files to automate tasks

Preparing the Environment and Configuring Integrated Extract

Configuration Overview Preparing the Environment Enabling Oracle GoldenGate in the Database Enabling Supplemental Logging Defining Roles and Permissions Starting the Manager Configuring Data Capture

Configuring Initial Load

Initial Load Overview Configuring Initial Load Setting Up the Initial Load by Using the “File to Replicat” Method Setting Up the Initial Data Load by Using the “Direct Load” Method

Configuring Change Delivery (Replicat)

Replicat Overview Configuring Replicat Tasks Adding Checkpoints Using Checkpoints Initial Load: Avoiding Collisions with Initial Load Initial Load: Handling Collisions with Initial Load Troubleshooting: GGSCI Process Information Troubleshooting: Report FIles and Log FIles

Managing Extract Trails and Files

Trail Format: Local and Remote Trail Format: Cleanup Trail Format: Record Header Area Trail Format: Record Data Area Alternative Trail Formats: Logical Change Records (LCRs) Alternative Trail Formats: Text, SQL, and XML logdump: Opening, Viewing, and Filtering

Oracle GoldenGate Parameters

GLOBALS Manager Source Manager Parameters Target Manager Parameters Extract Extract Parameters on the Source Database Replicat Options Common to Both Replicat and Extract

Data Selection and Filtering

Mapping and Manipulation Definition Files Data Selection Where Filter Mapping SQLEXEC

Additional Transformation and Configuration Options

Create and Invoke Macros Set and Retrieve Useer Tokens Run User Exits in GoldenGate Processes Compress Data Across the Network Encrypt Messages, Trails, and Passwords Automatically Trigger Actions Based on Event Records

Installing Oracle GoldenGate Microservices Architecture

Identify and Describe the Various Components of the Oracle GoldenGate Microservices Architecture List the Operating System Pre-Requisites Needed for a Microservices Architecture installation Perform an Oracle GoldenGate Microservice Architecture Installation and Verify its Successful Completion

Oracle GoldenGate Microservices Architecture - Administration Server

Using the Administration Server Embedded Web Application to Create Extract and Replicat Groups Accessing Extract/Replicat Process Parameters, Statistics, Checkpoints and Reports Using the Administration Server Embedded Web Application

Oracle GoldenGate Microservices Architecture – Distribution Server

Using the Distribution Server Embedded Web Application to Create, Start and Stop Paths Accessing the Data Path Parameters, Statistics, SCN / RBA Positions in Trail Files, and Data Filters Using the Distribution Server Embedded Web Application

Oracle GoldenGate Microservices Architecture - Receiver Server and Performance Metrics Server

The Role and Functionality of an MA Receiver Server The Role and Functionality of an MA Performance Metrics Server

MA Admin Client

Using the Admin Client to Connect to an MA Deployment Performing Common Administrative Tasks by Using the Admin Client

Database Sharding Support, Metadata Encapsulation, Replication Lag Management, Invisible Column Support

Database Sharding Concepts and GoldenGate MA Support for It Metadata Encapsulation Features and Advantages Implementing a Lag Management Policy Handling Replication of Invisible Columns
Print Friendly, PDF & Email
retour vers le catalogue des formations