Oracle GoldenGate 11g Implementer's guide

Design, install, and configure high-performance data replication solutions with this Oracle GoldenGate book and eBook

Oracle GoldenGate 11g Implementer's guide

Starting
John P Jeffries

Design, install, and configure high-performance data replication solutions with this Oracle GoldenGate book and eBook
$10.00
$54.99
RRP $32.99
RRP $54.99
eBook
Print + eBook
$12.99 p/month

Get Access

Get Unlimited Access to every Packt eBook and Video course

Enjoy full and instant access to over 3000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Code Files
+ Collection
Free Sample

Book Details

ISBN 139781849682008
Paperback280 pages

About This Book

  • The very first book on GoldenGate, focused on design and performance tuning in enterprise-wide environments
  • Exhaustive coverage and analysis of all aspects of the GoldenGate software implementation, including design, installation, and advanced configuration
  • Migrate your data replication solution from Oracle Streams to GoldenGate
  • Design a GoldenGate solution that meets all the functional and non-functional requirements of your system
  • Written in a simple illustrative manner, providing step-by-step guidance with discussion points
  • Goes way beyond the manual, appealing to Solution Architects, System Administrators and Database Administrators

Who This Book Is For

This book is for Solution Architects and Database Architects who wish to learn about the functionality and efforts required in implementing a data replication, migration or integration solution using GoldenGate. It is also designed for System Administrators and Database Administrators who want to implement, or those who have already implemented, Goldengate and who want to explore its advanced features. An intermediate understanding of Oracle database technology is assumed.

Table of Contents

Chapter 1: Getting Started
What is GoldenGate?
Oracle GoldenGate evolution
Oracle GoldenGate solutions
Oracle GoldenGate technology overview
Oracle GoldenGate architecture
Supported platforms and databases
Oracle Goldengate topology
Design considerations
What to Replicate?
Summary
Chapter 2: Installing and Preparing GoldenGate
Prerequisites
Software installation
Preparing the environment
Creating the initial configuration
Uninstalling GoldenGate from Linux/UNIX
Summary
Chapter 3: Design Considerations
Replication methods
Networking
Non-functional requirements (NFRs)
Hardware considerations
Changed data management
Summary
Chapter 4: Configuring Oracle GoldenGate
GoldenGate parameters
Configuring the Initial Load
Performing the Initial Load
Configuring Change Data Capture
Configuring Change Delivery
Testing Change Data Capture and Delivery
Stopping GoldenGate processes
More about trail files
Configuring the Manager process
Summary
Chapter 5: Configuration Options
Using BATCHSQL
Data compression
Security features
Event Actions
Bi-directional configuration options
Heterogeneous environments
DDL replication
Summary
Chapter 6: Configuring GoldenGate for HA
GoldenGate on RAC
GoldenGate on Exadata
Failover
Summary
Chapter 7: Advanced Configuration
Mapping your data
Data selection and filtering
Data transformation
DDL support
The SQLEXEC parameter
Using and defining macros
User tokens
User Exits
Using logic in data replication
Licensing
Summary
Chapter 8: Managing Oracle GoldenGate
Command level security
Trail file management
Managing process startup
Managing TCP/IP errors
Reporting and statistics
Summary
Chapter 9: Performance Tuning
Before tuning GoldenGate
Balancing the load across parallel process groups
Splitting large tables into row ranges across process groups
Configuring multiple parallel process groups
New releases
Tuning the network
Summary
Chapter 10: Troubleshooting GoldenGate
Troubleshooting tips
Exception handling
Handling Oracle Sequences
Using LOGDUMP
Upgrading GoldenGate
Summary

What You Will Learn

  • Deliver high-speed data replication solutions
  • Implement robust Disaster Recovery solutions
  • Migrate applications with no data loss or downtime
  • Configure GoldenGate for High Availability and Scalability
  • Troubleshoot and solve data replication problems, including Conflict Handling and Error Detection
  • Write your own GoldenGate macros and enhancements
  • Configure multi-target replication from a single-source database
  • Configure bi-directional replication
  • Report on your data throughput and latency
  • Tune GoldenGate for high performance
  • Learn about the advanced features and techniques that make GoldenGate the preferred choice in data replication

In Detail

Data replication is an important part of any database system that is growing due to today's demand for real-time reporting and regulatory requirements. GoldenGate has recently become Oracle's strategic real-time data replication solution. Until now, very little has been written about how to implement GoldenGate in a production enterprise environment where performance, scalability, and data integrity are paramount.

Your days of dismay over the lack of documentation over Oracle GoldenGate are over.

Welcome to Oracle GoldenGate 11g Implementer's guide – a comprehensive practical book, which will deliver answers to your questions in a clear, concise style, allowing you to progress effectively in a timeline-driven environment. Based on the author's own experience, this long awaited GoldenGate administration book has all that is required to install, design, configure, and tune data replication solutions suited to every environment. Be the first to master GoldenGate's power and flexibility by reading this unique hands-on implementation companion.

Systems need to send data from one system to another in a timely manner to satisfy the ever-increasing need for speed. Regardless of whether you are a novice or an expert – or someone in between – this book will guide you through all the steps necessary to build a high-performance GoldenGate solution on Oracle11gR1. Expert users can dive into key topic areas such as performance tuning or troubleshooting, while novice users can step through the early installation and configuration chapters, later progressing to the advanced chapters.

This book is more than an implementation guide. It offers detailed real-life examples, encouraging additional thought and discussion by going beyond the manual.

With Oracle GoldenGate 11g Implementer's guide in hand, you'll be designing, installing, and configuring high-performance solutions using GoldenGate in less time than you can say "replicate"

Authors

Table of Contents

Chapter 1: Getting Started
What is GoldenGate?
Oracle GoldenGate evolution
Oracle GoldenGate solutions
Oracle GoldenGate technology overview
Oracle GoldenGate architecture
Supported platforms and databases
Oracle Goldengate topology
Design considerations
What to Replicate?
Summary
Chapter 2: Installing and Preparing GoldenGate
Prerequisites
Software installation
Preparing the environment
Creating the initial configuration
Uninstalling GoldenGate from Linux/UNIX
Summary
Chapter 3: Design Considerations
Replication methods
Networking
Non-functional requirements (NFRs)
Hardware considerations
Changed data management
Summary
Chapter 4: Configuring Oracle GoldenGate
GoldenGate parameters
Configuring the Initial Load
Performing the Initial Load
Configuring Change Data Capture
Configuring Change Delivery
Testing Change Data Capture and Delivery
Stopping GoldenGate processes
More about trail files
Configuring the Manager process
Summary
Chapter 5: Configuration Options
Using BATCHSQL
Data compression
Security features
Event Actions
Bi-directional configuration options
Heterogeneous environments
DDL replication
Summary
Chapter 6: Configuring GoldenGate for HA
GoldenGate on RAC
GoldenGate on Exadata
Failover
Summary
Chapter 7: Advanced Configuration
Mapping your data
Data selection and filtering
Data transformation
DDL support
The SQLEXEC parameter
Using and defining macros
User tokens
User Exits
Using logic in data replication
Licensing
Summary
Chapter 8: Managing Oracle GoldenGate
Command level security
Trail file management
Managing process startup
Managing TCP/IP errors
Reporting and statistics
Summary
Chapter 9: Performance Tuning
Before tuning GoldenGate
Balancing the load across parallel process groups
Splitting large tables into row ranges across process groups
Configuring multiple parallel process groups
New releases
Tuning the network
Summary
Chapter 10: Troubleshooting GoldenGate
Troubleshooting tips
Exception handling
Handling Oracle Sequences
Using LOGDUMP
Upgrading GoldenGate
Summary

Book Details

ISBN 139781849682008
Paperback280 pages
Read More