Book Image

Oracle Goldengate 12c Implementers Guide

By : John P Jeffries
Book Image

Oracle Goldengate 12c Implementers Guide

By: John P Jeffries

Overview of this book

The book is aimed at Oracle database administrators, project managers, and solution architects who wish to extend their knowledge of GoldenGate. The reader is assumed to be familiar with Oracle databases. No knowledge of GoldenGate is required.

Related Content you might be interested in

Current Title:

Small book image
Oracle Goldengate 12c Implementers Guide
John P Jeffries
Jul, 2015 | 422 pages
No titles found
Table of Contents (16 chapters)
Preface
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Free Chapter
1
1. Getting Started
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
2. Installing and Preparing GoldenGate
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
3. Design Considerations
3. Design Considerations
Replication methods
Networking
Non-functional requirements
Hardware considerations
Changed data management
Changed data recovery
Summary
4
4. Configuring Oracle GoldenGate
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
5. Configuration Options
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
Summary
6
6. Configuring GoldenGate for HA
6. Configuring GoldenGate for HA
GoldenGate on RAC
GoldenGate on Exadata
Failover
7
7. Advanced Configuration
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
Summary
8
8. Managing Oracle GoldenGate
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
Summary
9
9. Performance Tuning
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
10. Troubleshooting GoldenGate
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
11. The Future of GoldenGate
11. The Future of GoldenGate
Cloud computing
GoldenGate and Big Data
Deprecation of the nonCDB architecture
Oracle GoldenGate 12c Release 2
Summary
12
A. GGSCI Commands
A. GGSCI Commands
13
B. GoldenGate Installed Components
B. GoldenGate Installed Components
14
C. Acronyms
C. Acronyms
15
Index
Index

The Oracle Management Pack for GoldenGate

The Oracle Management Pack for GoldenGate comprises of the following three software products, each of which requires a license in addition to the Oracle GoldenGate 12c license:

  • Oracle Enterprise Manager 12c Plug-in: This provides management, monitoring, and alerting on GoldenGate components

  • Oracle GoldenGate Monitor 12c: This is a standalone product dedicated to managing, monitoring, and alerting on GoldenGate components

  • Oracle GoldenGate Director 12c: This is a standalone product that provides basic management, monitoring, and alerting on legacy GoldenGate deployments

We will focus on the GoldenGate Monitor product because this has received a number of new features in the 12c version that enhance, manage, and monitor Oracle GoldenGate.

Oracle GoldenGate Monitor 12c

Oracle GoldenGate Monitor was first released by Oracle Corporation in the 11g Release 1 version to replace the aging Oracle GoldenGate Director product. However, Oracle GoldenGate Director...

Previous Section
End of Section 1
Next Section