Contents

Title and Copyright Information

Preface

Documentation Accessibility

Related Documents

Part I Configuring Your Replication Environment

1 Overview of Replication

Overview of Creating a Replication Environment

Before You Start

2 Create Replication Site

Overview of Setting Up Replication Sites

Setting Up Master Sites

Setting Up orc1.world

Setting Up orc2.world

Setting Up orc3.world

Creating Scheduled Links Between the Master Sites

Setting Up Materialized View Sites

Setting Up mv1.world

Setting Up mv2.world

3 Create a Master Group

Overview of Creating a Master Group

Before You Start

Creating a Master Group

4 Create a Deployment Template

Oracle Deployment Templates Concepts

Before Creating the Deployment Template

Creating a Deployment Template

Packaging a Deployment Template for Instantiation

Packaging a Deployment Template

Packaging a Deployment Template for Offline Instantiation

Packaging a Deployment Template for Online Instantiation

Saving an Instantiation Script to File

Distributing Instantiation Files

Instantiating a Deployment Template

Refreshing a Refresh Group After Instantiation

5 Create Materialized View Group

Overview of Creating a Materialized View Group

Creating a Materialized View Group

Creating the Materialized View Group at mv1.world

Creating the Materialized View Group at mv2.world

6 Configure Conflict Resolution

Preparing for Conflict Resolution

Creating Conflict Resolution Methods for Update Conflicts

Overwrite and Discard Conflict Resolution Methods

Minimum and Maximum Conflict Resolution Methods

Timestamp Conflict Resolution Methods

Additive and Average Conflict Resolution Methods

Priority Groups Conflict Resolution Methods

Site Priority Conflict Resolution Methods

Creating Conflict Resolution Methods for Uniqueness Conflicts

Creating Conflict Avoidance Methods for Delete Conflicts

Using Dynamic Ownership Conflict Avoidance

Locating the Owner of a Row

Obtaining Ownership

Applying the Change

Auditing Successful Conflict Resolution

Collecting Conflict Resolution Statistics

Viewing Conflict Resolution Statistics

Canceling Conflict Resolution Statistics

Clearing Statistics Information

Part II Managing and Monitoring Your Replication Environment

7 Managing a Master Replication Environment

Changing the Master Definition Site

Option 1: All Master Sites Are Available

Option 2: The Old Master Definition Site Is Not Available

Adding New Master Sites

Adding New Master Sites Without Quiescing the Master Group

Using Full Database Export/Import or Change-Based Recovery

Using Object-Level Export/Import

Adding New Master Sites to a Quiesced Master Group

Adding New Master Sites Using the ADD_MASTER_DATABASE Procedure

Adding New Master Sites with Offline Instantiation Using Export/Import

Removing a Master Site from a Master Group

Removing an Unavailable Master Site

Updating the Comments Fields in Data Dictionary Views

Using Procedural Replication

Restrictions on Procedural Replication

User-Defined Types and Procedural Replication

Serializing Transactions

Generating Support for Replicated Procedures

8 Managing a Materialized View Replication Environment

Refreshing Materialized Views

Changing a Materialized View Group's Master Site

Dropping Materialized View Groups and Objects

Dropping a Materialized View Group Created with a Deployment Template

Using the Public Version of DROP_SITE_INSTANTIATION

Using the Private Version of DROP_SITE_INSTANTIATION

Dropping a Materialized View Group or Objects Created Manually

Dropping a Materialized View Group Created Manually

Dropping Objects at a Materialized View Site

Cleaning Up a Master Site or Master Materialized View Site

Cleaning Up After Dropping a Materialized View Group

Cleaning Up Individual Materialized View Support

Managing Materialized View Logs

Altering Materialized View Logs

Altering Materialized View Log Storage Parameters

Altering a Materialized View Log to Add Columns

Managing Materialized View Log Space

Purging Rows from a Materialized View Log

Truncating a Materialized View Log

Reorganizing Master Tables that Have Materialized View Logs

Reorganization Notification

Truncating Masters

Methods of Reorganizing a Database Table

Dropping a Materialized View Log

Performing an Offline Instantiation of a Materialized View Site Using Export/Import

Using a Group Owner for a Materialized View Group

9 Managing Replication Objects and Queues

Altering a Replicated Object

Altering a Replicated Object in a Quiesced Master Group

Modifying Tables without Replicating the Modifications

Disabling Replication

Reenabling Replication

Ensuring that Replicated Triggers Fire Only Once

Converting a LONG Column to a LOB Column in a Replicated Table

Determining Differences Between Replicated Tables

Using the DIFFERENCES Procedure

Using the RECTIFY Procedure

Managing the Deferred Transactions Queue

Pushing the Deferred Transaction Queue

Purging the Deferred Transaction Queue

Using the ANYDATA Type to Determine the Value of an Argument in a Deferred Call

Managing the Error Queue

Reexecuting Error Transaction as the Receiver

Reexecuting Error Transaction as Alternate User

10 Monitoring a Replication Environment

Monitoring Master Replication Environments

Monitoring Master Sites

Listing General Information About a Master Site

Monitoring Master Groups

Listing the Master Sites Participating in a Master Group

Listing General Information About Master Groups

Monitoring Masters

Listing Information About Materialized Views Based on a Master

Listing Information About the Materialized View Logs at a Master

Listing the Materialized Views that Use a Materialized View Log

Listing Information About the Deployment Templates at a Master

Monitoring Materialized View Sites

Listing General Information About a Materialized View Site

Listing General Information About Materialized View Groups

Listing Information About Materialized Views

Listing Master Information For Materialized Views

Listing the Properties of Materialized Views

Listing Information About the Refresh Groups at a Materialized View Site

Determining the Job ID for Each Refresh Job at a Materialized View Site

Determining Which Materialized Views Are Currently Refreshing

Monitoring Administrative Requests

Listing General Information About Administrative Requests

Determining the Cause of Administrative Request Errors

Listing General Information About the Job that Executes Administrative Requests

Checking the Definition of Each do_deferred_repcat_admin Job

Monitoring the Deferred Transactions Queue

Monitoring Transaction Propagation

Listing the Number of Deferred Transactions for Each Destination Master Site

Listing General Information About the Push Jobs at a Replication Site

Determining the Next Start Time and Interval for the Push Jobs

Determining the Total Number of Transactions Queued for Propagation

Monitoring Purges of Successfully Propagated Transactions

Listing General Information About the Purge Job

Checking the Definition of the Purge Job

Determining the Amount of Time Since the Last Purge

Determining the Total Number of Purged Transactions

Monitoring the Error Queue

Listing General Information About the Error Transactions at a Replication Site

Determining the Percentage of Error Transactions

Listing the Number of Error Transactions from Each Origin Master Site

Listing the Error Messages for the Error Transactions at a Replication Site

Determining the Error Operations at a Replication Site

Monitoring Performance in a Replication Environment

Tracking the Average Number of Row Changes in a Replication Transaction

Tracking the Rate of Transactions Entering the Deferred Transactions Queue

Determining the Average Network Traffic Created to Propagate a Transaction

Determining the Average Amount of Time to Apply Transactions at Remote Sites

Determining the Percentage of Time the Parallel Propagation Job Spends Sleeping

Clearing the Statistics for a Remote Master Site in the DEFSCHEDULE View

Monitoring Parallel Propagation of Deferred Transactions Using V$REPLPROP

Determining the Databases to Which You Are Propagating Deferred Transactions

Determining the Transactions Currently Being Propagated to a Remote Master

Part III Replication Management API Packages Reference

11 Introduction to the Replication Management API Reference

Examples of Using Oracle's Replication Management API

Issues to Consider When Using the Replication Management API

The Replication Management Tool and the Replication Management API

Abbreviations for Datetime and Interval Datatypes

12 DBMS_DEFER

Summary of DBMS_DEFER Subprograms

COMMIT_WORK Procedure

datatype_ARG Procedure

TRANSACTION Procedure

13 DBMS_DEFER_QUERY

Summary of DBMS_DEFER_QUERY Subprograms

GET_ARG_FORM Function

GET_ARG_TYPE Function

GET_CALL_ARGS Procedure

GET_datatype_ARG Function

GET_OBJECT_NULL_VECTOR_ARG Function

14 DBMS_DEFER_SYS

Summary of DBMS_DEFER_SYS Subprograms

ADD_DEFAULT_DEST Procedure

CLEAR_PROP_STATISTICS Procedure

DELETE_DEFAULT_DEST Procedure

DELETE_DEF_DESTINATION Procedure

DELETE_ERROR Procedure

DELETE_TRAN Procedure

DISABLED Function

EXCLUDE_PUSH Function

EXECUTE_ERROR Procedure

EXECUTE_ERROR_AS_USER Procedure

REGISTER_PROPAGATOR Procedure

SCHEDULE_PURGE Procedure

SCHEDULE_PUSH Procedure

SET_DISABLED Procedure

UNREGISTER_PROPAGATOR Procedure

UNSCHEDULE_PURGE Procedure

UNSCHEDULE_PUSH Procedure

15 DBMS_OFFLINE_OG

Summary of DBMS_OFFLINE_OG Subprograms

BEGIN_INSTANTIATION Procedure

BEGIN_LOAD Procedure

END_INSTANTIATION Procedure

END_LOAD Procedure

RESUME_SUBSET_OF_MASTERS Procedure

16 DBMS_RECTIFIER_DIFF

Summary of DBMS_RECTIFIER_DIFF Subprograms

DIFFERENCES Procedure

RECTIFY Procedure

17 DBMS_REFRESH

Summary of DBMS_REFRESH Subprograms

CHANGE Procedure

DESTROY Procedure

REFRESH Procedure

SUBTRACT Procedure

18 DBMS_REPCAT

Summary of DBMS_REPCAT Subprograms

ADD_GROUPED_COLUMN Procedure

ADD_MASTER_DATABASE Procedure

ADD_NEW_MASTERS Procedure

ADD_PRIORITY_datatype Procedure

ADD_SITE_PRIORITY_SITE Procedure

ADD_conflicttype_RESOLUTION Procedure

ALTER_CATCHUP_PARAMETERS Procedure

ALTER_MASTER_PROPAGATION Procedure

ALTER_MASTER_REPOBJECT Procedure

ALTER_MVIEW_PROPAGATION Procedure

ALTER_PRIORITY Procedure

ALTER_PRIORITY_datatype Procedure

ALTER_SITE_PRIORITY Procedure

ALTER_SITE_PRIORITY_SITE Procedure

CANCEL_STATISTICS Procedure

COMMENT_ON_COLUMN_GROUP Procedure

COMMENT_ON_MVIEW_REPSITES Procedure

COMMENT_ON_PRIORITY_GROUP Procedures

COMMENT_ON_REPGROUP Procedure

COMMENT_ON_REPOBJECT Procedure

COMMENT_ON_REPSITES Procedure

COMMENT_ON_SITE_PRIORITY Procedure

COMMENT_ON_conflicttype_RESOLUTION Procedure

COMPARE_OLD_VALUES Procedure

CREATE_MASTER_REPGROUP Procedure

CREATE_MASTER_REPOBJECT Procedure

CREATE_MVIEW_REPGROUP Procedure

CREATE_MVIEW_REPOBJECT Procedure

DEFINE_COLUMN_GROUP Procedure

DEFINE_PRIORITY_GROUP Procedure

DEFINE_SITE_PRIORITY Procedure

DO_DEFERRED_REPCAT_ADMIN Procedure

DROP_COLUMN_GROUP Procedure

DROP_GROUPED_COLUMN Procedure

DROP_MASTER_REPGROUP Procedure

DROP_MASTER_REPOBJECT Procedure

DROP_MVIEW_REPGROUP Procedure

DROP_MVIEW_REPOBJECT Procedure

DROP_PRIORITY Procedure

DROP_PRIORITY_GROUP Procedure

DROP_PRIORITY_datatype Procedure

DROP_SITE_PRIORITY Procedure

DROP_SITE_PRIORITY_SITE Procedure

DROP_conflicttype_RESOLUTION Procedure

EXECUTE_DDL Procedure

GENERATE_MVIEW_SUPPORT Procedure

GENERATE_REPLICATION_SUPPORT Procedure

MAKE_COLUMN_GROUP Procedure

PREPARE_INSTANTIATED_MASTER Procedure

PURGE_MASTER_LOG Procedure

PURGE_STATISTICS Procedure

REFRESH_MVIEW_REPGROUP Procedure

REGISTER_MVIEW_REPGROUP Procedure

REGISTER_STATISTICS Procedure

RELOCATE_MASTERDEF Procedure

REMOVE_MASTER_DATABASES Procedure

RENAME_SHADOW_COLUMN_GROUP Procedure

REPCAT_IMPORT_CHECK Procedure

RESUME_MASTER_ACTIVITY Procedure

RESUME_PROPAGATION_TO_MDEF Procedure

SEND_OLD_VALUES Procedure

SET_COLUMNS Procedure

SPECIFY_NEW_MASTERS Procedure

STREAMS_MIGRATION Procedure

SUSPEND_MASTER_ACTIVITY Procedure

SWITCH_MVIEW_MASTER Procedure

UNDO_ADD_NEW_MASTERS_REQUEST Procedure

UNREGISTER_MVIEW_REPGROUP Procedure

VALIDATE Function

WAIT_MASTER_LOG Procedure

19 DBMS_REPCAT_INSTANTIATE

Summary of DBMS_REPCAT_INSTANTIATE Subprograms

DROP_SITE_INSTANTIATION Procedure

INSTANTIATE_OFFLINE Function

INSTANTIATE_ONLINE Function

20 DBMS_REPCAT_ADMIN

Summary of DBMS_REPCAT_ADMIN Subprograms

GRANT_ADMIN_ANY_SCHEMA Procedure

GRANT_ADMIN_SCHEMA Procedure

REGISTER_USER_REPGROUP Procedure

REVOKE_ADMIN_ANY_SCHEMA Procedure

REVOKE_ADMIN_SCHEMA Procedure

UNREGISTER_USER_REPGROUP Procedure

21 DBMS_REPCAT_RGT

Summary of DBMS_REPCAT_RGT Subprograms

ALTER_REFRESH_TEMPLATE Procedure

ALTER_TEMPLATE_OBJECT Procedure

ALTER_TEMPLATE_PARM Procedure

ALTER_USER_AUTHORIZATION Procedure

ALTER_USER_PARM_VALUE Procedure

COMPARE_TEMPLATES Function

COPY_TEMPLATE Function

CREATE_OBJECT_FROM_EXISTING Function

CREATE_REFRESH_TEMPLATE Function

CREATE_TEMPLATE_OBJECT Function

CREATE_TEMPLATE_PARM Function

CREATE_USER_AUTHORIZATION Function

CREATE_USER_PARM_VALUE Function

DELETE_RUNTIME_PARMS Procedure

DROP_ALL_OBJECTS Procedure

DROP_ALL_TEMPLATE_PARMS Procedure

DROP_ALL_TEMPLATE_SITES Procedure

DROP_ALL_TEMPLATES Procedure

DROP_ALL_USER_AUTHORIZATIONS Procedure

DROP_ALL_USER_PARM_VALUES Procedure

DROP_REFRESH_TEMPLATE Procedure

DROP_SITE_INSTANTIATION Procedure

DROP_TEMPLATE_OBJECT Procedure

DROP_TEMPLATE_PARM Procedure

DROP_USER_AUTHORIZATION Procedure

DROP_USER_PARM_VALUE Procedure

GET_RUNTIME_PARM_ID Function

INSERT_RUNTIME_PARMS Procedure

INSTANTIATE_OFFLINE Function

INSTANTIATE_ONLINE Function

LOCK_TEMPLATE_EXCLUSIVE Procedure

LOCK_TEMPLATE_SHARED Procedure

22 DBMS_REPUTIL

Summary of DBMS_REPUTIL Subprograms

REPLICATION_OFF Procedure

REPLICATION_ON Procedure

REPLICATION_IS_ON Function

FROM_REMOTE Function

GLOBAL_NAME Function

MAKE_INTERNAL_PKG Procedure

SYNC_UP_REP Procedure

Part IV Replication Data Dictionary Reference

23 Replication Catalog Views

Summary of Replication Catalog Views

DBA_REGISTERED_MVIEW_GROUPS

ALL_REPCAT_REFRESH_TEMPLATES

ALL_REPCAT_TEMPLATE_OBJECTS

ALL_REPCAT_TEMPLATE_PARMS

ALL_REPCAT_TEMPLATE_SITES

ALL_REPCAT_USER_AUTHORIZATIONS

ALL_REPCAT_USER_PARM_VALUES

ALL_REPCOLUMN_GROUP

ALL_REPCONFLICT

ALL_REPGENOBJECTS

ALL_REPGROUP_PRIVILEGES

ALL_REPGROUPED_COLUMN

ALL_REPKEY_COLUMNS

ALL_REPPARAMETER_COLUMN

ALL_REPPRIORITY

ALL_REPPRIORITY_GROUP

ALL_REPRESOL_STATS_CONTROL

ALL_REPRESOLUTION

ALL_REPRESOLUTION_METHOD

ALL_REPRESOLUTION_STATISTICS

DBA_REPCAT_REFRESH_TEMPLATES

DBA_REPCAT_TEMPLATE_OBJECTS

DBA_REPCAT_TEMPLATE_PARMS

DBA_REPCAT_TEMPLATE_SITES

DBA_REPCAT_USER_AUTHORIZATIONS

DBA_REPCAT_USER_PARM_VALUES

DBA_REPCOLUMN_GROUP

DBA_REPCONFLICT

DBA_REPEXTENSIONS

DBA_REPGENOBJECTS

DBA_REPGROUP_PRIVILEGES

DBA_REPGROUPED_COLUMN

DBA_REPKEY_COLUMNS

DBA_REPPARAMETER_COLUMN

DBA_REPPRIORITY

DBA_REPPRIORITY_GROUP

DBA_REPRESOL_STATS_CONTROL

DBA_REPRESOLUTION

DBA_REPRESOLUTION_METHOD

DBA_REPRESOLUTION_STATISTICS

DBA_REPSITES_NEW

USER_REPCAT_REFRESH_TEMPLATES

USER_REPCAT_TEMPLATE_OBJECTS

USER_REPCAT_TEMPLATE_PARMS

USER_REPCAT_TEMPLATE_SITES

USER_REPCAT_USER_AUTHORIZATION

USER_REPCAT_USER_PARM_VALUES

USER_REPCOLUMN_GROUP

USER_REPCONFLICT

USER_REPGENOBJECTS

USER_REPGROUP_PRIVILEGES

USER_REPGROUPED_COLUMN

USER_REPKEY_COLUMNS

USER_REPPARAMETER_COLUMN

USER_REPPRIORITY

USER_REPPRIORITY_GROUP

USER_REPRESOL_STATS_CONTROL

USER_REPRESOLUTION

USER_REPRESOLUTION_METHOD

USER_REPRESOLUTION_STATISTICS

24 Replication Dynamic Performance Views

25 Deferred Transaction Views

26 Materialized View and Refresh Group Views

Part V Appendixes

A Security Options

Security Setup for Multimaster Replication

Trusted Compared with Untrusted Security

Security Setup for Materialized View Replication

Trusted Compared with Untrusted Security

B User-Defined Conflict Resolution Methods

User-Defined Conflict Resolution Methods

Conflict Resolution Method Parameters

Resolving Update Conflicts

Resolving Uniqueness Conflicts

Resolving Delete Conflicts

Multitier Materialized Views and User-Defined Conflict Resolution Methods

Restrictions for User-Defined Conflict Resolution Methods

SQL Statement Restrictions for User-Defined Conflict Resolution Methods

Column Subsetting Restrictions for User-Defined Conflict Resolution Methods

Examples of User-Defined Conflict Resolution Method

Maximum User Function

Additive User Function

User-Defined Conflict Notification Methods

Creating a Conflict Notification Log

Sample Conflict Notification Log Table

Creating a Conflict Notification Package

Sample Conflict Notification Package

Viewing Conflict Resolution Information

Index