更新时间：2021-07-16 13:43:36
封面
版权信息
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Chapter 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
Chapter 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
Chapter 3. Design Considerations
Replication methods
Networking
Non-functional requirements
Hardware considerations
Changed data management
Changed data recovery
Chapter 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
Chapter 5. Configuration Options
Using BATCHSQL
Data compression
Security features
Event-based processing
Bidirectional configuration options
The DDL support
Heterogeneous environments
Oracle Streams to GoldenGate Migration
Chapter 6. Configuring GoldenGate for HA
GoldenGate on RAC
GoldenGate on Exadata
Failover
Chapter 7. Advanced Configuration
Mapping your data
Data selection and filtering
Data transformation
DDL support
The SQLEXEC parameter
Using and defining macros
User tokens
User exits
Using logic in the data replication
Replicating data between different GoldenGate versions
Licensing
Oracle Data Integrator 12c
Chapter 8. Managing Oracle GoldenGate
The Oracle Management Pack for GoldenGate
Command-level security
Managing the trail file
Managing the process startup
Managing TCP/IP errors
Reporting and statistics
Chapter 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
Chapter 10. Troubleshooting GoldenGate
Troubleshooting tips
GoldenGate health check
The GoldenGate dynamic performance views
Investigating network issues
