In recent years, data replication has been an important part of many database systems. The growing trend for data integration is due to today's demand for real-time access and real-time information. GoldenGate is Oracle's strategic data synchronization solution that has become integrated with many sister products to address the most demanding business requirements. Until now, very little has been written about the end-to-end implementation of GoldenGate in a production enterprise-wide environment, irrespective of whether it is the traditional point-to-point replication or on-premise to cloud, performance, scalability, data integrity, and security, which is always paramount.
Welcome to Oracle GoldenGate 12c Implementer's Guide, a comprehensive book that delivers a practical approach in a clear and concise style. Whether you are new to GoldenGate or an advanced user, this book helps you get up to speed quickly. Based on the author's own experience, this long-awaited second edition book has all the information that is required to install, design, configure, and tune data integration solutions suited to every environment. Expert users can dive into key topic areas, such as performance tuning or troubleshooting, and seek desired solutions from the numerous tips and tricks, whereas novice users can go through the early installation and configuration chapters, later progressing to the advanced chapters.
This book helps you master data integration techniques to empower your organizations' readiness to migrate to cloud technologies quickly and easily. Covering both noncontainer and multitenant container database architecture, the book will appeal to the Oracle 11g and 12c database administrator, implementing GoldenGate for the most demanding business requirements.
This book is more than an implementation guide. It offers detailed real-life examples, encouraging additional thought and discussion that goes beyond the manual.
With Oracle GoldenGate 12c Implementer's Guide in hand, you'll be designing, installing, and configuring high-performance solutions with GoldenGate within minutes.
Chapter 1, Getting Started, provides an introduction to Oracle GoldenGate by describing the key components, processes, and considerations required to build and implement a GoldenGate solution. The topics covered include the evolution of the GoldenGate software, including the architecture behind the technology, followed by the solutions GoldenGate can provide along with its effective design. You will become accustomed with the concepts of the data replication and how GoldenGate provides robust enterprise-wide solutions.
Chapter 2, Installing and Preparing GoldenGate, helps you quickly learn the individual tasks needed to complete an end-to-end GoldenGate installation, including downloading, installing, and configuring the Oracle GoldenGate 12c software, the preinstallation steps for the OS and database, apart from the software and hardware requirements. The steps include the Oracle database setup and the configuration of GoldenGate, providing an overview that allows you to swiftly get up and running.
Chapter 3, Design Considerations, tells you how to address some of the issues that influence the decision-making process when you design a GoldenGate solution. This includes design considerations for performance, security, backup and recovery, and high availability. This chapter also helps you choose the appropriate hardware and topology to deliver a fast, robust, and scalable solution.
Chapter 4, Configuring Oracle GoldenGate, initially discusses the main GoldenGate configuration parameters and provides a methodical approach to the configuration process, stepping through each task to give in-depth information necessary to successfully implement Oracle GoldenGate 12c. In this chapter, you will learn the basic steps necessary to configure one-way replication in a GoldenGate environment, including data synchronization between the source and target.
Chapter 5, Configuration Options, focuses on the additional configuration options available in Oracle GoldenGate 12c. The powerful options discussed in this chapter allow you to extend your configuration to increase functionality and performance. Starting with a performance enhancing option to exploring the security features, data compression and encryption, heterogeneous environments, and finally discussing the DDL support and the tools available to monitor the DDL replication, this chapter covers an extensive array of configuration topics.
Chapter 6, Configuring GoldenGate for HA, explores how to configure GoldenGate in a RAC environment and talks about the various components that effectively enable HA for data replication and integration. The discussion topics include shared storage options, load balancing, and failover, apart from GoldenGate on Exadata.
Chapter 7, Advanced Configuration, gives you a deeper understanding about how to configure GoldenGate. 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. You will also learn how GoldenGate is used with Oracle Data Integrator to deliver real-time data synchronization solutions.
Chapter 8, Managing Oracle GoldenGate, focuses on the management features already built-in the GoldenGate Command Interpreter (GGSCI). This chapter discusses and implements a number of utilities, including tips and tricks that allow you to manage your GoldenGate environment effectively at no extra cost. This includes a step-by-step guide to configure a Metric Extension in Oracle Enterprise Manager 12c to monitor your GoldenGate Enterprise.
Chapter 9, Performance Tuning, covers the main areas that lend themselves to tuning, especially parallel processing and load balancing, enabling high data throughput and very low latency. In this chapter, you will learn how to leverage the performance enhancing new features that are available in GoldenGate 12c, including batch replication latency reduction and data delivery optimization through integrated processes.
Chapter 10, Troubleshooting GoldenGate, tells you how to investigate and resolve some of the common issues faced by the GoldenGate administrator. This chapter has captured some of the most common failure scenarios, offering help and guidance to wards a successful resolution. From using LOGDUMP to drilling into the GoldenGate trail files to automatic exception handling, you will quickly understand the importance of a methodical approach to troubleshooting.
Chapter 11, The Future of GoldenGate, takes you through the new technology and concepts where GoldenGate plays a role. It discusses cloud computing, Software as a Service (SaaS), and advances in integration, such as on-premise to cloud migrations and big data as well.
Appendix A, GGSCI Commands, provides a quick reference guide to all the available GGSCI commands.
Appendix B, GoldenGate Installed Components, lists the GoldenGate-installed components and their descriptions.
Appendix C, Acronyms, lists the acronyms with their fully qualified names that have been used throughout this book.