Oracle GoldenGate 12c Implementer's Guide

Leverage the power of real-time data access for designing, building, and tuning your GoldenGate Enterprise
Preview in Mapt

Oracle GoldenGate 12c Implementer's Guide

John P Jeffries

1 customer reviews
Leverage the power of real-time data access for designing, building, and tuning your GoldenGate Enterprise
Mapt Subscription
FREE
$29.99/m after trial
eBook
$10.00
RRP $47.99
Save 79%
Print + eBook
$59.99
RRP $59.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$10.00
$59.99
$29.99 p/m after trial
RRP $47.99
RRP $59.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Frequently bought together


Oracle GoldenGate 12c Implementer's Guide Book Cover
Oracle GoldenGate 12c Implementer's Guide
$ 47.99
$ 10.00
Professional Oracle Mobile Book Cover
Professional Oracle Mobile
$ 39.99
$ 10.00
Buy 2 for $20.00
Save $67.98
Add to Cart

Book Details

ISBN 139781785280474
Paperback422 pages

Book Description

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.

Table of Contents

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
Summary
Chapter 3: Design Considerations
Replication methods
Networking
Non-functional requirements
Hardware considerations
Changed data management
Changed data recovery
Summary
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
Summary
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
Summary
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
Summary
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
Summary
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
Summary
Chapter 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
Chapter 11: The Future of GoldenGate
Cloud computing
GoldenGate and Big Data
Deprecation of the nonCDB architecture
Oracle GoldenGate 12c Release 2
Summary

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

Authors

Table of Contents

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
Summary
Chapter 3: Design Considerations
Replication methods
Networking
Non-functional requirements
Hardware considerations
Changed data management
Changed data recovery
Summary
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
Summary
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
Summary
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
Summary
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
Summary
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
Summary
Chapter 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
Chapter 11: The Future of GoldenGate
Cloud computing
GoldenGate and Big Data
Deprecation of the nonCDB architecture
Oracle GoldenGate 12c Release 2
Summary

Book Details

ISBN 139781785280474
Paperback422 pages
Read More
From 1 reviews

Read More Reviews

Recommended for You

Oracle Goldengate 11g Complete Cookbook Book Cover
Oracle Goldengate 11g Complete Cookbook
$ 41.99
$ 10.00
Oracle Enterprise Manager 12c Administration Cookbook Book Cover
Oracle Enterprise Manager 12c Administration Cookbook
$ 29.99
$ 10.00
Getting Started with Oracle WebLogic Server 12c: Developer’s Guide Book Cover
Getting Started with Oracle WebLogic Server 12c: Developer’s Guide
$ 32.99
$ 10.00
Oracle Data Guard 11gR2 Administration : Beginner's Guide  Book Cover
Oracle Data Guard 11gR2 Administration : Beginner's Guide
$ 35.99
$ 10.00
Oracle SQL Developer Book Cover
Oracle SQL Developer
$ 43.99
$ 10.00
Oracle Database 11gR2 Performance Tuning Cookbook Book Cover
Oracle Database 11gR2 Performance Tuning Cookbook
$ 32.99
$ 10.00