This is a test
- 422 pages
- English
- ePUB (mobile friendly)
- Available on iOS & Android
eBook - ePub
Oracle GoldenGate 12c Implementer's Guide
Book details
Book preview
Table of contents
Citations
About This Book
About This Book
- Orchestrate the rich features of GoldenGate 12c and exploit the performance-enhancing features and manageability in your Enterprise environment
- Master data integration techniques to empower your organisation's readiness to migrate to cloud technologies quickly and easily
- An easy-to-follow step-by-step guide full of hands-on examples that offer a solid foundation of real-time data integration and replication in heterogeneous IT environments
Who This Book Is For
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.
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
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.
Frequently asked questions
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes, you can access Oracle GoldenGate 12c Implementer's Guide by John P Jeffries in PDF and/or ePUB format, as well as other popular books in Computer Science & Bioinformatics. We have over one million books available in our catalogue for you to explore.
Information
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
Support files, eBooks, discount offers, and more
Why subscribe?
Free access for Packt account holders
Instant updates on new Packt books
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Downloading the example code
Errata
Piracy
Questions
1. Getting Started
What is GoldenGate?
Oracle GoldenGate evolution
Oracle GoldenGate solutions
Oracle GoldenGate technology overview
Extract – the capture process
Trail files
Data pump
Server collector
Replicat – the apply process
The Manager process
GGSCI
Process data flow
Oracle GoldenGate architecture
Classic configurations
One-to-one architecture
One-to-many architecture
Many-to-one architecture
Cascading
Bidirectional – active-active
Bidirectional – active-passive
New configurations
Oracle Data Integrator
Oracle Big Data
12c new features
Integrated capture
Integrated Replicat
Downstream capture
Installation
Upgrading to 12c
Multitenant database replication
Coordinated Delivery
Enhanced event-based processing
Enhanced security
Conflict Detection and Resolution
Dynamic Rollback
Streams to GoldenGate migration
Improved management and monitoring
Oracle Management Pack
Oracle GoldenGate Veridata
Supported platforms and databases
Oracle GoldenGate topology
Process topology
The rules
Position
Statistics
Design considerations
Choosing a solution
Network
Database schema
What to replicate?
Object mapping and data selection
Initial load
CSN coordination
Trail file format
Summary
2. Installing and Preparing GoldenGate
Prerequisites
The GoldenGate certification matrix
Downloading the software
Software requirements
Hardware requirements
Memory
CPU
Network
Disk
The Oracle virtual machine
The software installation
Installing GoldenGate using the OUI
Unpacking the media
Enabling the X server
Running the installer
Performing a silent installation
The subdirectories
br
dircrd
dirchk
dirdat
dirdef
dirpcs
dirprm
dirrpt
dirsql
dirtmp
dirwlt
Preparing the environment
Preparing the 12c container database for data replication
Enabling archive log mode
Enabling supplemental logging
Creating GoldenGate admin user
Enabling the Flashback Query
Enabling transaction data capture
Preparing the 11g database for replication
Enabling the archive log mode
Creating the GoldenGate admin user
Enabling the transaction data capture
Preparing the operating system
Creating the initial configuration
Configuring the Manager process
The capture process
Creating the capture process
Registering the capture process in a 12c container database
Registering the capture process in a 11g database
The data pump process
Starting the capture process
The apply process
Creating the GoldenGate admin user on the target database
Registering the Replicat process in the target database
Creating and starting the apply process
The configuration summary
Patching the GoldenGate home
GoldenGate deinstallation from Linux/Unix
Summary
3. Design Considerations
Replication methods
Active-active replication
Active-passive replication
Cascading
Downstream capture
Extract Load and Transform (E-LT)
Networking
Surviving network outages
Redundant networks
NIC teaming
Non-functional requirements
Performance
Availability
Security
Backup and recovery
Support
Hardware considerations
Computing architectures
Grid computing
Single server
Clusters
Cloud computing
Machines
The x86-64 Linux server
The database machine
Scaling up and out
Changed data management
Integrated capture and delivery
Classic mode
Coordinated mode
DDL replication
Changed data recovery
Point-in-time recovery (PITR)
Oracle Recovery Manager (RMAN)
Flashback
SAN Snapshot
Summary
4. Configuring Oracle GoldenGate
GoldenGate parameters
The GoldenGate instantiation
Choosing an instantiation method
File to Replicat
Extract parameters
Replicat parameters
File to Database Utility
Extract parameters
Replicat parameters
Direct Load
Extract parameters
Replicat parameters
Direct Bulk Load
Extract parameters
Replicat parameters
Performing the initial load
The example architecture
Direct Load instantiation
Configuring initial data capture
Configuring change data capture
The configuration summary
Creating the configuration for multitenant databases
Creating the configuration for nonCDB databases
Configuring change delivery
Testing change data capture and delivery
Stop...
Table of contents
- Oracle GoldenGate 12c Implementer's Guide