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 that 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.
Computers 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 within minutes.
Chapter 1, Getting Started, provides an introduction to Oracle GoldenGate, inspiring thought by describing the key components, processes, and considerations required to build and implement a GoldenGate solution.
The topics covered the evolution of GoldenGate Software, including the architecture behind the technology followed by the solutions GoldenGate can provide, coupled with effective design.
Chapter 2, Installing and Preparing GoldenGate, walks you through the individual tasks needed to complete an end-to-end GoldenGate installation, including the download of the software through to creating a simple data replication environment.
Chapter 3, Design Considerations, addresses some of the issues that influence the decision making process when designing a GoldenGate solution. These include design considerations for both performance and high availability. Here you can choose the appropriate hardware and topology to deliver a fast, robust and scalable solution.
Chapter 4, Configuring Oracle GoldenGate, initially discusses the main GoldenGate parameters, and provides a methodical approach to the configuration process, stepping through each task to give the depth of information necessary to successfully implement GoldenGate on Oracle 11g. By providing the building blocks, this chapter forms the basis for more complex configurations.
Chapter 5, Configuration Options, looks at the available options that allow your configuration to extend in functionality and performance. We start with performance enhancements, later exploring the security features, including data compression and encryption, and finally discussing the options available to implement DDL replication.
Chapter 6, Configuring GoldenGate for HA teaches you how to configure Oracle GoldenGate in a RAC environment and explores the various components that effectively enable HA for data replication and integration.
Chapter 7, Advanced Configuration, gives you a deeper understanding of GoldenGate configuration. By the time you are done with this chapter, you will be able to explore and realize each parameter specification and further develop your GoldenGate configuration.
Chapter 8, Managing Oracle GoldenGate, focuses on the management features already built in to the GoldenGate Command Interpreter (GGSCI). We discuss and implement a number of utilities, including tips and tricks that allow you to manage your GoldenGate environment effectively at no extra cost. This includes a Perl script that will format the text output from the GGSCI "INFO ALL" command so that the data can be loaded into MS Excel for graphing and trend analysis.
Chapter 9, Performance Tuning, focuses on the main areas that lend themselves to tuning, especially parallel processing and load balancing, enabling high data throughput and very low latency. Performance enhancing new features that are available in the next version of GoldenGate are also discussed and evaluated.
Chapter 10, Troubleshooting GoldenGate, provides a troubleshooting guide for Oracle GoldenGate. We address some of the common issues faced by the implementer, followed by a discussion of the tools and utilities available to help resolve them. This includes the creation of an Exception Handler that automatically logs the details of a failed transaction for further analysis and resolution.
This book has three appendices; their purpose is to provide a "quick reference" as well as address any subjects and terminology not addressed in the previous chapters.
Appendix A, GGSCI Commands, provides a quick reference guide to all the available GoldenGate Software Command Interface (GGSCI) commands.
Appendix B, GoldenGate Installed Components, lists the GoldenGate installed components and their description.
Appendix C, The Future of Oracle GoldenGate, discusses Oracle's strategic approach to data replication and integration. The latest release of GoldenGate including its sister products are described along with links to official documentation and forums on the Oracle website.