咨询热线:    40000-53353(全国)    0571-28976118(浙江)    
 

Oracle GoldenGate 11g: Fundamentals for Oracle 预约试听

 

课程长度:4天/24小时

课程描述:

    ·Install Oracle GoldenGate on Linux and Windows platforms
    ·Issue GGSCI commands
    ·Configure, start, stop, and monitor Change Capture and Delivery processes
    ·Manage Extract trails and files using Data Pump and logdump
    ·Create parameter files to transformdata
    ·Manage multiple Oracle GoldenGate instances

 

课程目标:

   ·Design replication solutions using Oracle GoldenGate products and environments
    ·Install Oracle GoldenGate on Linux and Windows platforms (the labs are Linux)
    ·Prepare the source and target database environments (assumes Oracleto-
Oracle replication)
    ·Issue GGSCI commands (batch Obey scripts and command-line
interactive)
    ·Configure, start, stop, and monitor Change Capture (Extract)
    ·Configure, start, stop, and monitor Change Delivery (Replicat)
    ·Configure, start, stop, and monitor Initial Load
    ·Manage Extract trails and files using Data Pump and utilities such as logdump
    ·Control network transmission using compression and encryption
    ·Create parameter files
    ·Transformdata
    ·Manage multiple Oracle GoldenGate instances

 

培训内容:

Introduction Technology Overview Oracle GoldenGate Architecture
    ·Discussing Required versus Suggested Knowledge
    ·Listing Course Objectives
    ·Discussing Course Non-Objectives (available as other follow-on courses)
    ·Creating Oracle GoldenGate Topologies
    ·Reviewing Oracle GoldenGateUse Cases
    ·Assembling Building Blocks
    ·Listing Supported OS
    ·Listing Supported Databases
    ·Listing the Oracle Goldengate Product Line
    ·DescribingGUIManagementOptions
    ·Listing Non-Database Sources and Targets
    ·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 SystemRequirements
    ·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 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 Extract Trails and Files (Data Pump)

    ·ReviewingExtractTrailsandFiles 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 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
    ·ConfiguringandUsingEvent Actions 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