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