Oracle Streams Replication Administrator’s Guide Administrator's
User Manual:
Open the PDF directly: View PDF
Page Count: 438 [warning: Documents this large are best viewed by clicking the View PDF Link!]
- Contents
- List of Figures
- List of Tables
- Preface
- Part I Configuring Oracle Streams Replication
- 1 Preparing for Oracle Streams Replication
- Overview of Oracle Streams Replication
- Decisions to Make Before Configuring Oracle Streams Replication
- Decide Which Type of Replication Environment to Configure
- Decide Whether to Configure Local or Downstream Capture for the Source Database
- Decide Whether Changes Are Allowed at One Database or at Multiple Databases
- Decide Whether the Replication Environment Will Have Nonidentical Replicas
- Decide Whether the Replication Environment Will Use Apply Handlers
- Decide Whether to Maintain DDL Changes
- Decide How to Configure the Replication Environment
- Tasks to Complete Before Configuring Oracle Streams Replication
- Configuring an Oracle Streams Administrator on All Databases
- Configuring Network Connectivity and Database Links
- Ensuring That Each Source Database Is In ARCHIVELOG Mode
- Setting Initialization Parameters Relevant to Oracle Streams
- Configuring the Oracle Streams Pool
- Specifying Supplemental Logging
- Required Supplemental Logging in an Oracle Streams Replication Environment
- Specifying Table Supplemental Logging Using Unconditional Log Groups
- Specifying Table Supplemental Logging Using Conditional Log Groups
- Dropping a Supplemental Log Group
- Specifying Database Supplemental Logging of Key Columns
- Dropping Database Supplemental Logging of Key Columns
- Procedures That Automatically Specify Supplemental Logging
- Configuring Log File Transfer to a Downstream Capture Database
- Adding Standby Redo Logs for Real-Time Downstream Capture
- 2 Simple Oracle Streams Replication Configuration
- Configuring Replication Using the Setup Streams Replication Wizard
- Configuring Replication Using the DBMS_STREAMS_ADM Package
- The Oracle Streams Replication Configuration Procedures
- Important Considerations for the Configuration Procedures
- Creating the Required Directory Objects
- Examples That Configure Two-Database Replication with Local Capture
- Examples That Configure Two-Database Replication with Downstream Capture
- Example That Configures Hub-and-Spoke Replication
- Monitoring Oracle Streams Configuration Progress
- 3 Flexible Oracle Streams Replication Configuration
- 4 Adding to an Oracle Streams Replication Environment
- About Adding to an Oracle Streams Replication Environment
- Adding Multiple Components Using a Single Procedure
- Adding Components Individually in Multiple Steps
- 5 Configuring Implicit Capture
- 6 Configuring Queues and Propagations
- 7 Configuring Implicit Apply
- 8 Instantiation and Oracle Streams Replication
- Overview of Instantiation and Oracle Streams Replication
- Capture Rules and Preparation for Instantiation
- Oracle Data Pump and Oracle Streams Instantiation
- Recovery Manager (RMAN) and Oracle Streams Instantiation
- Setting Instantiation SCNs at a Destination Database
- Monitoring Instantiation
- 9 Oracle Streams Conflict Resolution
- About DML Conflicts in an Oracle Streams Environment
- Conflict Types in an Oracle Streams Environment
- Conflicts and Transaction Ordering in an Oracle Streams Environment
- Conflict Detection in an Oracle Streams Environment
- Conflict Avoidance in an Oracle Streams Environment
- Conflict Resolution in an Oracle Streams Environment
- Managing Oracle Streams Conflict Detection and Resolution
- Monitoring Conflict Detection and Update Conflict Handlers
- 10 Oracle Streams Tags
- 11 Oracle Streams Heterogeneous Information Sharing
- Oracle to Non-Oracle Data Sharing with Oracle Streams
- Change Capture and Staging in an Oracle to Non-Oracle Environment
- Change Apply in an Oracle to Non-Oracle Environment
- Transformations in an Oracle to Non-Oracle Environment
- Messaging Gateway and Oracle Streams
- Error Handling in an Oracle to Non-Oracle Environment
- Example Oracle to Non-Oracle Streams Environment
- Non-Oracle to Oracle Data Sharing with Oracle Streams
- Non-Oracle to Non-Oracle Data Sharing with Oracle Streams
- Oracle to Non-Oracle Data Sharing with Oracle Streams
- 1 Preparing for Oracle Streams Replication
- Part II Administering Oracle Streams Replication
- 12 Managing Oracle Streams Replication
- About Managing Oracle Streams
- Tracking LCRs Through a Stream
- Splitting and Merging an Oracle Streams Destination
- Changing the DBID or Global Name of a Source Database
- Resynchronizing a Source Database in a Multiple-Source Environment
- Performing Database Point-in-Time Recovery in an Oracle Streams Environment
- Running Flashback Queries in an Oracle Streams Replication Environment
- Recovering from Operation Errors
- 13 Comparing and Converging Data
- About Comparing and Converging Data
- Other Documentation About the DBMS_COMPARISON Package
- Preparing To Compare and Converge a Shared Database Object
- Diverging a Database Object at Two Databases to Complete Examples
- Comparing a Shared Database Object at Two Databases
- Comparing a Subset of Columns in a Shared Database Object
- Comparing a Shared Database Object without Identifying Row Differences
- Comparing a Random Portion of a Shared Database Object
- Comparing a Shared Database Object Cyclically
- Comparing a Custom Portion of a Shared Database Object
- Comparing a Shared Database Object That Contains CLOB or BLOB Columns
- Viewing Information About Comparisons and Comparison Results
- Viewing General Information About the Comparisons in a Database
- Viewing Information Specific to Random and Cyclic Comparisons
- Viewing the Columns Compared by Each Comparison in a Database
- Viewing General Information About Each Scan in a Database
- Viewing the Parent Scan ID and Root Scan ID for Each Scan in a Database
- Viewing Detailed Information About the Row Differences Found in a Scan
- Viewing Information About the Rows Compared in Specific Scans
- Converging a Shared Database Object
- Rechecking the Comparison Results for a Comparison
- Purging Comparison Results
- Dropping a Comparison
- Using DBMS_COMPARISON in an Oracle Streams Replication Environment
- 14 Managing Logical Change Records (LCRs)
- Requirements for Managing LCRs
- Constructing and Enqueuing LCRs
- Executing LCRs
- Managing LCRs Containing LOB Columns
- Managing LCRs Containing LONG or LONG RAW Columns
- 12 Managing Oracle Streams Replication
- Part III Oracle Streams Replication Best Practices
- 15 Best Practices for Oracle Streams Replication Databases
- Best Practices for Oracle Streams Database Configuration
- Best Practices for Oracle Streams Database Operation
- Follow the Best Practices for the Global Name of an Oracle Streams Database
- Monitor Performance and Make Adjustments When Necessary
- Monitor Capture Process’s and Synchronous Capture’s Queues for Size
- Follow the Oracle Streams Best Practices for Backups
- Adjust the Automatic Collection of Optimizer Statistics
- Check the Alert Log for Oracle Streams Information
- Follow the Best Practices for Removing an Oracle Streams Configuration at a Database
- Best Practices for Oracle Real Application Clusters and Oracle Streams
- 16 Best Practices for Capture
- 17 Best Practices for Propagation
- 18 Best Practices for Apply
- 15 Best Practices for Oracle Streams Replication Databases
- Part IV Appendixes
- Index