Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Streams Concepts and Administration
- Part I Essential Oracle Streams Concepts
- 1
Introduction to Oracle Streams
- 1.1 Overview of Oracle Streams
- 1.2 What Can Oracle Streams Do?
- 1.3 What Are the Uses of Oracle Streams?
- 1.4
Sample Oracle Streams Configurations
- 1.4.1 Sample Hub-and-Spoke Replication Configuration
- 1.4.2 Sample Replication Configuration with Downstream Capture
- 1.4.3 Sample Replication Configuration That Uses Synchronous Captures
- 1.4.4 Sample N-Way Replication Configuration
- 1.4.5 Sample Configuration That Performs Capture and Apply in a Single Database
- 1.4.6 Sample Messaging Configuration
- 1.5
Oracle Streams Documentation Roadmap
- 1.5.1 Documentation for Learning About Oracle Streams
- 1.5.2 Documentation About Setting Up or Extending an Oracle Streams Environment
- 1.5.3 Documentation About Managing an Oracle Streams Environment
- 1.5.4 Documentation About Monitoring an Oracle Streams Environment
- 1.5.5 Documentation About Using Oracle Streams for Upgrade and Maintenance
- 2
Oracle Streams Information Capture
- 2.1 Ways to Capture Information with Oracle Streams
- 2.2 Types of Information Captured with Oracle Streams
- 2.3 Summary of Information Capture Options with Oracle Streams
- 2.4 Instantiation in an Oracle Streams Environment
- 2.5
Implicit Capture with an Oracle Streams Capture Process
- 2.5.1 Introduction to Capture Processes
- 2.5.2 Capture Process Rules
- 2.5.3 Data Types Captured by Capture Processes
- 2.5.4 Types of DML Changes Captured by Capture Processes
- 2.5.5 Supplemental Logging in an Oracle Streams Environment
- 2.5.6
Local Capture and Downstream Capture
- 2.5.6.1 Local Capture
- 2.5.6.2
Downstream Capture
- 2.5.6.2.1 Real-Time Downstream Capture
- 2.5.6.2.2 Archived-Log Downstream Capture
- 2.5.6.2.3 The Downstream Database Performs Most Change Capture Actions
- 2.5.6.2.4 Advantages of Downstream Capture
- 2.5.6.2.5 Optional Database Link From the Downstream Database to the Source Database
- 2.5.6.2.6 Operational Requirements for Downstream Capture
- 2.5.7 SCN Values Related to a Capture Process
- 2.5.8 Oracle Streams Capture Processes and RESTRICTED SESSION
- 2.5.9 Capture Process Subcomponents
- 2.5.10 Capture User
- 2.5.11 Capture Process States
- 2.5.12 Capture Process Parameters
- 2.5.13 Persistent Capture Process Status Upon Database Restart
- 2.6
Implicit Capture with Synchronous Capture
- 2.6.1 Introduction to Synchronous Capture
- 2.6.2 Synchronous Capture and Queues
- 2.6.3 Synchronous Capture Rules
- 2.6.4 Data Types Captured by Synchronous Capture
- 2.6.5 Types of DML Changes Captured by Synchronous Capture
- 2.6.6 Capture User for Synchronous Capture
- 2.6.7 Multiple Synchronous Captures in a Single Database
- 2.7 Explicit Capture by Applications
- 3 Oracle Streams Staging and Propagation
- 4
Oracle Streams Information Consumption
- 4.1 Overview of Information Consumption with Oracle Streams
- 4.2
Implicit Consumption with an Apply Process
- 4.2.1 Introduction to the Apply Process
- 4.2.2 Apply Process Rules
- 4.2.3 Types of Messages That Can Be Processed with an Apply Process
- 4.2.4 Message Processing Options for an Apply Process
- 4.2.5 The Source of Messages Applied by an Apply Process
- 4.2.6 Data Types Applied
- 4.2.7 Automatic Data Type Conversion During Apply
- 4.2.8 SQL Generation
- 4.2.9 Oracle Streams Apply Processes and RESTRICTED SESSION
- 4.2.10 Apply Process Subcomponents
- 4.2.11 Apply User
- 4.2.12 Apply Process Parameters
- 4.2.13 Persistent Apply Process Status Upon Database Restart
- 4.2.14 The Error Queue
- 4.3 Explicit Consumption with a Messaging Client
- 4.4 Explicit Consumption with Manual Dequeue
- 5
How Rules Are Used in Oracle Streams
- 5.1 Overview of How Rules Are Used in Oracle Streams
- 5.2
Rule Sets and Rule Evaluation of Messages
- 5.2.1 Oracle Streams Client with No Rule Set
- 5.2.2 Oracle Streams Client with a Positive Rule Set Only
- 5.2.3 Oracle Streams Client with a Negative Rule Set Only
- 5.2.4 Oracle Streams Client with Both a Positive and a Negative Rule Set
- 5.2.5 Oracle Streams Client with One or More Empty Rule Sets
- 5.2.6 Summary of Rule Sets and Oracle Streams Client Behavior
- 5.3
System-Created Rules
- 5.3.1 Global Rules
- 5.3.2 Schema Rules
- 5.3.3 Table Rules
- 5.3.4 Subset Rules
- 5.3.5 Message Rules
- 5.3.6 System-Created Rules and Negative Rule Sets
- 5.3.7 System-Created Rules with Added User-Defined Conditions
- 6
Rule-Based Transformations
- 6.1 Declarative Rule-Based Transformations
- 6.2 Custom Rule-Based Transformations
- 6.3
Rule-Based Transformations and Oracle Streams Clients
- 6.3.1 Rule-Based Transformations and Capture Processes
- 6.3.2 Rule-Based Transformations and Synchronous Captures
- 6.3.3 Rule-Based Transformations and Propagations
- 6.3.4 Rule-Based Transformations and an Apply Process
- 6.3.5 Rule-Based Transformations and a Messaging Client
- 6.3.6 Multiple Rule-Based Transformations
- 6.4 Transformation Ordering
- 6.5 Considerations for Rule-Based Transformations
- 1
Introduction to Oracle Streams
- Part II Advanced Oracle Streams Concepts
- 7
Advanced Capture Process Concepts
- 7.1 Multiple Capture Processes in a Single Database
- 7.2 Capture Process Checkpoints
- 7.3 A New First SCN Value and Purged LogMiner Data Dictionary Information
- 7.4 ARCHIVELOG Mode and a Capture Process
- 7.5 Capture Process Creation
- 7.6 The Oracle Streams Data Dictionary
- 7.7 Capture Process Rule Evaluation
- 8 Advanced Queue Concepts
- 9 Advanced Propagation Concepts
- 10
Advanced Apply Process Concepts
- 10.1 Apply Process Creation
- 10.2 Apply Processes and Dependencies
- 10.3
Considerations for Applying DML Changes to Tables
- 10.3.1 Constraints and Applying DML Changes to Tables
- 10.3.2 Substitute Key Columns
- 10.3.3 Apply Process Behavior for Column Discrepancies
- 10.3.4 Conflict Resolution and an Apply Process
- 10.3.5
Handlers and Row LCR Processing
- 10.3.5.1 No Relevant Handlers
- 10.3.5.2 Relevant Update Conflict Handler
- 10.3.5.3 DML Handler But No Relevant Update Conflict Handler
- 10.3.5.4 DML Handler And a Relevant Update Conflict Handler
- 10.3.5.5 Statement DML Handler and Procedure DML Handler
- 10.3.5.6 Error Handler But No Relevant Update Conflict Handler
- 10.3.5.7 Error Handler And a Relevant Update Conflict Handler
- 10.3.5.8 Statement DML Handler and Relevant Error Handler
- 10.3.5.9 Statement DML Handler, Error Handler, and Relevant Update Conflict Handler
- 10.4 Considerations for Applying DDL Changes
- 10.5 Instantiation SCN and Ignore SCN for an Apply Process
- 10.6 The Oldest SCN for an Apply Process
- 10.7 Low-Watermark and High-Watermark for an Apply Process
- 10.8 Apply Processes and Triggers
- 10.9 Oracle Streams Data Dictionary for an Apply Process
- 10.10 Multiple Apply Processes in a Single Database
- 11
Advanced Rule Concepts
- 11.1 The Components of a Rule
- 11.2 Rule Set Evaluation
- 11.3
Database Objects and Privileges Related to Rules
- 11.3.1 Privileges for Creating Database Objects Related to Rules
- 11.3.2 Privileges for Altering Database Objects Related to Rules
- 11.3.3 Privileges for Dropping Database Objects Related to Rules
- 11.3.4 Privileges for Placing Rules in a Rule Set
- 11.3.5 Privileges for Evaluating a Rule Set
- 11.3.6 Privileges for Using an Evaluation Context
- 11.4 Evaluation Contexts Used in Oracle Streams
- 11.5 Oracle Streams and Event Contexts
- 11.6 Oracle Streams and Action Contexts
- 11.7
User-Created Rules, Rule Sets, and Evaluation Contexts
- 11.7.1
User-Created Rules and Rule Sets
- 11.7.1.1 Rule Conditions for Specific Types of Operations
- 11.7.1.2 Rule Conditions that Instruct Oracle Streams Clients to Discard Unsupported LCRs
- 11.7.1.3 Complex Rule Conditions
- 11.7.1.4 Rule Conditions with Undefined Variables that Evaluate to NULL
- 11.7.1.5 Variables as Function Parameters in Rule Conditions
- 11.7.2 User-Created Evaluation Contexts
- 11.7.1
User-Created Rules and Rule Sets
- 12 Combined Capture and Apply Optimization
- 13
Oracle Streams High Availability Environments
- 13.1 Overview of Oracle Streams High Availability Environments
- 13.2 Protection from Failures
- 13.3 Best Practices for Oracle Streams High Availability Environments
- 7
Advanced Capture Process Concepts
- Part III Oracle Streams Administration
- 14
Introduction to Oracle Streams Administration
- 14.1
Oracle-Supplied PL/SQL Packages
- 14.1.1 DBMS_APPLY_ADM Package
- 14.1.2 DBMS_CAPTURE_ADM Package
- 14.1.3 DBMS_COMPARISON Package
- 14.1.4 DBMS_PROPAGATION_ADM Package
- 14.1.5 DBMS_RULE Package
- 14.1.6 DBMS_RULE_ADM Package
- 14.1.7 DBMS_STREAMS Package
- 14.1.8 DBMS_STREAMS_ADM Package
- 14.1.9 DBMS_STREAMS_ADVISOR_ADM Package
- 14.1.10 DBMS_STREAMS_AUTH Package
- 14.1.11 DBMS_STREAMS_HANDLER_ADM Package
- 14.1.12 DBMS_STREAMS_MESSAGING Package
- 14.1.13 DBMS_STREAMS_TABLESPACE_ADM Package
- 14.1.14 UTL_SPADV Package
- 14.2 Oracle Streams Data Dictionary Views
- 14.3 Oracle Streams Tool in Oracle Enterprise Manager Cloud Control
- 14.1
Oracle-Supplied PL/SQL Packages
- 15
Managing Oracle Streams Implicit Capture
- 15.1
Managing a Capture Process
- 15.1.1 Starting a Capture Process
- 15.1.2 Stopping a Capture Process
- 15.1.3 Managing the Rule Set for a Capture Process
- 15.1.4 Setting a Capture Process Parameter
- 15.1.5 Setting the Capture User for a Capture Process
- 15.1.6 Managing the Checkpoint Retention Time for a Capture Process
- 15.1.7 Adding an Archived Redo Log File to a Capture Process Explicitly
- 15.1.8 Setting the First SCN for an Existing Capture Process
- 15.1.9 Setting the Start SCN for an Existing Capture Process
- 15.1.10 Specifying Whether Downstream Capture Uses a Database Link
- 15.1.11 Dropping a Capture Process
- 15.2 Managing a Synchronous Capture
- 15.3 Managing Extra Attributes in Captured LCRs
- 15.4 Switching From a Capture Process to a Synchronous Capture
- 15.5 Switching from a Synchronous Capture to a Capture Process
- 15.1
Managing a Capture Process
- 16
Managing Staging and Propagation
- 16.1 Managing Queues
- 16.2
Managing Oracle Streams Propagations and Propagation Jobs
- 16.2.1 Starting a Propagation
- 16.2.2 Stopping a Propagation
- 16.2.3 Altering the Schedule of a Propagation Job
- 16.2.4 Specifying the Rule Set for a Propagation
- 16.2.5 Adding Rules to the Rule Set for a Propagation
- 16.2.6 Removing a Rule from the Rule Set for a Propagation
- 16.2.7 Removing a Rule Set for a Propagation
- 16.2.8 Dropping a Propagation
- 17
Managing Oracle Streams Information Consumption
- 17.1 Starting an Apply Process
- 17.2 Stopping an Apply Process
- 17.3 Managing the Rule Set for an Apply Process
- 17.4 Setting an Apply Process Parameter
- 17.5 Setting the Apply User for an Apply Process
- 17.6
Managing a DML Handler
- 17.6.1
Managing a Statement DML Handler
- 17.6.1.1 Creating a Statement DML Handler and Adding It to an Apply Process
- 17.6.1.2 Adding Statements to a Statement DML Handler
- 17.6.1.3 Modifying a Statement in a Statement DML Handler
- 17.6.1.4 Removing Statements from a Statement DML Handler
- 17.6.1.5 Removing a Statement DML Handler from an Apply Process
- 17.6.1.6 Dropping a Statement DML Handler
- 17.6.2 Managing a Procedure DML Handler
- 17.6.1
Managing a Statement DML Handler
- 17.7 Managing a DDL Handler
- 17.8 Managing the Message Handler for an Apply Process
- 17.9 Managing the Precommit Handler for an Apply Process
- 17.10 Specifying That Apply Processes Enqueue Messages
- 17.11 Specifying Execute Directives for Apply Processes
- 17.12 Managing an Error Handler
- 17.13 Managing Apply Errors
- 17.14 Managing the Substitute Key Columns for a Table
- 17.15 Using Virtual Dependency Definitions
- 17.16 Dropping an Apply Process
- 18
Managing Rules
- 18.1 Managing Rule Sets
- 18.2 Managing Rules
- 18.3
Managing Privileges on Evaluation Contexts, Rule Sets, and Rules
- 18.3.1 Granting System Privileges on Evaluation Contexts, Rule Sets, and Rules
- 18.3.2 Granting Object Privileges on an Evaluation Context, Rule Set, or Rule
- 18.3.3 Revoking System Privileges on Evaluation Contexts, Rule Sets, and Rules
- 18.3.4 Revoking Object Privileges on an Evaluation Context, Rule Set, or Rule
- 19 Managing Rule-Based Transformations
- 20
Using Oracle Streams to Record Table Changes
- 20.1 About Using Oracle Streams to Record Changes to Tables
- 20.2
Preparing for an Oracle Streams Environment That Records Table Changes
- 20.2.1
Decisions to Make Before Running the MAINTAIN_CHANGE_TABLE Procedure
- 20.2.1.1 Decide Which Type of Environment to Configure
- 20.2.1.2 Decide Which Columns to Track
- 20.2.1.3 Decide Which Metadata to Record
- 20.2.1.4 Decide Which Values to Track for Update Operations
- 20.2.1.5 Decide Whether to Configure a KEEP_COLUMNS Transformation
- 20.2.1.6 Decide Whether to Specify CREATE TABLE Options for the Change Table
- 20.2.1.7 Decide Whether to Perform the Configuration Actions Directly or with a Script
- 20.2.1.8 Decide Whether to Replicate the Source Table
- 20.2.2
Prerequisites for the MAINTAIN_CHANGE _TABLE Procedure
- 20.2.2.1 Configure an Oracle Streams Administrator on All Databases
- 20.2.2.2 Configure Network Connectivity and Database Links
- 20.2.2.3 Ensure That the Source Database Is in ARCHIVELOG Mode
- 20.2.2.4 Set Initialization Parameters That Are Relevant to Oracle Streams
- 20.2.2.5 Configure the Oracle Streams Pool
- 20.2.2.6 Configure Log File Transfer to a Downstream Capture Database
- 20.2.2.7 Configure Standby Redo Logs for Real-Time Downstream Capture
- 20.2.2.8 Configure the Required Directory Object If You Are Using a Script
- 20.2.2.9 Instantiate the Source Table at the Destination Database
- 20.2.1
Decisions to Make Before Running the MAINTAIN_CHANGE_TABLE Procedure
- 20.3
Configuring an Oracle Streams Environment That Records Table Changes
- 20.3.1 Recording Table Changes Using Local Capture and Apply on One Database
- 20.3.2 Recording Table Changes Using Local Capture and Remote Apply with Replication
- 20.3.3 Recording Table Changes Using Downstream Capture and Local Apply
- 20.3.4 Recording Table Changes Using Downstream Capture and Remote Apply
- 20.4 Managing an Oracle Streams Environment That Records Table Changes
- 20.5 Monitoring an Oracle Streams Environment That Records Table Changes
- 21 Other Oracle Streams Management Tasks
- 14
Introduction to Oracle Streams Administration
- Part IV Monitoring Oracle Streams
- 22 Monitoring an Oracle Streams Environment
- 23
Monitoring the Oracle Streams Topology and Performance
- 23.1 About the Oracle Streams Topology
- 23.2 About the Oracle Streams Performance Advisor
- 23.3 About Stream Paths in an Oracle Streams Topology
- 23.4 About the Information Gathered by the Oracle Streams Performance Advisor
- 23.5 Gathering Information About the Oracle Streams Topology and Performance
- 23.6 Viewing the Oracle Streams Topology and Analyzing Oracle Streams Performance
- 23.7
Using the UTL_SPADV Package
- 23.7.1 Collecting Oracle Streams Statistics Using the UTL_SPADV Package
- 23.7.2 Checking Whether an Oracle Streams Monitoring Job Is Currently Running
- 23.7.3 Altering an Oracle Streams Monitoring Job
- 23.7.4 Stopping an Oracle Streams Monitoring Job
- 23.7.5 Showing Oracle Streams Statistics Using the UTL_SPADV Package
- 24
Monitoring Oracle Streams Implicit Capture
- 24.1
Monitoring a Capture Process
- 24.1.1 Displaying the Queue, Rule Sets, and Status of Each Capture Process
- 24.1.2 Displaying Session Information About Each Capture Process
- 24.1.3 Displaying Change Capture Information About Each Capture Process
- 24.1.4 Displaying State Change and Message Creation Time for Each Capture Process
- 24.1.5 Displaying Elapsed Time Performing Capture Operations for Each Capture Process
- 24.1.6 Displaying Information About Each Downstream Capture Process
- 24.1.7 Displaying the Registered Redo Log Files for Each Capture Process
- 24.1.8 Displaying the Redo Log Files That Are Required by Each Capture Process
- 24.1.9 Displaying SCN Values for Each Redo Log File Used by Each Capture Process
- 24.1.10 Displaying the Last Archived Redo Entry Available to Each Capture Process
- 24.1.11 Listing the Parameter Settings for Each Capture Process
- 24.1.12 Determining the Applied SCN for All Capture Processes in a Database
- 24.1.13 Determining Redo Log Scanning Latency for Each Capture Process
- 24.1.14 Determining Message Enqueuing Latency for Each Capture Process
- 24.1.15 Displaying Information About Rule Evaluations for Each Capture Process
- 24.1.16 Determining Which Capture Processes Use Combined Capture and Apply
- 24.1.17
Displaying Information About Split and Merge Operations
- 24.1.17.1 Displaying the Names of the Original and Cloned Oracle Streams Components
- 24.1.17.2 Displaying the Actions and Thresholds for Split and Merge Operations
- 24.1.17.3 Displaying the Lag Time of the Cloned Capture Process
- 24.1.17.4 Displaying Information About the Split and Merge Jobs
- 24.1.17.5 Displaying Information About Past Split and Merge Operations
- 24.1.18 Monitoring Supplemental Logging
- 24.2 Monitoring a Synchronous Capture
- 24.3 Viewing the Extra Attributes Captured by Implicit Capture
- 24.1
Monitoring a Capture Process
- 25
Monitoring Oracle Streams Queues and Propagations
- 25.1 Monitoring Queues and Messaging
- 25.2
Monitoring Buffered Queues
- 25.2.1 Determining the Number of Messages in Each Buffered Queue
- 25.2.2 Viewing the Capture Processes for the LCRs in Each Buffered Queue
- 25.2.3 Displaying Information About Propagations that Send Buffered Messages
- 25.2.4 Displaying the Number of Messages and Bytes Sent By Propagations
- 25.2.5 Displaying Performance Statistics for Propagations that Send Buffered Messages
- 25.2.6 Viewing the Propagations Dequeuing Messages from Each Buffered Queue
- 25.2.7 Displaying Performance Statistics for Propagations That Receive Buffered Messages
- 25.2.8 Viewing the Apply Processes Dequeuing Messages from Each Buffered Queue
- 25.3
Monitoring Oracle Streams Propagations and Propagation Jobs
- 25.3.1 Displaying the Queues and Database Link for Each Propagation
- 25.3.2 Determining the Source Queue and Destination Queue for Each Propagation
- 25.3.3 Determining the Rule Sets for Each Propagation
- 25.3.4 Displaying Information About the Schedules for Propagation Jobs
- 25.3.5 Determining the Total Number of Messages and Bytes Propagated
- 25.3.6 Displaying Information About Propagation Senders
- 25.3.7 Displaying Information About Propagation Receivers
- 25.3.8 Displaying Session Information About Each Propagation
- 26
Monitoring Oracle Streams Apply Processes
- 26.1 Determining the Queue, Rule Sets, and Status for Each Apply Process
- 26.2 Displaying General Information About Each Apply Process
- 26.3 Listing the Parameter Settings for Each Apply Process
- 26.4
Displaying Information About Apply Handlers
- 26.4.1 Displaying Information About DML Handlers
- 26.4.2 Displaying the DDL Handler for Each Apply Process
- 26.4.3 Displaying All of the Error Handlers for Local Apply Processes
- 26.4.4 Displaying the Message Handler for Each Apply Process
- 26.4.5 Displaying the Precommit Handler for Each Apply Process
- 26.5 Displaying Session Information About Each Apply Process
- 26.6 Displaying Information About the Reader Server for Each Apply Process
- 26.7 Monitoring Transactions and Messages Spilled by Each Apply Process
- 26.8 Determining Capture to Dequeue Latency for a Message
- 26.9 Displaying General Information About Each Coordinator Process
- 26.10 Displaying Information About Transactions Received and Applied
- 26.11 Determining the Capture to Apply Latency for a Message for Each Apply Process
- 26.12 Displaying Information About the Apply Servers for Each Apply Process
- 26.13 Displaying Effective Apply Parallelism for an Apply Process
- 26.14 Viewing Rules that Specify a Destination Queue on Apply
- 26.15 Viewing Rules that Specify No Execution on Apply
- 26.16 Determining Which Apply Processes Use Combined Capture and Apply
- 26.17 Displaying the Substitute Key Columns Specified at a Destination Database
- 26.18 Monitoring Virtual Dependency Definitions
- 26.19 Checking for Apply Errors
- 26.20 Displaying Detailed Information About Apply Errors
- 27
Monitoring Rules
- 27.1 Displaying All Rules Used by All Oracle Streams Clients
- 27.2 Displaying the Oracle Streams Rules Used by a Specific Oracle Streams Client
- 27.3 Displaying the Current Condition for a Rule
- 27.4 Displaying Modified Rule Conditions for Oracle Streams Rules
- 27.5 Displaying the Evaluation Context for Each Rule Set
- 27.6 Displaying Information About the Tables Used by an Evaluation Context
- 27.7 Displaying Information About the Variables Used in an Evaluation Context
- 27.8 Displaying All of the Rules in a Rule Set
- 27.9 Displaying the Condition for Each Rule in a Rule Set
- 27.10 Listing Each Rule that Contains a Specified Pattern in Its Condition
- 27.11 Displaying Aggregate Statistics for All Rule Set Evaluations
- 27.12 Displaying Information About Evaluations for Each Rule Set
- 27.13 Determining the Resources Used by Evaluation of Each Rule Set
- 27.14 Displaying Evaluation Statistics for a Rule
- 28 Monitoring Rule-Based Transformations
- 29
Monitoring Other Oracle Streams Components
- 29.1 Monitoring Oracle Streams Administrators and Other Oracle Streams Users
- 29.2 Monitoring the Oracle Streams Pool
- 29.3 Monitoring Compatibility in an Oracle Streams Environment
- 29.4 Monitoring Oracle Streams Performance Using AWR and Statspack
- Part V Troubleshooting an Oracle Streams Environment
- 30 Identifying Problems in an Oracle Streams Environment
- 31
Troubleshooting Implicit Capture
- 31.1
Troubleshooting Capture Process Problems
- 31.1.1 Is Capture Process Creation or Data Dictionary Build Taking a Long Time?
- 31.1.2 Is the Capture Process Enabled?
- 31.1.3 Is the Capture Process Waiting for Redo?
- 31.1.4 Is the Capture Process Paused for Flow Control?
- 31.1.5 Is the Capture Process Current?
- 31.1.6 Are Required Redo Log Files Missing?
- 31.1.7 Is a Downstream Capture Process Waiting for Redo Data?
- 31.1.8 Are You Trying to Configure Downstream Capture Incorrectly?
- 31.1.9 Are You Trying to Configure Downstream Capture without Proper Authentication?
- 31.1.10 Are More Actions Required for Downstream Capture without a Database Link?
- 31.2 Troubleshooting Synchronous Capture Problems
- 31.1
Troubleshooting Capture Process Problems
- 32 Troubleshooting Propagation
- 33
Troubleshooting Apply
- 33.1 Is the Apply Process Enabled?
- 33.2 Is the Apply Process Current?
- 33.3 Does the Apply Process Apply Captured LCRs?
- 33.4 Is the Apply Process's Queue Receiving the Messages to be Applied?
- 33.5 Is a Custom Apply Handler Specified?
- 33.6 Is the AQ_TM_PROCESSES Initialization Parameter Set to Zero?
- 33.7 Does the Apply User Have the Required Privileges?
- 33.8 Is the Apply Process Encountering Contention?
- 33.9 Is the Apply Process Waiting for a Dependent Transaction?
- 33.10 Is an Apply Server Performing Poorly for Certain Transactions?
- 33.11
Are There Any Apply Errors in the Error Queue?
- 33.11.1 Using a DML Handler to Correct Error Transactions
- 33.11.2
Troubleshooting Specific Apply Errors
- 33.11.2.1 ORA-01031 Insufficient Privileges
- 33.11.2.2 ORA-01403 No Data Found
- 33.11.2.3 ORA-23605 Invalid Value for Oracle Streams Parameter
- 33.11.2.4 ORA-23607 Invalid Column
- 33.11.2.5 ORA-24031 Invalid Value, parameter_name Should Be Non-NULL
- 33.11.2.6 ORA-26687 Instantiation SCN Not Set
- 33.11.2.7 ORA-26688 Missing Key in LCR
- 33.11.2.8 ORA-26689 Column Type Mismatch
- 33.11.2.9 ORA-26786 A row with key exists but has conflicting column(s) in table
- 33.11.2.10 ORA-26787 The row with key column_value does not exist in table table_name
- 34 Troubleshooting Rules and Rule-Based Transformations
- Part VI Oracle Streams Information Provisioning
- 35
Information Provisioning Concepts
- 35.1 Overview of Information Provisioning
- 35.2
Bulk Provisioning of Large Amounts of Information
- 35.2.1 Data Pump Export/Import
- 35.2.2 Transportable Tablespace from Backup with RMAN
- 35.2.3
DBMS_STREAMS_TABLESPACE_ADM Procedures
- 35.2.3.1 File Group Repository
- 35.2.3.2
Tablespace Repository
- 35.2.3.2.1 When to Use a Tablespace Repository
- 35.2.3.2.2 Differences Between the Tablespace Repository Procedures
- 35.2.3.2.3 Remote Access to a Tablespace Repository
- 35.2.3.2.4 Only One Tablespace Version Can Be Online in a Database
- 35.2.3.2.5 Tablespace Repository Procedures Use the DBMS_FILE_GROUP Package Automatically
- 35.2.3.2.6 A Tablespace Repository Provides Versioning but Not Source Control
- 35.2.3.3 Read-Only Tablespaces Requirement During Export
- 35.2.3.4 Automatic Platform Conversion for Tablespaces
- 35.2.4 Options for Bulk Information Provisioning
- 35.3 Incremental Information Provisioning with Oracle Streams
- 35.4 On-Demand Information Access
- 36 Using Information Provisioning
- 37 Monitoring File Group and Tablespace Repositories
- 35
Information Provisioning Concepts
- Appendixes
- A
How Oracle Streams Works with Other Database Components
- A.1
Oracle Streams and Oracle Real Application Clusters
- A.1.1 Capture Processes and Oracle Real Application Clusters
- A.1.2 Synchronous Capture and Oracle Real Application Clusters
- A.1.3 Combined Capture and Apply and Oracle Real Application Clusters
- A.1.4 Queues and Oracle Real Application Clusters
- A.1.5 Propagations and Oracle Real Application Clusters
- A.1.6 Apply Processes and Oracle Real Application Clusters
- A.2
Oracle Streams and Transparent Data Encryption
- A.2.1 Capture Processes and Transparent Data Encryption
- A.2.2 Synchronous Capture and Transparent Data Encryption
- A.2.3 Explicit Capture and Transparent Data Encryption
- A.2.4 Queues and Transparent Data Encryption
- A.2.5 Propagations and Transparent Data Encryption
- A.2.6 Apply Processes and Transparent Data Encryption
- A.2.7 Messaging Clients and Transparent Data Encryption
- A.2.8 Manual Dequeue and Transparent Data Encryption
- A.3 Oracle Streams and Flashback Data Archive
- A.4 Oracle Streams and Recovery Manager (RMAN)
- A.5 Oracle Streams and Distributed Transactions
- A.6 Oracle Streams and Oracle Database Vault
- A.1
Oracle Streams and Oracle Real Application Clusters
- B
Oracle Streams Restrictions
- B.1
Capture Process Restrictions
- B.1.1 Unsupported Data Types for Capture Processes
- B.1.2
Unsupported Changes for Capture Processes
- B.1.2.1 Unsupported Schemas for Capture Processes
- B.1.2.2 Unsupported Table Types for Capture Processes
- B.1.2.3 Unsupported DDL Changes for Capture Processes
- B.1.2.4 Changes Ignored by a Capture Process
- B.1.2.5 NOLOGGING and UNRECOVERABLE Keywords for SQL Operations
- B.1.2.6 UNRECOVERABLE Clause for Direct Path Loads
- B.1.3 Supplemental Logging Data Type Restrictions
- B.1.4 Operational Requirements for Downstream Capture
- B.1.5 Capture Processes Do Not Support Oracle Label Security
- B.1.6 Capture Process Interoperability with Oracle Streams Apply Processes
- B.2 Synchronous Capture Restrictions
- B.3 Queue Restrictions
- B.4 Propagation Restrictions
- B.5
Apply Process Restrictions
- B.5.1 Unsupported Data Types for Apply Processes
- B.5.2 Unsupported Data Types for Apply Handlers
- B.5.3 Types of DDL Changes Ignored by an Apply Process
- B.5.4 Database Structures in an Oracle Streams Environment
- B.5.5 Current Schema User Must Exist at Destination Database
- B.5.6 Apply Processes Do Not Support Oracle Label Security
- B.5.7 Apply Process Interoperability with Oracle Streams Capture Components
- B.6 Messaging Client Restrictions
- B.7 Rule Restrictions
- B.8 Rule-Based Transformation Restrictions
- B.9 Oracle Multitenant Option Restrictions for Oracle Streams
- B.1
Capture Process Restrictions
- C XML Schema for LCRs
- D
Online Database Upgrade and Maintenance with Oracle Streams
- D.1 Overview of Using Oracle Streams for Upgrade and Maintenance Operations
- D.2
Preparing for a Database Upgrade or Maintenance Operation
- D.2.1 Preparing for Downstream Capture
- D.2.2 Preparing for Upgrade or Maintenance of a Database with User-Defined Types
- D.2.3 Preparing for Upgrades to User-Created Applications
- D.2.4 Deciding Whether to Configure Oracle Streams Directly or Generate a Script
- D.2.5 Deciding Which Utility to Use for Instantiation
- D.3 Performing a Database Upgrade or Maintenance Operation Using Oracle Streams
- E
Online Upgrade of an Earlier Database with Oracle Streams
- E.1 Overview of Using Oracle Streams in the Database Upgrade Process
- E.2 Preparing for a Database Upgrade Using Oracle Streams
- E.3 Performing a Database Upgrade Using Oracle Streams
- A
How Oracle Streams Works with Other Database Components
- Glossary
- Index