Book description
Leverage the power of real-time data access for designing, building, and tuning your GoldenGate Enterprise
In Detail
GoldenGate exchanges data among systems in a timely manner and meets the demand for real-time access to information regardless of volume. The new release, 12c, includes an optimized database, intelligent and integrated delivery capabilities, expanded heterogeneity, and tighter security. Perform zero downtime data migration to on-premise or public cloud with GoldenGate's feature-rich portfolio.
Start with the installation and learn the design concepts and enhanced configuration of GoldenGate 12c. Exploit new 12c features to successfully implement GoldenGate on your enterprise. Dive deep into configuring GoldenGate for high availability, DDL support, and reverse processing. Build fast, secure, robust, scalable technical solutions by tuning data delivery and networks. Finally, enrich your data replication knowledge by learning the troubleshooting tips.
What You Will Learn
- Extend GoldenGate's out-of-the-box functionality to employ its rich features and meet your business objectives
- Deliver best-in-class data integration solutions by integrating GoldenGate with other Oracle products
- Deploy data integration solutions effectively to lower your total cost of ownership and increase you ROI
- Extend GoldenGate functionality through APIs and reduce your IT operational expenditure
- Leverage the designs to build efficient, cost effective data integration solutions
- Enhance system management and monitoring in your GoldenGate environment
- Generate real-time statistics to gauge data throughput and performance
- Evaluate data integration concepts through Oracle's new Integration Cloud Service offering
Table of contents
-
Oracle GoldenGate 12c Implementer's Guide
- Table of Contents
- Oracle GoldenGate 12c Implementer's Guide
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Preface
-
1. Getting Started
- What is GoldenGate?
- Oracle GoldenGate evolution
- Oracle GoldenGate solutions
- Oracle GoldenGate technology overview
- Oracle GoldenGate architecture
- 12c new features
- Supported platforms and databases
- Oracle GoldenGate topology
- Design considerations
- What to replicate?
- Summary
-
2. Installing and Preparing GoldenGate
- Prerequisites
- The Oracle virtual machine
- The software installation
- Preparing the environment
- Creating the initial configuration
- Patching the GoldenGate home
- GoldenGate deinstallation from Linux/Unix
- Summary
- 3. Design Considerations
-
4. Configuring Oracle GoldenGate
- GoldenGate parameters
- The GoldenGate instantiation
- 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 Oracle Manager process
- Configuring the downstream mining database
- Summary
- 5. Configuration Options
- 6. Configuring GoldenGate for HA
- 7. Advanced Configuration
- 8. Managing Oracle GoldenGate
-
9. Performance Tuning
- Before tuning GoldenGate
- Tuning data delivery
- Viewing integrated parameters
- Controlling the memory consumption
- Tracing processes to find wait events
- Diagnosing a slow Extract
- Static data dictionary views
- Tuning the network
- Hardware upgrades
- Summary
-
10. Troubleshooting GoldenGate
- Troubleshooting tips
- GoldenGate health check
- The GoldenGate dynamic performance views
- Investigating network issues
- Investigating Oracle errors
- Exception handling
- Handling Oracle Sequences
- Using LOGDUMP
- Upgrading GoldenGate
- Dynamic Rollback
- Summary
- 11. The Future of GoldenGate
- A. GGSCI Commands
- B. GoldenGate Installed Components
- C. Acronyms
- Index
Product information
- Title: Oracle GoldenGate 12c Implementer's Guide
- Author(s):
- Release date: July 2015
- Publisher(s): Packt Publishing
- ISBN: 9781785280474
You might also like
video
Oracle Databases
This course offers a solid foundation in Oracle databases, from the fundamentals of the SQL language …
video
Learning Oracle 12c
In this Oracle 12c training course, expert author Steve Ries will teach you how to everything …
book
Beginning Oracle SQL for Oracle Database 18c: From Novice to Professional
Start developing with Oracle SQL. This book is a one-stop introduction to everything you need to …
book
Oracle SQL*Plus: The Definitive Guide, 2nd Edition
Despite its wide availability and usage, few developers and DBAs have mastered the true power of …