Linked e-resources
Details
Table of Contents
At a Glance; Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Part I: Getting Started; Chapter 1: Introduction to Oracle GoldenGate (OGG); What's So Magical About Oracle GoldenGate?; Types of Replication; Available Replication Options; Advantages of Oracle GoldenGate; When to Use Oracle GoldenGate?; Oracle GoldenGate vs. Streams; Oracle GoldenGate vs. Data Guard; Oracle GoldenGate vs. SharePlex; Oracle GoldenGate 12c New Features; Summary; Chapter 2: Architecture; Overview of the Components; Extract; Data Pump; Replicat; Trails; Collector.
ManagerCheckpoints; Support for Non-Oracle Databases; Supported Topologies; Unidirectional Replication; When to Use Unidirectional Replication?; Bidirectional Replication; Limitations of Bidirectional Configuration; When to Use Bidirectional Replication?; One-to-Many Replication; When to Use One-to-Many Replication?; Many-to-One Replication; When to Use Many-to-One Replication?; Peer-to-Peer Replication; When to Use Peer-to-Peer Replication?; Summary; Chapter 3: Oracle GoldenGate Pre-installation Tasks; Memory Requirements; Disk Space Requirements; Network Requirements.
Configuring Your Database and Server for Oracle GoldenGateEnable Logging for Oracle Databases; Enable Logging for Sybase Databases; Enable Logging for Microsoft SQL Server Databases; Supported Data Types; Supported Data Types for Oracle Databases; Supported Data Types for SYBASE Databases; Supported Data Types for MySQL Databases; Supported Data Types for SQL Server Databases; Supported Data Types for DB2 Databases on LUW; Supported Data Types for DB2 Databases on z/OS; Supported Operations; Database Operations Captured for Oracle Databases; Database Operations Captured on Sybase Databases.
Database Operations Captured on MySQL DatabasesDatabase Operations Captured on SQL Server Databases; Database Operations Captured on DB2 Databases for LUW; Database Operations Captured on Sybase Databases for z/OS; Designing Your GoldenGate Replication Setup; Why Choose Standard Naming Conventions?; Naming Capture and Delivery Process; Know Your Application; Database Privileges for GoldenGate Users; OGG User Permissions in Oracle Databases; OGG User Permissions in Sybase Databases; OGG User Permissions in IBM DB2 Databases; OGG User Permissions in MySQL Databases.
OGG User Permissions in Teradata DatabasesSummary; Chapter 4: Installing Oracle GoldenGate; Download the Installer; Setting Up Environmental Variables; Setting Up Database Logging; Setting Up User Privileges; Installing Oracle GoldenGate on Unix/Linux; Step 1: Log In as the Linux Superuser; Step 2: Navigate to the GoldenGate Directory; Step 3: Copy or FTP the GoldenGate Software File from the Local System or Remote Server; Step 4: Locate the Installer; Step 5: Begin Installation; Step 6: Execute GGSCI; Step 7: Create Subdirectories; Step 8: Configure the Manager Port.
ManagerCheckpoints; Support for Non-Oracle Databases; Supported Topologies; Unidirectional Replication; When to Use Unidirectional Replication?; Bidirectional Replication; Limitations of Bidirectional Configuration; When to Use Bidirectional Replication?; One-to-Many Replication; When to Use One-to-Many Replication?; Many-to-One Replication; When to Use Many-to-One Replication?; Peer-to-Peer Replication; When to Use Peer-to-Peer Replication?; Summary; Chapter 3: Oracle GoldenGate Pre-installation Tasks; Memory Requirements; Disk Space Requirements; Network Requirements.
Configuring Your Database and Server for Oracle GoldenGateEnable Logging for Oracle Databases; Enable Logging for Sybase Databases; Enable Logging for Microsoft SQL Server Databases; Supported Data Types; Supported Data Types for Oracle Databases; Supported Data Types for SYBASE Databases; Supported Data Types for MySQL Databases; Supported Data Types for SQL Server Databases; Supported Data Types for DB2 Databases on LUW; Supported Data Types for DB2 Databases on z/OS; Supported Operations; Database Operations Captured for Oracle Databases; Database Operations Captured on Sybase Databases.
Database Operations Captured on MySQL DatabasesDatabase Operations Captured on SQL Server Databases; Database Operations Captured on DB2 Databases for LUW; Database Operations Captured on Sybase Databases for z/OS; Designing Your GoldenGate Replication Setup; Why Choose Standard Naming Conventions?; Naming Capture and Delivery Process; Know Your Application; Database Privileges for GoldenGate Users; OGG User Permissions in Oracle Databases; OGG User Permissions in Sybase Databases; OGG User Permissions in IBM DB2 Databases; OGG User Permissions in MySQL Databases.
OGG User Permissions in Teradata DatabasesSummary; Chapter 4: Installing Oracle GoldenGate; Download the Installer; Setting Up Environmental Variables; Setting Up Database Logging; Setting Up User Privileges; Installing Oracle GoldenGate on Unix/Linux; Step 1: Log In as the Linux Superuser; Step 2: Navigate to the GoldenGate Directory; Step 3: Copy or FTP the GoldenGate Software File from the Local System or Remote Server; Step 4: Locate the Installer; Step 5: Begin Installation; Step 6: Execute GGSCI; Step 7: Create Subdirectories; Step 8: Configure the Manager Port.