Oracle GoldenGate 12c: Fundamentals for Oracle

Leírás

Óraszám: 4 nap; 32 tanóra

Minimum létszám: 8 fő

A képzés nyelve: magyar

Tandíj: 509.040 Ft /fő + ÁFA

A képzés rövid leírása:

This Oracle GoldenGate 12c: Fundamentals for Oracle training focuses on Oracle-to-Oracle database replication. Expert Oracle University instructors will deep dive into the Oracle GoldenGate architecture, walking you through various product features.

Képzési tematika:

Technology Overview

• Creating Oracle GoldenGate Topologies
• Reviewing Oracle GoldenGate Use Cases
• Assembling Building Blocks
• Listing Supported OS
• Listing Supported Databases
• Listing the Oracle GoldengGate Product Line
• Describing GUI Management Options
• Listing Non-Database Sources and Targets

 

Oracle GoldenGate Architecture

• Describing Oracle GoldenGate Process Groups
• Explaining Change Capture and Delivery (with and without a Data Pump)
• Explaining Initial Data Load
• Contrasting Batch and Online Operation
• Explaining Oracle GoldenGate Checkpointing
• Describing Commit Sequence Numbers (CSN)
• Describing Oracle GoldenGate Files and Directories

 

Installing Oracle GoldenGate

• Listing System Requirements
• Performing Installation Configuring Environment Variables
• Using GGSCI
• Running Oracle GoldenGate from the OS shell

 

Configuration Overview and Preparing the Environment

• Reviewing Configuration Overview
• Configuring Manager Process
• Creating Source Definitions
• Preparing the Source Database
• Assigning Oracle Database Roles/Privileges Required
• Using DBMS_GOLDENGATE_AUTH Package

 

Configuring Change Capture (Extract)

• Reviewing Extract Overview
• Accessing Logs on Oracle ASM
• Accessing Logs Remotely
• Configuring Extract Tasks
• Adding Extract Group
• Editing Extract Parameters Extracting Use of Archived Transaction Logs
• Adding Trails

 

Configuring Change Delivery (Replicat)

• Reviewing Replicat Overview
• Configuring Replicat Tasks
• Configuring a Sample Environment
• Configuring New Integrated Replicat

 

Configuring Extract Trails and Files (Data Pump)

• Reviewing Extract Trails and Files Overview
• Describing Trail Formats
• Using Logdump for Viewing Trails
• Reversing the Trail Sequence
• Configuring and Using Data Pumps

 

Performing Initial Load

• Oracle GoldenGate Methods
• Listing Database-specific Methods
• Describing Resource Limitations
• Listing Advantages of Oracle GoldenGate Methods
• Configuring File Load Methods
• Configuring Direct Load Methods
• Handling Collisions with Initial Load

 

Editing Configuration Parameters

• Editing Parameter Files
• Contrasting GLOBALS versus Process Parameters
• Configuring GLOBALS Parameters
• Configuring Manager Parameters
• Configuring Extract Parameters
• Configuring Replicat Parameters

 

Filtering and Data Selection

• Filtering and Data Selection
• Mapping Columns Between Different Schemas
• Using Built-in „@” (at) Functions
• Using SQLEXEC to Interact Directly with a Database
• Configuring New Coordinated Replicat

 

Additional Transformation Concepts

• Configuring and Using Macros
• Configuring and Using User Tokens
• Configuring and Using User Exits
• Configuring and Using Oracle Sequences

 

Configuration Options

• Configuring and Using BATCHSQL
• Configuring and Using Compression
• Configuring and Using Encryption
• Configuring and Using Event Actions
• Configuring New Wallet Security

 

Bidirectional Replication

• Reviewing Bidirectional Considerations
• Detecting Loops
• Avoiding Conflicts
• Configuring and Using Conflict Detection and Resolution
• Describing Identity Types Issues

DDL Replication

• Reviewing Data Description Language Replication Overview
• Configuring and Using Options for DDL Replication
• Configuring and Using String Substitution in DDL

Belépési feltételek:

Audience

Configuration Consultant, Data Warehouse Administrator, Data Warehouse Analyst, Data Warehouse Developer, Database Administrators, Database Designers, System Integrator, Technical Consultant

 

Related Training –  Required Prerequisites

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

Igazolás: Tanúsítvány