Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Part I Configuring Your Replication Environment

1 Overview of Advanced Replication

• Overview of Creating a Replication Environment
• Before You Start

2 Configuring the Replication Sites

• Overview of Setting Up Replication Sites
• Setting Up Master Sites
  • Setting Up orc1.example.com
  • Setting Up orc2.example.com
  • Setting Up orc3.example.com
  • Creating Scheduled Links Between the Master Sites
• Setting Up Materialized View Sites
  • Setting Up mv1.example.com
  • Setting Up mv2.example.com

3 Creating a Master Group

• Overview of Creating a Master Group
  • Before You Start
• Creating a Master Group

4 Creating 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 Creating a Materialized View Group

• Overview of Creating a Materialized View Group
• Creating a Materialized View Group
  • Creating the Materialized View Group at mv1.example.com
  • Creating the Materialized View Group at mv2.example.com

6 Configuring 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
  • Workflow
  • Token Passing
  • 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 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 Advanced Replication Interface and the Replication Management API
• Abbreviations for Datetime and Interval Data Types

12 DBMS_DEFER

• Summary of DBMS_DEFER Subprograms
  • CALL Procedure
  • 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
  • PURGE Function
  • PUSH Function
  • 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
  • ADD Procedure
  • CHANGE Procedure
  • DESTROY Procedure
  • MAKE 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_REPCATLOG
  • ALL_REPCOLUMN
  • ALL_REPCOLUMN_GROUP
  • ALL_REPCONFLICT
  • ALL_REPDDL
  • ALL_REPGENOBJECTS
  • ALL_REPGROUP
  • ALL_REPGROUP_PRIVILEGES
  • ALL_REPGROUPED_COLUMN
  • ALL_REPKEY_COLUMNS
  • ALL_REPOBJECT
  • ALL_REPPARAMETER_COLUMN
  • ALL_REPPRIORITY
  • ALL_REPPRIORITY_GROUP
  • ALL_REPPROP
  • ALL_REPRESOL_STATS_CONTROL
  • ALL_REPRESOLUTION
  • ALL_REPRESOLUTION_METHOD
  • ALL_REPRESOLUTION_STATISTICS
  • ALL_REPSITES
  • 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_REPCATLOG
  • DBA_REPCOLUMN
  • DBA_REPCOLUMN_GROUP
  • DBA_REPCONFLICT
  • DBA_REPDDL
  • DBA_REPEXTENSIONS
  • DBA_REPGENOBJECTS
  • DBA_REPGROUP
  • DBA_REPGROUP_PRIVILEGES
  • DBA_REPGROUPED_COLUMN
  • DBA_REPKEY_COLUMNS
  • DBA_REPOBJECT
  • DBA_REPPARAMETER_COLUMN
  • DBA_REPPRIORITY
  • DBA_REPPRIORITY_GROUP
  • DBA_REPPROP
  • DBA_REPRESOL_STATS_CONTROL
  • DBA_REPRESOLUTION
  • DBA_REPRESOLUTION_METHOD
  • DBA_REPRESOLUTION_STATISTICS
  • DBA_REPSITES
  • 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_REPCATLOG
  • USER_REPCOLUMN
  • USER_REPCOLUMN_GROUP
  • USER_REPCONFLICT
  • USER_REPDDL
  • USER_REPGENOBJECTS
  • USER_REPGROUP
  • USER_REPGROUP_PRIVILEGES
  • USER_REPGROUPED_COLUMN
  • USER_REPKEY_COLUMNS
  • USER_REPOBJECT
  • USER_REPPARAMETER_COLUMN
  • USER_REPPRIORITY
  • USER_REPPRIORITY_GROUP
  • USER_REPPROP
  • USER_REPRESOL_STATS_CONTROL
  • USER_REPRESOLUTION
  • USER_REPRESOLUTION_METHOD
  • USER_REPRESOLUTION_STATISTICS
  • USER_REPSITES

24 Replication Dynamic Performance Views

• V$MVREFRESH
• V$REPLPROP
• V$REPLQUEUE

25 Deferred Transaction Views

• DEFCALL
• DEFCALLDEST
• DEFDEFAULTDEST
• DEFERRCOUNT
• DEFERROR
• DEFLOB
• DEFPROPAGATOR
• DEFSCHEDULE
• DEFTRAN
• DEFTRANDEST

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