Oracle GoldenGate 12c: Fundamentals for Oracle

Prerequisiti obbligatori:

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

Prerequisiti suggeriti :

• Familiarity with basic encryption techniques

Il corso è rivolto a:

• Amministratore di database
• Amministratore di datawarehouse
• Consulente tecnico
• Analista di datawarehouse

• 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

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