Oracle GoldenGate

Reading Time: 6 minutes

Oracle GoldernGate

Module 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
• Listing Non-Database Sources and Targets

Module 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 GoldenGateCheckpointing
• Describing Commit Sequence Numbers (CSN)
• Describing Oracle GoldenGate Files and Directories

Module 3: 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

Module 4: Installing Oracle GoldenGate

• Listing System Requirements
• Performing Installation
• Configuring Environment Variables
• Using GGSCI

Module 5: Running Oracle Golden Gate from the OS shell

Module 6: Configuring Change Capture (Extract)

• Reviewing Extract Overview
• Configuring Extract Tasks
• Adding Extract Group
• Editing Extract Parameters
• Extracting Use of Archived Transaction Logs
• Adding Trails

Module 7: Configuring Change Delivery (Replicat)

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

Module 8: 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

Module 9: Performing Initial Load

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

Module 10: Editing Configuration Parameters

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

Module 11: 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

Module 12: Bidirectional Replication

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

Module 13: DDL Replication

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

ORACLE GOLDENGATE ADVANCE

Module 1: Goldengate DBA Views for Troubleshooting

• Accessing knowledge Documents – Mailing lists, Oracle GoldenGate forums, etc.
• Consulting the Documentation
• Getting familiar with the ShowSyntax parameter
• Getting familiar with the logdump utility

Module 2: Basic and Startup Problems

• Getting familiar with basic problems
• Developing the ability to deal with Extract and Replicatstartup issues
• Verifying file names, file permissions, consistency between Extract and Replicat group names and their supporting files
• Verifying consistent naming convention when defining trail files and their reference in the Extract/Replicat parameter files
• Verifying that the correct software version has been installed
• Verifying that the Oracle GoldenGate manager is running, that the group name which fails to start exists and is not misspelt
• Verifying that the the parameter file exists, has the same name as the Extract/Replicat group, and is accessible by Oracle GoldenGate
• Introducing the use of CHECKPARAMS to verify that the parameter syntax is correct

Module 3: Data Extraction Problems

• Developing the ability to deal with and troubleshoot data extraction issues:Extract is slow – Extract abends – Data pump abends
• Analyzing various causes of a slow Extract startup
• Tracing may be enabled, activity logging may be enabled, many columns listed in tables being replicated
• Introducing the use of the CacheMgr parameter to control the virtual memory and temporary disk space that are available for caching uncommitted transaction data
• In-depth analysis of abending Extracts: is Extract unable to open the transaction logs? – Checking to see if the disk is full -Is an archive log missing?
• In-depth analysis of abending data pumps: Does the data pump abend with error number 509 (“Incompatible record”)?Have the source tables been changed? Is the Extract abending due to data manipulation?
• Was the primary Extract or the data pump stopped, re-added, or restarted without resetting the data pump’s read position in the local trail?

Module 4: Data Replication Problems

• Developing the ability to deal with and troubleshoot data replication issues:
• Analyzing the various causes of a “stuck” Replicat: Does “Stats Replicat” return no statistics? Do successive “Info Replicat” commands indicate that the Replicat read checkpoint is not moving?
• Verifying that the Replicat is reading the trail to which Extract is writing
• Analyzing the reasons why a Replicat abends: Is Replicat unable to locate a trail? Is Replicat unable to open a trail file? Was “Add TranData” issued for each table?

Module 5: Missed Transactions

• Developing the ability to deal with and troubleshoot missed transactions involving issues such as: Tables that are not properly specified – Missing” Add TranData” command – LOB data not replicating
• Analyzing the reasons why transactions are not being processed: Were the tables included in Table and Map statements? Are fully qualified names (owner.table) used for both Table and Map?
• ‘Single quotes’ on object names imply case-sensitive names for some databases (including the Oracle database)
• Are the transactions coming out of the source system properly?

Module 6: Mapping and Synchronization Problems

• Developing the ability to deal with and troubleshoot mapping problems, such us: Fetching from the source data fails – Table and column names not matching between the source and the target
• Analyzing the causes of various mapping problems:Is Extract returning fetch-related errors? Was the row containing the data deleted?
• Has the undo retention expired?
• Is “NoUseLatestVersion” for “FetchOptions” being used?
• Do the source and target tables exist in the databases? Are they specified correctly in the Table or Map statement? Are their names fully qualified (schema.table)?
• Do table and column names contain only supported characters?
• Are WHERE clauses comparing different data types?
• Is KeyCols being used? Are both source and target KeyCols being used? Corresponding source and target columns must match.

Module 7: SQLEXEC, File-Maintenance, and Other Problems

• Developing the ability to deal with and troubleshoot :
• SQLEXEC problems – File-maintenance problems – Time differences – Too many open cursors
• File-Maintenance Problems: Discard File Is Not Created – Discard File Is Too Big – Trail File Is Too Big
• Miscellaneous Problems: Time Differences – INFO Command Shows Incorrect Status

Module 8: “Classic” Performance Tuning

• Identifying causes of slow startups
• Monitoring lag and statistics
• Tuning Manager
• Identifying network and disk bottlenecks
• Tuning “Classic” Extract
• Tuning “Classic” Replicat

Module 9:“Integrated” Performance Tuning

• Describing architecture and advantages of the new Integrated capture
• Describing architecture and advantages of the new Integrated delivery
• Familiarizing with the new V$ tables holding real time Oracle GoldenGate statistics

Module 10: “Integrated” Capture and Delivery Troubleshooting

• Familiarizing with Troubleshooting Aids and Tools for Integrated Replication
• Describing Oracle GoldenGateHealthcheck for Integrated Replicat
• Describing the Oracle Database 12c GoldenGate AWR report
• LogDump
• Frequently Used GGSCI Commands
• Top 60 Interview Questions for Experienced