Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction to Data Replication and Integration

• About This Guide
  • Before Using This Guide
  • What This Guide Is Not
• About Data Replication and Integration
• About Data Replication and Integration Options
  • When to Access and Modify Information in Multiple Databases
  • When to Replicate Data with Oracle Streams
  • When to Replicate Data with Materialized Views
  • When to Send Messages Between Databases

2 Common Data Replication and Integration Tasks

• Setting the GLOBAL_NAMES Initialization Parameter to TRUE
• Example: Creating an Oracle Streams Administrator
  • Example: Creating the Tablespace for the Oracle Streams Administrator
  • Example: Creating the Oracle Streams Administrator
• Creating an ANYDATA Queue
• Example: Creating a Database Link

3 Accessing and Modifying Information in Multiple Databases

• About Accessing and Modifying Information in Multiple Databases
  • About Distributed SQL
  • About Synonyms and Location Transparency
  • About Accessing and Modifying Information in Non-Oracle Databases
  • About Stored Procedures
• Preparing to Access and Modify Information in Multiple Oracle Databases
• Example: Querying Multiple Oracle Databases
• Example: Modifying Data in Multiple Oracle Databases
• Example: Running a Stored Procedure in a Remote Oracle Database
• Working with Data in Non-Oracle Databases
  • Configuring Oracle Databases to Work with Non-Oracle Databases
  • Best Practices for Working with Non-Oracle Databases

4 Replicating Data Using Oracle Streams

• About Oracle Streams Replication
  • About Change Capture
    • About Change Capture with a Capture Process
    • About Change Capture with a Synchronous Capture
  • About Change Propagation Between Databases
  • About Change Apply
  • About Rules for Controlling the Behavior of Capture, Propagation, and Apply
  • About Rule-Based Transformations for Nonidentical Copies
  • About Supplemental Logging
  • About Conflicts and Conflict Resolution
  • About Tags for Avoiding Change Cycling
  • About the Common Types of Oracle Streams Replication Environments
    • About Hub-And-Spoke Replication Environments
    • About N-Way Replication Environments
• Preparing for Oracle Streams Replication
• Example: Configuring Latest Time Conflict Resolution for a Table
• Example: Configuring Read-Only Hub-and-Spoke Replication with Local Capture
• Example: Configuring Read-Only Hub-and-Spoke Replication with Downstream Capture
• Example: Configuring Read/Write Hub-and-Spoke Replication with Capture Processes
• Example: Configuring Read/Write Hub-and-Spoke Replication with Synchronous Captures

5 Administering an Oracle Streams Replication Environment

• Managing an Oracle Streams Replication Environment
  • Managing Capture Processes
    • Starting and Stopping a Capture Process
    • Setting a Capture Process Parameter
  • Enabling and Disabling a Propagation
  • Managing Apply Processes
    • Starting and Stopping an Apply Process
    • Setting an Apply Process Parameter
• Monitoring an Oracle Streams Replication Environment
  • Displaying an Overview of the Replication Components at a Database
  • Displaying the Topology of the Oracle Streams Replication Environment at a Database
  • Monitoring Capture Processes
    • Viewing Information About a Capture Process
    • Viewing Statistics for a Capture Process
  • Monitoring Propagations
    • Viewing Information About a Propagation
    • Viewing Statistics for a Propagation
  • Monitoring Apply Processes
    • Viewing Information About an Apply Process
    • Viewing Statistics for an Apply Process
    • Displaying the Configured Update Conflict Handlers
  • Viewing Buffered Queue Statistics
  • Displaying the Amount of Time Between Capture and Apply
• Troubleshooting an Oracle Streams Replication Environment
  • Responding to Automated Alerts in Enterprise Manager
    • Capture Aborts Alert
    • Propagation Aborts Alert
    • Apply Aborts Alert
    • Apply Error Alert
    • Oracle Streams Pool Alert
  • Managing Apply Errors
    • Correcting Apply Errors in Database Objects
    • Retrying or Deleting Apply Error Transactions
  • Managing a Replication Environment When a Destination Is Unavailable

6 Extending an Oracle Streams Replication Environment

• About Extending an Oracle Streams Replication Environment
• Example: Adding Database Objects to a Replication Environment
• Example: Adding Databases to a Replication Environment

7 Replicating Data Using Materialized Views

• About Materialized View Replication
  • About Master Sites, Master Tables, and Materialized View Sites
  • About Materialized View Refresh
  • About Refresh Groups
• Preparing for Materialized View Replication
• Configuring Materialized View Sites
• Configuring Materialized View Logs at the Master Site
• Replicating Read-Only Data Using Materialized Views
  • About Replicating Read-Only Data Using Materialized Views
  • Example: Configuring Read-Only Data Replication Using Materialized Views
• Replicating Read/Write Data Using Materialized Views
  • About Replicating Read/Write Data Using Materialized Views
    • About Replication Groups and Updatable Materialized Views
    • About Scheduled Links and Deferred Transactions
    • About Conflicts and Updatable Materialized Views
  • Configuring Replication of Read/Write Data Using Materialized Views
• Configuring a Refresh Group

8 Administering a Materialized View Replication Environment

• Managing a Materialized View Replication Environment
  • Refreshing Materialized Views
    • Refreshing a Refresh Group
    • Refreshing a Materialized View
  • Adding Materialized Views to a Refresh Group
  • Dropping a Materialized View
  • Example: Cleaning Up Materialized View Support at a Master Site
• Monitoring a Materialized View Replication Environment
  • Viewing an Overview of the Replication Components at a Database
  • Viewing Information About Materialized Views
  • Determining Which Materialized Views Are Currently Refreshing
  • Viewing Information About Materialized View Groups
  • Viewing Information About Deferred Transactions for Updatable Materialized Views
  • Viewing Information About Refresh Groups
  • Viewing Materialized View Logs at a Master Site
  • Viewing the Materialized Views for a Master Site
• Troubleshooting a Materialized View Replication Environment
  • Correcting Problems with Materialized View Refresh
  • Preventing Materialized View Logs From Becoming Too Large

9 Sending Messages Using Oracle Streams Advanced Queuing

• About Messaging
  • About Message Ordering
  • About Message Modes
  • About Message Notifications
  • About Propagations
  • About Oracle Messaging Gateway
• Preparing for Messaging
• Example: Sending Messages Between Oracle Databases
  • Task 1: Creating the Message Type at Each Database
  • Task 2: Configuring the Queues and Propagation Between Them
  • Task 3: Configuring a Message Enqueuing Mechanism
  • Task 4: Configuring a Messaging Client to Dequeue Messages
  • Task 5: Enqueuing Messages
  • Task 6: Dequeuing Messages
• Example: Configuring Message Notifications
  • Task 1: Creating the Message Type
  • Task 2: Configuring a Queue and a Messaging Client
  • Task 3: Configuring a Mechanism for Dequeuing Messages
  • Task 4: Configuring Message Notification
  • Task 5: Enqueuing Messages and Checking for Message Notification
• Modifying Queues
• Modifying Queue Tables
• Modifying Propagations
• Monitoring a Messaging Environment
  • Viewing the Messages in a Queue
  • Viewing Persistent Queue Statistics
  • Viewing the Consumers Who Can Dequeue Messages
• Troubleshooting a Messaging Environment
  • Correcting an ORA-01031 Error While Enqueuing or Dequeuing Messages
  • Correcting an ORA-24033 Error While Enqueuing Messages
  • Correcting an ORA-02019 Error for a Propagation
  • Understanding Why Dequeued Messages Remain in a Queue

10 Comparing and Converging Data

• About Comparing and Converging Data in Different Databases
• Example: Preparing to Compare and Converge Data
• Example: Comparing Data in Two Different Databases
• Example: Converging Divergent Data

Index