Oracle7 Server Distributed Systems Manual, Vol. 2

Library

Product

---

• Oracle7^(tm) Server Distributed Systems, Volume II: Replicated Data

• Preface
  • Audience
  • How Oracle7 Server Distributed Systems, Volume II Is Organized
  • Conventions Used in This Manual
  • Your Comments Are Welcome

• Understanding Replication
  • Overview
  • Configurations
  • Propagating Changes Between Replicas

• Designing a Replicated Environment
  • Store-and-Forward vs. Real-Time Data Propagation
  • Distributed vs. Replicated Data
  • Master vs. Snapshot Replication
  • Replication Models
  • Survivability

• Read-Only Snapshots
  • Understanding Read-Only Snapshots
  • Creating Snapshots
  • Managing Snapshots
  • Using Snapshots
  • Managing Snapshot Logs
  • Using Snapshot Refresh Groups
  • Refreshing Snapshots
  • Listing Snapshot Information
  • Listing Refresh Group Information

• Multi-Master Replication
  • Replication Support for Master Sites
  • Designing Your Replicated Environment
  • Before Creating a Replicated Environment
  • Creating a Multi-Master Replicated Environment
  • Creating a Replicated Object Group
  • Creating a Replicated Object
  • Using an Alternate Primary Key
  • Adding a Master Site
  • Generating Replication Support
  • Synchronously Propagating DML Changes Among Master Sites
  • Asynchronously Propagating DML Changes Among Master Sites
  • Selecting a Propagation Method
  • Propagating DDL Changes Among Master Sites
  • Quiescing the Replicated Environment
  • Altering a Replicated Object
  • Dropping a Replicated Object
  • Removing a Master Site
  • Listing Information about a Replicated Environment

• Snapshot Site Replication
  • Replication Support at Snapshot Sites
  • Before Creating a Snapshot Site
  • Creating a Snapshot Replication Site
  • Creating the Replicated Object Group
  • Creating a Replicated Object
  • Dropping a Replicated Object
  • Dropping a Snapshot Object Group
  • Offline Instantiation
  • Propagating DML Changes
  • Propagating DDL Changes
  • Listing Snapshot Information
  • Sample Application

• Conflict Resolution
  • When to Use Conflict Resolution Methods
  • Detecting Conflicts
  • Understanding Column Groups
  • Selecting a Conflict Resolution Method
  • Minimum and Maximum Update Conflict Resolution Methods
  • Earliest and Latest Timestamp Update Conflict Resolution Methods
  • Additive and Average Update Conflict Resolution Methods
  • Priority Group and Site Priority Update Conflict Resolution Methods
  • Overwrite and Discard Update Conflict Resolution Methods
  • Append Site Name/Append Sequence Uniqueness Conflict Resolution Methods
  • Discard Uniqueness Conflict Resolution Method
  • Conflict Notification
  • Declaring a Conflict Resolution Method
  • Developing a Conflict Resolution Strategy
  • Using Column Groups
  • Designating a Conflict Resolution Routine for a Table
  • Changing a Conflict Resolution Routine
  • Dropping a Conflict Resolution Routine
  • Using Priority Groups
  • Using Site Priority
  • Viewing Conflict Resolution Information
  • Examples

• Administering a Replicated Environment
  • Determining the Cause of an Error
  • Manually Resolving an Error
  • Recovery
  • Auditing the Successful Resolution of Conflicts
  • Determining Outstanding Changes
  • Applying Outstanding Changes
  • Removing Log Information
  • Importing and Exporting Replicated Data
  • Supplying Asynchronous DDL
  • Determining Differences Between Replicated Tables
  • Updating Comments

• Advanced Techniques
  • Writing a Conflict Resolution Routine
  • Survivability
  • Dynamic Ownership Conflict Avoidance
  • Using Procedural Replication
  • Modifying Tables without Replicating the Modifications
  • Handling Deletes
  • Using Connection Qualifiers

• Troubleshooting
  • Diagnosing Problems with DBA_REPCATLOG Entries
  • Diagnosing Problems with Job Queues
  • Diagnosing Problems with Master Sites
  • Diagnosing Problems with the Deferred Transaction Queue
  • Diagnosing Problems with Snapshots

• Using Job Queues
  • Job Queues
  • SNP Background Processes
  • Using Job Queues
  • Submitting a Job to the Job Queue
  • How Jobs Execute
  • Removing a Job From the Job Queue
  • Altering a Job
  • Broken Jobs
  • Marking a Job as Broken or Not Broken
  • Forcing a Job to Be Executed
  • Troubleshooting Job Execution Problems
  • Viewing Job Queue Information

• Using Deferred Transactions
  • Listing Information about Deferred Transactions
  • Creating a Deferred Transaction

• Reference
  • DBMS_DEFER.CALL
  • DBMS_DEFER.COMMIT_WORK
  • DBMS_DEFER.datatype_ARG
  • DBMS_DEFER.TRANSACTION
  • DBMS_DEFER_QUERY.GET_ARG_TYPE
  • DBMS_DEFER_QUERY.GET_datatype_ARG
  • DBMS_DEFER_SYS.ADD_DEFAULT_DEST
  • DBMS_DEFER_SYS.COPY
  • DBMS_DEFER_SYS.DELETE_DEFAULT_DEST
  • DBMS_DEFER_SYS.DELETE_ERROR
  • DBMS_DEFER_SYS.DELETE_TRAN
  • DBMS_DEFER_SYS.DISABLED
  • DBMS_DEFER_SYS.EXECUTE
  • DBMS_DEFER_SYS.EXECUTE_ERROR
  • DBMS_DEFER_SYS.SCHEDULE_EXECUTION
  • DBMS_DEFER_SYS.SET_DISABLED
  • DBMS_DEFER_SYS.UNSCHEDULE_EXECUTION
  • DBMS_JOB.BROKEN
  • DBMS_JOB.CHANGE
  • DBMS_JOB.INTERVAL
  • DBMS_JOB.NEXT_DATE
  • DBMS_JOB.REMOVE
  • DBMS_JOB.RUN
  • DBMS_JOB.SUBMIT
  • DBMS_JOB.WHAT
  • DBMS_OFFLINE_OG.BEGIN_INSTANTIATION
  • DBMS_OFFLINE_OG.BEGIN_LOAD
  • DBMS_OFFLINE_OG.END_INSTANTIATION
  • DBMS_OFFLINE_OG.END_LOAD
  • DBMS_OFFLINE_OG.RESUME_SUBSET_OF_MASTERS
  • DBMS_OFFLINE_SNAPSHOT.BEGIN_LOAD
  • DBMS_OFFLINE_SNAPSHOT.END_LOAD
  • DBMS_RECTIFIER_DIFF.DIFFERENCES
  • DBMS_RECTIFIER_DIFF.RECTIFY
  • DBMS_REFRESH.ADD
  • DBMS_REFRESH.CHANGE
  • DBMS_REFRESH.DESTROY
  • DBMS_REFRESH.MAKE
  • DBMS_REFRESH.REFRESH
  • DBMS_REFRESH.SUBTRACT
  • DBMS_REPCAT.ADD_GROUPED_COLUMN
  • DBMS_REPCAT.ADD_MASTER_DATABASE
  • DBMS_REPCAT.ADD_PRIORITY_datatype
  • DBMS_REPCAT.ADD_SITE_PRIORITY_SITE
  • DBMS_REPCAT.ADD_conflicttype_RESOLUTION
  • DBMS_REPCAT.ALTER_MASTER_PROPAGATION
  • DBMS_REPCAT.ALTER_MASTER_REPOBJECT
  • DBMS_REPCAT.ALTER_PRIORITY
  • DBMS_REPCAT.ALTER_PRIORITY_datatype
  • DBMS_REPCAT.ALTER_SITE_PRIORITY
  • DBMS_REPCAT.ALTER_SITE_PRIORITY_SITE
  • DBMS_REPCAT.ALTER_SNAPSHOT_PROPAGATION
  • DBMS_REPCAT.CANCEL_STATISTICS
  • DBMS_REPCAT.COMMENT_ON_COLUMN_GROUP
  • DBMS_REPCAT.COMMENT_ON_PRIORITY_GROUP/
  • DBMS_REPCAT.COMMENT_ON_REPGROUP
  • DBMS_REPCAT.COMMENT_ON_REPSITES
  • DBMS_REPCAT.COMMENT_ON_REPOBJECT
  • DBMS_REPCAT.COMMENT_ON_conflicttype_RESOLUTION
  • DBMS_REPCAT.CREATE_MASTER_REPGROUP
  • DBMS_REPCAT.CREATE_MASTER_REPOBJECT
  • DBMS_REPCAT.CREATE_SNAPSHOT_REPGROUP
  • DBMS_REPCAT.CREATE_SNAPSHOT_REPOBJECT
  • DBMS_REPCAT.DEFINE_COLUMN_GROUP
  • DBMS_REPCAT.DEFINE_PRIORITY_GROUP
  • DBMS_REPCAT.DEFINE_SITE_PRIORITY
  • DBMS_REPCAT.DO_DEFERRED_REPCAT_ADMIN
  • DBMS_REPCAT.DROP_COLUMN_GROUP
  • DBMS_REPCAT.DROP_GROUPED_COLUMN
  • DBMS_REPCAT.DROP_MASTER_REPGROUP
  • DBMS_REPCAT.DROP_MASTER_REPOBJECT
  • DBMS_REPCAT.DROP_PRIORITY
  • DBMS_REPCAT.DROP_PRIORITY_GROUP
  • DBMS_REPCAT.DROP_PRIORITY_datatype
  • DBMS_REPCAT.DROP_SITE_PRIORITY
  • DBMS_REPCAT.DROP_SITE_PRIORITY_SITE
  • DBMS_REPCAT.DROP_SNAPSHOT_REPGROUP
  • DBMS_REPCAT.DROP_SNAPSHOT_REPOBJECT
  • DBMS_REPCAT.DROP_conflicttype_RESOLUTION
  • DBMS_REPCAT.EXECUTE_DDL
  • DBMS_REPCAT.GENERATE_REPLICATION_PACKAGE
  • DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT
  • DBMS_REPCAT.GENERATE_REPLICATION_TRIGGER
  • DBMS_REPCAT.MAKE_COLUMN_GROUP
  • DBMS_REPCAT.PURGE_MASTER_LOG
  • DBMS_REPCAT.PURGE_STATISTICS
  • DBMS_REPCAT.REFRESH_SNAPSHOT_REPGROUP
  • DBMS_REPCAT.REGISTER_STATISTICS
  • DBMS_REPCAT.RELOCATE_MASTERDEF
  • DBMS_REPCAT.REMOVE_MASTER_DATABASES
  • DBMS_REPCAT.REPCAT_IMPORT_CHECK
  • DBMS_REPCAT.RESUME_MASTER_ACTIVITY
  • DBMS_REPCAT.SET_COLUMNS
  • DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY
  • DBMS_REPCAT.SWITCH_SNAPSHOT_MASTER
  • DBMS_REPCAT.WAIT_MASTER_LOG
  • DBMS_REPCAT_ADMIN.GRANT_ADMIN_ANY_REPGROUP
  • DBMS_REPCAT_ADMIN.GRANT_ADMIN_REPGROUP
  • DBMS_REPCAT_ADMIN.REVOKE_ADMIN_ANY_REPGROUP
  • DBMS_REPCAT_ADMIN.REVOKE_ADMIN_REPGROUP
  • DBMS_REPCAT_AUTH.GRANT_SURROGATE_REPCAT
  • DBMS_REPCAT_AUTH.REVOKE_SURROGATE_REPCAT
  • DBMS_REPUTIL.REPLICATION_OFF
  • DBMS_REPUTIL.REPLICATION_ON
  • DBMS_SNAPSHOT.I_AM_A_REFRESH
  • DBMS_SNAPSHOT.PURGE_LOG
  • DBMS_SNAPSHOT.REFRESH
  • DBMS_SNAPSHOT.SET_I_AM_A_REFRESH
  • Package Variables

• Data Dictionary Views
  • Replication Catalog Views
  • Deferred Transaction Views
  • Viewing Job Queue Information
  • Snapshot and Snapshot Refresh Group Views

• Release Information
  • New Features
  • Obsolete Procedures
  • New and Changed Procedures
  • Compatibility Issues
  • Upgrading and the Advanced Replication Option
  • Downgrading and the Advanced Replication Option
  • Advanced Replication Compatibility Between Release 7.3 and Earlier Releases

• Operating System-Specific Information

---

Copyright © 1996 Oracle Corporation 500 Oracle Parkway, Redwood City, CA 94065

Library

Product