Konsultasiya almaq
Training Center MUKКурсыOracleMiddlewareOracle GoldenGate 12c: Fundamentals for Oracle

Oracle GoldenGate 12c: Fundamentals for Oracle

Kursun kodu
Orcl_GG
Müddət
4 Gün, 32 Saat
Kursun təsviri
Məqsədlər
Tələblər
Kursun proqramı
Kursun təsviri

Course overview

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.

Məqsədlər

Course objectives

  • Design replication solutions using Oracle GoldenGate products and environments
  • Install Oracle GoldenGate and prepare the source and target database (assumes Oracle-to-Oracle replication)
  • Issue GGSCI commands (batch Obey scripts and command-line interactive)
  • Configure, start, stop, and monitor Change Capture (Extract), Change Delivery (Replicat), and Initial Load
  • Manage Extract trails and files using Data Pump and utilities such as logdump
  • Control network transmission using compression and encryption
  • Transform data
Tələblər

Audience

  • Administrator
  • Analyst
  • Architect
  • Database Administrator
  • Developer
  • Implementer
  • System Integrator
Kursun proqramı

Course outline

1.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

2. 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

3. Installing Oracle GoldenGate

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

4. 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

5. 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

6. Configuring Change Delivery (Replicat)

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

7. 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

8. 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

9. Editing Configuration Parameters

10. Filtering and Data Selection

11. Additional Transformation Concepts

12. Configuration Options

13. Bidirectional Replication

14. DDL Replication

Ən yaxın kurs üçün qeydiyyat
Oracle GoldenGate 12c: Fundamentals for Oracle
Kursun kodu:
Orcl_GG
Müddət:
4 Gün, 32 Saat
Qeydiyyatan keç
Konsultasiya almaq
Свяжитесь со мной
Konsultasiya almaq
Отправить заявку
Vebinara qeydiyyat
Отправить заявку
Müraciətiniz qəbul olundu!
Yaxın zamanda sizinlə əlaqə saxlanılacaq.