Book description
Master Oracle GoldenGate 11g
Enable highly available, real-time access to enterprise data in heterogeneous environments. Featuring hands-on workshops, Oracle GoldenGate 11g Handbook shows you how to install, configure, and implement this high-performance application. You’ll learn how to replicate data across Oracle databases and other platforms, including MySQL and Microsoft SQL Server, and perform near-zero-downtime migrations and upgrades. Monitoring, performance tuning, and troubleshooting are also discussed in this Oracle Press guide.
- Install and configure Oracle GoldenGate
- Implement Oracle GoldenGate one-way replication
- Configure multitarget and cascading replication
- Use bidirectional replication to build a heterogeneous database infrastructure
- Secure your environment, control and manipulate data, and prevent errors
- Configure Oracle GoldenGate for Oracle Clusterware and Oracle Real Application Clusters
- Use Oracle GoldenGate with MySQL and Microsoft SQL Server
- Perform near-zero-downtime upgrades and migrations
- Use Oracle GoldenGate Monitor and Oracle GoldenGate Director
- Ensure data quality with Oracle GoldenGate Veridata
- Implement nondatabase integration options
Table of contents
- Cover
- About the Author
- Title Page
- Copyright Page
- Contents at a Glance
- Contents
- Acknowledgments
- Introduction
- Chapter 1: Introduction to Oracle GoldenGate 11g and Replication
-
Chapter 2: The Oracle GoldenGate Architecture
- Documentation and Information Please
- Overview of Databases That Support Oracle GoldenGate
-
The Oracle GoldenGate Architecture and Processes
- The Oracle GoldenGate Manager Process
- The Oracle GoldenGate Extract (or Capture) Process
- The Oracle GoldenGate Trail Files
- The Oracle GoldenGate Data Pump Process
- The Oracle GoldenGate Server Collector
- The Oracle GoldenGate Apply (Replicat) Process
- The Oracle GoldenGate Software Command Interface (GGSCI)
- The Oracle GoldenGate Parameter Files
- Data Replication and Latency
- Compatibility Between Different Versions of GoldenGate
- Chapter 3: Installing Oracle GoldenGate
- Chapter 4: Configuring Oracle GoldenGate
- Chapter 5: Implementing Oracle GoldenGate One-Way Replication
- Chapter 6: GoldenGate Multitarget and Cascading Replication
- Chapter 7: GoldenGate Multimaster Replication
- Chapter 8: Advanced Features
- Chapter 9: Oracle GoldenGate and Oracle Real Application Clusters
- Chapter 10: GoldenGate for MySQL
-
Chapter 11: Introducing Oracle GoldenGate for SQL Server
- Installing and Configuring Oracle GoldenGate for SQL Server
- Installing Oracle GoldenGate for SQL Server on Windows
- Configuration
- Managing Oracle GoldenGate for SQL Server
-
Advanced GoldenGate for SQL Server
- Configuring Oracle GoldenGate in a Windows Clustering Environment
- Maintaining the Transaction Log Secondary Truncation Point When Extract Is Stopped
- IDENTITY Property on Columns in Multimaster Configurations
- Making DDL Changes to Existing Tables Configured for OGG
- The ALTARCHIVELOGDEST Extract Parameter
- Chapter 12: Monitoring, Troubleshooting, and Performance Tuning GoldenGate
- Chapter 13: Oracle GoldenGate Monitor and GoldenGate Director
- Chapter 14: Zero-Downtime Upgrades and Migrations Using Oracle GoldenGate
- Chapter 15: Oracle GoldenGate Veridata
-
Chapter 16: Oracle GoldenGate Integration Options
- Using GoldenGate to Create a File for a Database Utility to Use
- Oracle GoldenGate for Flat File
- Installing Oracle GoldenGate Flat File
- The Oracle GoldenGate Flat File Infrastructure
- Types of Flat Files That Can Be Created
- The User Exit Properties File
-
The Writer Process
- Defining the Writers
- Defining the Writer Mode
- Defining the Output File Name
- Defining Rollover Attributes
- Other Writer Output File Property Settings
- Configuring File Data Content Properties
- Including Meta File in Your Datafile Output
- Including Statistics in Your Datafile Output
- Including Statistics in Your Datafile Output
- Other API Interfaces into GoldenGate
- Chapter 17: GoldenGate 11.2 New Features
- Index
Product information
- Title: Oracle GoldenGate 11g Handbook
- Author(s):
- Release date: June 2013
- Publisher(s): McGraw Hill Computing
- ISBN: 9780071790895
You might also like
book
Oracle Data Guard 11g Handbook
Master Oracle Data Guard 11 g Provide superior data protection, availability, and disaster recovery using the …
book
Oracle Database 11g DBA Handbook
The Essential Resource for Oracle DBAs--Fully Updated and Expanded Manage a flexible, highly available Oracle database …
book
Oracle 11g R1/R2 Real Application Clusters Essentials
In this book you’ll find a practical tutorial on configuring, installing, and designing Oracle 11g Real …
book
Oracle RMAN Pocket Reference
Oracle RMAN Pocket Reference is a handy guide for DBAs who intend to use Oracle Recovery …