Expert Oracle GoldenGate

By Ben Prusinski , Steve Phillips , Shing Chung

Expert Oracle GoldenGate shows how to design, implement, and manage complex replication systems through key concepts and case studies involving the latest replication technology from Oracle.

Full Description

  • ISBN13: 978-1-4302-3566-8
  • 352 Pages
  • User Level: Intermediate to Advanced
  • Publication Date: July 16, 2011
  • Available eBook Formats: EPUB, MOBI, PDF
  • Print Book Price: $64.99
  • eBook Price: $45.99
Buy eBook Buy Print Book Add to Wishlist

Related Titles

Full Description

Expert Oracle GoldenGate is a hands-on guide to creating and managing complex data replication environments using the latest in database replication technology from Oracle. GoldenGate is the future in replication technology from Oracle, and aims to be best-of-breed. GoldenGate supports homogeneous replication between Oracle databases. It supports heterogeneous replication involving other brands such as Microsoft SQL Server and IBM DB2 Universal Server. GoldenGate is high-speed, bidirectional, highly-parallelized, and makes only a light impact on the performance of databases involved in replication.

The authors share their experience in the form of tutorials on designing and implementing all types of Oracle GoldenGate environments. You’ll learn methods for tuning Oracle GoldenGate performance. You’ll discover GoldenGate’s utility as a migration and extract, transform, load (ETL) tool. You’ll learn to configure highly-available environments involving GoldenGate, Real Application Clusters, and Data Guard. From installation to design to implementation and troubleshooting, Expert Oracle GoldenGate helps you master all aspects of using and applying Oracle GoldenGate as the replication tool of choice in your environment.

  • Explains all aspects of using GoldenGate for replication
  • Covers homogeneous, heterogeneous, and bidirectional replication
  • Shows the use of GoldenGate for data migration and extract, transform, load (ETL)

What you’ll learn

  • Install Oracle GoldenGate quickly and painlessly
  • Design single- and bi-directional replication solutions
  • Apply GoldenGate to high-availability solutions
  • Troubleshoot and tune GoldenGate for performance
  • Verify data synchronization using GoldenGate Veridata
  • Manage and monitor GoldenGate environments using GoldenGate Director

Who this book is for

Expert Oracle GoldenGate is for database professionals who need to master the latest in replication technology from Oracle. It is for the Oracle Database administrator, technical manager, or Oracle developer requiring a solid base of expertise on to implement or manage replication environments with GoldenGate technology. Expert Oracle GoldenGate is an appropriate and timely reference for all users of the GoldenGate software.

Table of Contents

Table of Contents

  1. Introduction
  2. Installation
  3. Architecture
  4. Basic Replication
  5. Bi-Directional Replication
  6. Heterogeneous Replication
  7. Tuning Oracle GoldenGate
  8. Monitoring Oracle GoldenGate
  9. Oracle GoldenGate Veridata
  10. Oracle GoldenGate Director
  11. Troubleshooting
  12. High Availability & Disaster Recovery
  13. Zero Downtime Migrations and Upgrades
  14. Best Practices
Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.

Errata

Please Login to submit errata.

On page Several:
References to the default port for manager state 7840, but documentation/actual default port value is 7809.

On page 17:

"Also allocate ports for Goldengate manager, Extract, and Replicat processes. By default, manager uses port 7840."

The default port for the manager is 7809, not 7840, and the name of another product is WebLogic, not Weblogic.


On page 23:
http://download.oracle.com/docs/cd/E18101_01/doc.1111/e17341.pdf

PORT defines the port number on which Manager runs on the local system. The default port
is 7809. You must specify either the default port or another port.

It's not an issue of the default port changing from one release to another.

On page 223:
Statement in the book on page 223:
Whenever you use the MIN option, you must also set the MAX option for PURGEOLDEXTRACTS to denote the maximum amount of time to keep the trail file.

What is the reference/source for this? The MAXKEEP options are specified/valid for PURGEDDLHISTORY and PURGEMARKERHISTORY. The Reference Guide does not include a MAX option for PURGEOLDEXTRACTS.

On page 272:
The Reference guide states that TABLEEXCLUDE comes before TABLE, but on page 272, the example has it backwards.

From the Reference guide:
"Use the TABLEEXCLUDE parameter with the TABLE and SEQUENCE parameters to explicitly
exclude tables and sequences from a wildcard specification. TABLEEXCLUDE must precede all
TABLE and SEQUENCE statements that contain the objects that you want to exclude."