Oracle Golden Gate

1
(No Transcript)
2
(No Transcript)
3
Course Curriculum

• Session 1 0.5 Hour
• Introduction
• Learning objectives In this module, you will
  learn Listing Course Objectives and Discussing
  Course Non-Objectives.
• Topics Discussing Required versus Suggested
  Knowledge, Listing Course Objectives, Discussing
  Course Non-Objectives (available as other
  follow-on courses).

4
Session 2 2 Hours Technology
Overview Learning objectives In this module,
you will learn Creating Oracle Golden Gate
Topologies, Listing Supported OS, Listing the
Oracle Golden Gate Product Line and Listing
Non-Database Sources and Targets. Topics
Creating Oracle Golden Gate Topologies, Reviewing
Oracle Golden Gate Use Cases, Assembling Building
Blocks, Listing Supported OS, Listing Supported
Databases, Listing the Oracle Golden Gate Product
Line, Describing GUI Management Options, Listing
Non-Database Sources and Targets. Session 3 2
Hours Oracle Golden Gate Architecture Learning
objectives In this module, you will learn
Describing Oracle Golden Gate Process Groups,
Explaining Oracle Golden Gate Checkpointing,
Describing Commit Sequence Numbers (CSN) and
Describing Oracle Golden Gate Files and
Directories. Topics Describing Oracle Golden
Gate Process Groups, explaining change Capture
and Delivery (with and without a data pump),
Explaining Initial Data Load, Contrasting Batch
and Online Operation, Explaining Oracle Golden
Gate Checkpointing, Describing Commit Sequence
Numbers (CSN), Describing Oracle Golden Gate
Files and Directories.
5
Session 4 2 Hours Installing Oracle Golden
Gate Learning objectives In this module, you
will learn Listing System Requirements,
Configuring Environment Variables, Using GGSCI
and Running Oracle Golden Gate from the OS
shell. Topics Listing System Requirements,
Performing Installation, Configuring Environment
Variables, using GGSCI, Running Oracle Golden
Gate from the OS shell. Session 5 2
Hours Configuration Overview and Preparing the
Environment Learning objectives In this module,
you will learn Reviewing Configuration Overview,
Creating Source Definitions and Assigning Oracle
Database Roles/Privileges Required. Topics
Reviewing Configuration Overview, Configuring
Manager Process, Creating Source Definitions,
Preparing the Source Database, Assigning Oracle
Database Roles/Privileges Required.
6
Session 6 2.5 Hours Configuring Change
Capture (Extract) Learning objectives In this
module, you will learn Reviewing Extract
Overview, Accessing Logs on Oracle ASM,
Configuring Extract Tasks and Adding
Trails. Topics 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. Session 7 0.5 hr. Configuring
Change Delivery (Replicat) Learning objectives
In this module, you will learn Reviewing Replicat
Overview and Configuring a Sample
Environment. Topics Reviewing Replicat
Overview, Configuring Replicat Tasks, Configuring
a Sample Environment.
7
Session 8 2 Hours Configuring Extract Trails
and Files (Data Pump) Learning objectives In
this module, you will learn Reviewing Extract
Trails and Files Overview, Using Log dump for
Viewing Trails and Configuring and Using Data
Pumps. Topics Reviewing Extract Trails and
Files Overview, Describing Trail Formats, Using
Log dump for Viewing Trails, Reversing the Trail
Sequence, Configuring and Using Data
Pumps. Session 9 2 Hours Performing Initial
Load Learning objectives In this module, you
will learn Oracle Golden Gate Methods, Describing
Resource Limitations, Configuring File Load
Methods and Configuring Direct Load
Methods. Topics Oracle Golden Gate Methods,
Listing Database-specific Methods, Describing
Resource Limitations, Listing Advantages of
Oracle Golden Gate Methods, Configuring File Load
Methods, Configuring Direct Load Methods,
Handling Collisions with Initial Load.
8
Session 10 2 Hours Editing Configuration
Parameters Learning objectives In this module,
you will learn Editing Parameter Files,
Configuring GLOBALS Parameters, Configuring
Manager Parameters and Filtering and Data
Selectio Topics Editing Parameter Files,
Contrasting GLOBALS versus Process Parameters,
Configuring GLOBALS Parameters, Configuring
Manager Parameters, Configuring Extract
Parameters, Configuring Replicat Parameters,
Filtering and Data Selection . Session 11 2
Hours Bidirectional Replication Learning
objectives In this module, you will learn
Reviewing Bidirectional Considerations, Avoiding
Conflicts and Describing Identity Types
Issues. Topics Reviewing Bidirectional
Considerations, Detecting Loops, Avoiding
Conflicts Configuring and Using Conflict
Detection and Resolution, Describing Identity
Types Issues.
9
Session 12 2 Hours DDL Replication Learning
objectives In this module, you will learn
Reviewing Data Description Language Replication
Overview and Configuring and Using String
Substitution in DDL. Topics Reviewing Data
Description Language Replication Overview,
Configuring and Using Options for DDL
Replication, Configuring and Using String
Substitution in DDL. Session 13 2.5
Hours Tuning and Troubleshooting Learning
objectives In this module, you will learn
Managing Trail Files, Handling TCP/IP Errors,
Using Reporting and Statistics and Features of
Golden Gate Management Pack. Topics Controlling
Command Persionns, Managing Trail Files,
Automating Process Setup, Restarting Oracle
Golden Gate, Handling TCP/IP Errors, Using
Reporting and Statistics, Monitoring Processes,
Lags and Error Messages, Features of Golden Gate
Management Pack.
10
Register Now