Table of Contents
- Title and Copyright Information
- Preface
- Changes for Oracle Streams Replication Administrator's Guide
- Part I Configuring Oracle Streams Replication
- 1
Preparing for Oracle Streams Replication
- 1.1 Overview of Oracle Streams Replication
- 1.2
Decisions to Make Before Configuring Oracle Streams Replication
- 1.2.1 Decide Which Type of Replication Environment to Configure
- 1.2.2 Decide Whether to Configure Local or Downstream Capture for the Source Database
- 1.2.3 Decide Whether Changes Are Allowed at One Database or at Multiple Databases
- 1.2.4 Decide Whether the Replication Environment Will Have Nonidentical Replicas
- 1.2.5 Decide Whether the Replication Environment Will Use Apply Handlers
- 1.2.6 Decide Whether to Maintain DDL Changes
- 1.2.7 Decide How to Configure the Replication Environment
- 1.3
Tasks to Complete Before Configuring Oracle Streams Replication
- 1.3.1 Configuring an Oracle Streams Administrator on All Databases
- 1.3.2 Configuring Network Connectivity and Database Links
- 1.3.3 Ensuring That Each Source Database Is In ARCHIVELOG Mode
- 1.3.4 Setting Initialization Parameters Relevant to Oracle Streams
- 1.3.5 Configuring the Oracle Streams Pool
- 1.3.6
Specifying Supplemental Logging
- 1.3.6.1 Required Supplemental Logging in an Oracle Streams Replication Environment
- 1.3.6.2 Specifying Table Supplemental Logging Using Unconditional Log Groups
- 1.3.6.3 Specifying Table Supplemental Logging Using Conditional Log Groups
- 1.3.6.4 Dropping a Supplemental Log Group
- 1.3.6.5 Specifying Database Supplemental Logging of Key Columns
- 1.3.6.6 Dropping Database Supplemental Logging of Key Columns
- 1.3.6.7 Procedures That Automatically Specify Supplemental Logging
- 1.3.7 Configuring Log File Transfer to a Downstream Capture Database
- 1.3.8 Adding Standby Redo Logs for Real-Time Downstream Capture
- 2
Simple Oracle Streams Replication Configuration
- 2.1 Configuring Replication Using the Setup Streams Replication Wizard
- 2.2
Configuring Replication Using the DBMS_STREAMS_ADM Package
- 2.2.1 The Oracle Streams Replication Configuration Procedures
- 2.2.2
Important Considerations for the Configuration Procedures
- 2.2.2.1 Local or Downstream Capture for the Source Database
- 2.2.2.2 Perform Configuration Actions Directly or With a Script
- 2.2.2.3 Oracle Streams Components Configured by These Procedures
- 2.2.2.4 One-Way or Bi-Directional Replication
- 2.2.2.5 Data Definition Language (DDL) Changes
- 2.2.2.6 Instantiation
- 2.2.3 Creating the Required Directory Objects
- 2.2.4 Examples That Configure Two-Database Replication with Local Capture
- 2.2.5 Examples That Configure Two-Database Replication with Downstream Capture
- 2.2.6 Example That Configures Two-Database Replication with Synchronous Captures
- 2.2.7 Example That Configures Hub-and-Spoke Replication
- 2.2.8 Monitoring Oracle Streams Configuration Progress
- 3 Flexible Oracle Streams Replication Configuration
- 4
Adding to an Oracle Streams Replication Environment
- 4.1 About Adding to an Oracle Streams Replication Environment
- 4.2 Adding Multiple Components Using a Single Procedure
- 4.3 Adding Components Individually in Multiple Steps
- 5
Configuring Implicit Capture
- 5.1 Configuring a Capture Process
- 5.2 Configuring Synchronous Capture
- 6 Configuring Queues and Propagations
- 7 Configuring Implicit Apply
- 8
Instantiation and Oracle Streams Replication
- 8.1 Overview of Instantiation and Oracle Streams Replication
- 8.2
Capture Rules and Preparation for Instantiation
- 8.2.1 DBMS_STREAMS_ADM Package Procedures Automatically Prepare Objects
- 8.2.2 When Preparing for Instantiation Is Required
- 8.2.3 Supplemental Logging Options During Preparation for Instantiation
- 8.2.4
Preparing Database Objects for Instantiation at a Source Database
- 8.2.4.1
Preparing Tables for Instantiation
- 8.2.4.1.1 Preparing a Table for Instantiation Using DBMS_STREAMS_ADM When a Capture Process Is Used
- 8.2.4.1.2 Preparing a Table for Instantiation Using DBMS_CAPTURE_ADM When a Capture Process Is Used
- 8.2.4.1.3 Preparing Tables for Instantiation Using DBMS_STREAMS_ADM When a Synchronous Capture Is Used
- 8.2.4.1.4 Preparing Tables for Instantiation Using DBMS_CAPTURE_ADM When a Synchronous Capture Is Used
- 8.2.4.2 Preparing the Database Objects in a Schema for Instantiation
- 8.2.4.3 Preparing All of the Database Objects in a Database for Instantiation
- 8.2.4.1
Preparing Tables for Instantiation
- 8.2.5 Aborting Preparation for Instantiation at a Source Database
- 8.3 Oracle Data Pump and Oracle Streams Instantiation
- 8.4 Recovery Manager (RMAN) and Oracle Streams Instantiation
- 8.5 Setting Instantiation SCNs at a Destination Database
- 8.6 Monitoring Instantiation
- 9
Oracle Streams Conflict Resolution
- 9.1 About DML Conflicts in an Oracle Streams Environment
- 9.2 Conflict Types in an Oracle Streams Environment
- 9.3 Conflicts and Transaction Ordering in an Oracle Streams Environment
- 9.4 Conflict Detection in an Oracle Streams Environment
- 9.5 Conflict Avoidance in an Oracle Streams Environment
- 9.6 Conflict Resolution in an Oracle Streams Environment
- 9.7 Managing Oracle Streams Conflict Detection and Resolution
- 9.8 Monitoring Conflict Detection and Update Conflict Handlers
- 10
Oracle Streams Tags
- 10.1 Introduction to Tags
- 10.2 Tags and Rules Created by the DBMS_STREAMS_ADM Package
- 10.3 Tags and Online Backup Statements
- 10.4 Tags and an Apply Process
- 10.5 Oracle Streams Tags in a Replication Environment
- 10.6 Managing Oracle Streams Tags
- 10.7 Monitoring Oracle Streams Tags
- 11
Oracle Streams Heterogeneous Information Sharing
- 11.1
Oracle to Non-Oracle Data Sharing with Oracle Streams
- 11.1.1 Change Capture and Staging in an Oracle to Non-Oracle Environment
- 11.1.2
Change Apply in an Oracle to Non-Oracle Environment
- 11.1.2.1
Apply Process Configuration in an Oracle to Non-Oracle Environment
- 11.1.2.1.1 Before Creating an Apply Process in an Oracle to Non-Oracle Environment
- 11.1.2.1.2 Apply Process Creation in an Oracle to Non-Oracle Environment
- 11.1.2.1.3 Substitute Key Columns in an Oracle to Non-Oracle Heterogeneous Environment
- 11.1.2.1.4 Parallelism in an Oracle to Non-Oracle Heterogeneous Environment
- 11.1.2.1.5 Procedure DML Handlers in an Oracle to Non-Oracle Heterogeneous Environment
- 11.1.2.1.6 Message Handlers in an Oracle to Non-Oracle Heterogeneous Environment
- 11.1.2.1.7 Error and Conflict Handlers in an Oracle to Non-Oracle Heterogeneous Environment
- 11.1.2.2 Data Types Applied at Non-Oracle Databases
- 11.1.2.3 Types of DML Changes Applied at Non-Oracle Databases
- 11.1.2.4 Instantiation in an Oracle to Non-Oracle Environment
- 11.1.2.1
Apply Process Configuration in an Oracle to Non-Oracle Environment
- 11.1.3 Transformations in an Oracle to Non-Oracle Environment
- 11.1.4 Messaging Gateway and Oracle Streams
- 11.1.5 Error Handling in an Oracle to Non-Oracle Environment
- 11.1.6 Example Oracle to Non-Oracle Streams Environment
- 11.2 Non-Oracle to Oracle Data Sharing with Oracle Streams
- 11.3 Non-Oracle to Non-Oracle Data Sharing with Oracle Streams
- 11.1
Oracle to Non-Oracle Data Sharing with Oracle Streams
- 1
Preparing for Oracle Streams Replication
- Part II Administering Oracle Streams Replication
- 12
Managing Oracle Streams Replication
- 12.1 About Managing Oracle Streams
- 12.2 Tracking LCRs Through a Stream
- 12.3 Splitting and Merging an Oracle Streams Destination
- 12.4 Changing the DBID or Global Name of a Source Database
- 12.5 Resynchronizing a Source Database in a Multiple-Source Environment
- 12.6 Performing Database Point-in-Time Recovery in an Oracle Streams Environment
- 12.7 Running Flashback Queries in an Oracle Streams Replication Environment
- 12.8 Recovering from Operation Errors
- 13
Comparing and Converging Data
- 13.1 About Comparing and Converging Data
- 13.2 Other Documentation About the DBMS_COMPARISON Package
- 13.3 Quick Start: A Simple Compare and Converge Scenario
- 13.4 Preparing To Compare and Converge a Shared Database Object
- 13.5 Diverging a Database Object at Two Databases to Complete Examples
- 13.6
Comparing a Shared Database Object at Two Databases
- 13.6.1 Comparing a Subset of Columns in a Shared Database Object
- 13.6.2 Comparing a Shared Database Object without Identifying Row Differences
- 13.6.3 Comparing a Random Portion of a Shared Database Object
- 13.6.4 Comparing a Shared Database Object Cyclically
- 13.6.5 Comparing a Custom Portion of a Shared Database Object
- 13.6.6 Comparing a Shared Database Object That Contains CLOB or BLOB Columns
- 13.7
Viewing Information About Comparisons and Comparison Results
- 13.7.1 Viewing General Information About the Comparisons in a Database
- 13.7.2 Viewing Information Specific to Random and Cyclic Comparisons
- 13.7.3 Viewing the Columns Compared by Each Comparison in a Database
- 13.7.4 Viewing General Information About Each Scan in a Database
- 13.7.5 Viewing the Parent Scan ID and Root Scan ID for Each Scan in a Database
- 13.7.6 Viewing Detailed Information About the Row Differences Found in a Scan
- 13.7.7 Viewing Information About the Rows Compared in Specific Scans
- 13.8 Converging a Shared Database Object
- 13.9 Rechecking the Comparison Results for a Comparison
- 13.10 Purging Comparison Results
- 13.11 Dropping a Comparison
- 13.12 Using DBMS_COMPARISON in an Oracle Streams Replication Environment
- 14
Managing Logical Change Records (LCRs)
- 14.1 Requirements for Managing LCRs
- 14.2 Constructing and Enqueuing LCRs
- 14.3 Executing LCRs
- 14.4 Managing LCRs Containing LOB Columns
- 14.5 Managing LCRs Containing LONG or LONG RAW Columns
- 12
Managing Oracle Streams Replication
- Part III Oracle Streams Replication Best Practices
- 15
Best Practices for Oracle Streams Replication Databases
- 15.1 Best Practices for Oracle Streams Database Configuration
- 15.2
Best Practices for Oracle Streams Database Operation
- 15.2.1 Follow the Best Practices for the Global Name of an Oracle Streams Database
- 15.2.2 Monitor Performance and Make Adjustments When Necessary
- 15.2.3 Monitor Capture Process's and Synchronous Capture's Queues for Size
- 15.2.4 Follow the Oracle Streams Best Practices for Backups
- 15.2.5 Adjust the Automatic Collection of Optimizer Statistics
- 15.2.6 Check the Alert Log for Oracle Streams Information
- 15.2.7 Follow the Best Practices for Removing an Oracle Streams Configuration at a Database
- 15.3 Best Practices for Oracle Real Application Clusters and Oracle Streams
- 16 Best Practices for Capture
- 17 Best Practices for Propagation
- 18 Best Practices for Apply
- 15
Best Practices for Oracle Streams Replication Databases
- Index