- 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. Youll learn methods for tuning Oracle GoldenGate performance. Youll discover GoldenGates utility as a migration and extract, transform, load (ETL) tool. Youll 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 youll 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
- Basic Replication
- Bi-Directional Replication
- Heterogeneous Replication
- Tuning Oracle GoldenGate
- Monitoring Oracle GoldenGate
- Oracle GoldenGate Veridata
- Oracle GoldenGate Director
- High Availability & Disaster Recovery
- Zero Downtime Migrations and Upgrades
- Best Practices
- Source Code/Downloads
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."