Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Cover
Title
Copyright
Contents at a Glance
Contents
About the Author
About the Technical Reviewer
Acknowledgments
Chapter 1: Introduction
Distributed Processing and Replication
Oracle Basic Replication
Oracle Advanced Replication
Oracle Streams Replication
Evolution and Oracle GoldenGate
Summary
Chapter 2: Installation
Downloading the Software
Downloading from Oracle E-Delivery
Downloading from OTN
Understanding Your Environment
Reviewing the Install Instructions
Installing Goldengate
General System Requirements
Memory Requirements
Disk Space Requirements
Network Requirements
Operating System Requirements
Requirements for Microsoft Windows Clustered Environments
Installing Goldengate on Windows
Installing GoldenGate 11g on Linux and UNIX
Environment Settings for Oracle and Goldengate on Linux and UNIX
GoldenGate and Oracle RAC Considerations
Installing Goldengate for Microsoft SQL Server on Windows
Installing Goldengate for Teradata on Windows and UNIX
Installing Goldengate for Sybase on Windows and UNIX
Installing GoldenGate for IBM DB2 UDB on Windows and UNIX
Installing Oracle GoldenGate Director 11g
System Requirements
Installing Oracle GoldenGate Director Server
Grant Database Privileges and Credentials to Oracle GoldenGate Director Server Schema
Install Oracle GoldenGate Director
Installing Oracle GoldenGate Veridata
GoldenGate Veridata Agent System Requirements
GoldenGate Veridata Agent Disk Requirements
GoldenGate Veridata Agent Memory Requirements
GoldenGate Veridata Agent Database Privileges
GoldenGate Veridata Server System Requirements
Install Oracle Goldengate Veridata
Summary
Chapter 3: Architecture
Typical GoldenGate Flow
GoldenGate Components
Source Database
Capture (Local Extract) Process
Source Trail
Data Pump
Network
Collector
Remote Trail
Delivery (Replicat)
Target Database
Manager
Topologies and Use Cases
One-Way Replication
Bidirectional Replication
Broadcast Replication
Integration Replication
Tools and Utilities
GGSCI
DEFGEN
Logdump
Reverse
Veridata
Director
Summary
Chapter 4: Basic Replication
Overview
Prerequisites for Setting Up Replication
Requirements
One-Way Replication Topology
Basic Replication Steps
Starting the Extract
Verifying Database-Level Supplemental Logging
Enabling Database-Level Supplemental Logging
Enabling Table-Level Supplemental Logging
Disabling Triggers and Cascade-Delete Constraints
Verifying the Manager Status
Configuring the Local Extract
Adding the Extract
Starting and Stopping the Extract
Verifying the Extract
Starting the Data Pump
Configuring the Data Pump
Adding the Data Pump
Starting and Stopping the Data Pump
Verifying the Data Pump
Loading with GoldenGate
Prerequisites for the GoldenGate Initial Load
Configuring the Initial-Load Extract
Adding the Initial-Load Extract
Configuring the Initial-Load Replicat
Adding the Initial-Load Replicat
Starting the GoldenGate Initial Load
Verifying the Initial Load
Loading with DBMS Utilities
Prerequisites for Loading with DBMS Utilities
Steps for Loading with DBMS Utilities
Starting the Replicat
Configuring the Replicat
Adding the Replicat
Starting and Stopping the Replicat
Verifying the Replicat
Summary
Chapter 5: Advanced Features
Enhancing the Replication Configuration
Enhancing Extract and Replicat Reporting
Reporting Discarded Records
Purging Old Trail Files
Adding Automatic Process Startup and Restart
Adding a Checkpoint Table
Making the Replication More Secure
Encrypting Passwords
Encrypting the Trail Files
Adding Data Filtering and Mapping
Filtering Tables
Filtering Columns
Filtering Rows
Mapping Columns
Transforming Columns
Oracle-Specific DBMS Configuration Options
Configuring for Oracle RAC
Configuring for Oracle ASM
Adding Oracle DDL Replication
Adding Bidirectional Replication
Excluding Transactions for Bidirectional Replication
Handling Conflict Resolution for Bidirectional Replication
Summary
Chapter 6: Heterogeneous Replication
Microsoft SQL Server to Oracle Replication
Preparing the Oracle GoldenGate Environments
Initial Data Load Completion for Oracle GoldenGate Environments
Source Oracle Database Configuration
Target Microsoft SQL Server Database Configuration
Creating Sample Microsoft SQL Server Database
Configure Change Data Capture on Source
Verifying Operational Readiness
Summary
Chapter 7: Tuning
Tuning Methodology
Defining the Performance Requirements
Creating a Performance Baseline
Evaluating the Current Performance
Determining the Problem
Designing and Implementing a Solution
Using Parallel Extracts and Replicats
Implementing Parallel Extracts and Replicats with Table Filtering
Implementing Parallel Extracts and Replicats Using Key Ranges
Using BATCHSQL
Using GROUPTRANSOPS
Tuning Disk Storage
Tuning the Network
Tuning the RMTHOST Parameter
Tuning the Database
Summary
Chapter 8: Monitoring Oracle GoldenGate
Designing a Monitoring Strategy
Why Monitoring the Extract Is Important
Getting the Maximum Threshold
Which Processes to Monitor in the GoldenGate Environment
Monitoring All Running Processes
Monitoring the Detail Extract
Checking the Current Oracle Online Redo Log
Checking the Archived Log
Monitoring the GoldenGate Rate and Redo Log Consumption Rate
Monitoring Lags for Each Group
Viewing Event and Error Logs
Automating Monitoring
Checking GoldenGate Process Scripts
Monitoring Lag Scripts
Checking Memory and CPU Scripts
Checking Disk Space
Summary
Chapter 9: Oracle GoldenGate Veridata
Veridata Components
GoldenGate Veridata Server
GoldenGate Veridata Web
GoldenGate Veridata Repository
GoldenGate Veridata Agent, Java, and C-Code
GoldenGate Veridata CLI (Vericom)
How Veridata Comparison Works
How Veridata Can Help You
Setting Up the Veridata Compares
Creating Database Connections
Setting Up Tables and Data Scripts.
Creating a Group
Creating Compare Pairs
Creating a Job
Creating a Profile
Running the Veridata Job
Improving Performance and Reducing Overhead
Excluding Columns
Tuning Profiles Settings
Disabling the Confirm Out of Sync Step
Increasing the Number of Threads
Compares Methods
Right Trim on Character Fields
Comparing Incremental Data for Large Tables
Comparing GoldenGate Real-Time Replication Data
Comparing Different Column Types and Compare Formats
Using Performance Statistics
Using Vericom Command Line
Setting Up Role-Based Security
Summary
Chapter 10: GoldenGate Director
Director Components
GoldenGate GGSCI Instances
Director Administrator
Director Server and Database
Director Web
Director Client
Setting Up the Data Source
Modifying the Manager Parameter file
Modifying the Parameter File Using the Built-in Editor
Modifying the Parameter File Using the GUI
Setting Up the Initial Load
Adding an Initial Load Task
Creating a One-Way Replication
Adding a Data Pump Process
Additional Director Features and Tricks
Alter Extract or Replicat RUN Options
Changing the Trail-File Size
Extracting Tranlogoptions
Generating Definition Files
Finding Parameters or Attributes in Director
Advanced Mapping
Alerts
Summary
Chapter 11: Troubleshooting Oracle GoldenGate
Common Problems and Solutions
Oracle GoldenGate Process Failures
Oracle GoldenGate Extract Process Failures
Oracle GoldenGate Process Failures Without Report Diagnostics
Oracle GoldenGate Trail File Problems
Trail Files that Don’t Empty
Trail Files that Don’t Roll Over
Trail File Purging Issues
Trail Files that Purge Too Soon
Oracle GoldenGate Error Log Analysis
Understanding the Oracle GoldenGate Discard File
Discard File Not Created
Discard File Is Too Big
Can’t Open the Discard File
Using Trace Commands with Oracle GoldenGate
Oracle GoldenGate Process Tracing with TLTRACE
Using TRACE Parameters with Oracle GoldenGate
Troubleshooting Case Study with Oracle GoldenGate
Oracle GoldenGate Configuration Issues
Incorrect Software Versions with Oracle GoldenGate
Database Availability Issues
Missing Oracle GoldenGate Process Groups
Missing Oracle GoldenGate Trail Files
Oracle GoldenGate Parameter File Configuration Issues
Operating System Configuration Issues with Oracle GoldenGate
Network Configuration Issues with Oracle GoldenGate
Network Data-Transfer Issues
Oracle Database Issues with GoldenGate
Extract Can’t Access Oracle Database Archive and Redo Logs
Extract Failure Conditions Due to Oracle Source Database Issues
Data-Pump Errors
Replicat Errors on the Oracle Database Target System
Replicat Hangs on the Target System
Replicat Experiences an Abend Failure on the Target System
Replicat Fails on Large Transactions
Incompatible Record Errors with a Replicat
Data-Synchronization Issues
Tables Missing Key Constraints
Character Set Configuration Issues
Missing-Column Errors
Fetch Failures
Summary
Chapter 12: Disaster Recovery Replication
Prerequisites
Requirements
Disaster Recovery Replication Topology
Setup
Configuring the Local Extract for Disaster Recovery
Configuring the Data Pump for Disaster Recovery
Configuring the Replicat for Disaster Recovery
Configuring the Standby Extract
Configuring the Standby Data Pump
Configuring the Standby Replicat
Performing a Planned Switchover
Performing an Unplanned Failover
Summary
Chapter 13: Zero-Downtime Migration Replication
Prerequisites
Requirements
Zero-Downtime Migration Topology
Setup
Configuring the Local Extract for Zero-Downtime Migration
Configuring the Data Pump for Zero-Downtime Migration
Configuring the Replicat for Zero-Downtime Migration
Configuring the Fallback Local Extract for Zero-Downtime Migration
Configuring the Fallback Data-Pump for Zero-Downtime Migration
Configuring the Fallback Replicat for Zero-Downtime Migration
Performing the Migration Cutover
Performing the Migration Fallback
Summary
Chapter 14: Tips and Tricks
Requirements and Planning
Knowing the Business Objectives
Understanding the Requirements
Determining the Topology
Installation and Setup
Creating Dedicated Users
Encrypting Passwords
Creating a Dedicated Installation Directory
Using a Checkpoint Table
Verifying the Character Sets
Developing Naming Standards
Using a Data Pump
Management and Monitoring
Using GGSCI Command Shortcuts
Using OBEY Files
Generating Interim Statistics
Using a Discard File
Reporting Regularly on Process Health
Purging Old Trail Files Regularly
Automatically Starting Processes
Performance
Running Performance Tests
Limiting the Number of Extracts
Using Passthru Mode for Data Pumps
Using Parallel Replicats
Using the Fastest Available Storage
Tuning the Database
Summary
Appendix: Additional Technical Resources for the Oracle GoldenGate Administrator
References for Further Reading
Quick Guide to Oracle GoldenGate Commands
ADD
GGSCI
HELP
INFO
SEND
STATUS
Logdump Commands and Syntax for Troubleshooting
Accessing the Logdump Utility
Getting Help with Logdump Syntax
HISTORY
Opening GoldenGate Trail Files with Logdump
Index
← Prev
Back
Next →
← Prev
Back
Next →