Skip Headers
Oracle® Database 2 Day + Data Replication and Integration Guide
11g Release 1 (11.1)
Part Number B28324-02
Home
Book List
Index
Master Index
Contact Us
Next
View PDF
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 Features
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 Two-Database Replication Environments
About Hub-And-Spoke Replication Environments
About N-Way Replication Environments
About the Oracle Streams Replication Configuration Procedures
About Key Oracle Streams Supplied PL/SQL Packages and Data Dictionary Views
About Key Oracle Streams Supplied PL/SQL Packages
About Key Oracle Streams Data Dictionary Views
Preparing for Oracle Streams Replication
Configuring Oracle Streams Replication: Examples
Example: Configuring Two-Database Replication with Local Capture Processes
Example: Configuring Two-Database Replication with a Downstream Capture Process
Example: Configuring Hub-and-Spoke Replication with Local Capture Processes
Example: Configuring Two-Database Replication with Synchronous Captures
Example: Configuring Latest Time Conflict Resolution for a Table
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