Replication Administrator’s Guide Streams Administrators
User Manual:
Open the PDF directly: View PDF
Page Count: 461 [warning: Documents this large are best viewed by clicking the View PDF Link!]
- Contents
- 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.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