Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Database XStream Guide
-
Part I XStream General Concepts and Use Cases
- 1 Introduction to XStream
-
2
General XStream Concepts
- 2.1 Logical Change Records (LCRs)
- 2.2 Rules and Rule Sets
- 2.3 Rule-Based Transformations
-
2.4
XStream and the Oracle Replication Performance Advisor
- 2.4.1 XStream Components
- 2.4.2 Topology and Stream Paths
- 2.4.3 XStream and Component-Level Statistics
- 2.4.4 The UTL_RPADV Package
- 2.5 XStream and SQL Generation
-
Part II XStream Out
-
3
XStream Out Concepts
- 3.1 Introduction to XStream Out
-
3.2
Capture Processes
- 3.2.1 Capture Process Overview
- 3.2.2 Data Types Captured by a Capture Process
- 3.2.3 Types of DML Changes Captured by Capture Processes
-
3.2.4
Local Capture and Downstream Capture
- 3.2.4.1 Local Capture
-
3.2.4.2
Downstream Capture
- 3.2.4.2.1 Real-Time Downstream Capture
- 3.2.4.2.2 Archived-Log Downstream Capture
- 3.2.4.2.3 The Downstream Database Performs Most Change Capture Actions
- 3.2.4.2.4 Advantages of Downstream Capture
- 3.2.4.2.5 Optional Database Link From the Downstream Database to the Source Database
- 3.2.4.2.6 Operational Requirements for Downstream Capture with XStream Out
- 3.2.5 Capture Processes and RESTRICTED SESSION
- 3.2.6 Capture Process Subcomponents
- 3.2.7 Capture Process States
- 3.2.8 Capture Process Parameters
- 3.2.9 Capture Process Checkpoints and XStream Out
- 3.2.10 SCN Values Related to a Capture Process
- 3.3 Outbound Servers
- 3.4 Position of LCRs and XStream Out
- 3.5 XStream Out and Distributed Transactions
- 3.6 XStream Out and Security
- 3.7 XStream Out and Other Oracle Database Components
-
4
Configuring XStream Out
-
4.1
Preparing for XStream Out
- 4.1.1 Decide How to Configure XStream Out
-
4.1.2
Prerequisites for Configuring XStream Out
- 4.1.2.1 Configure an XStream Administrator on All Databases
- 4.1.2.2 Granting Additional Privileges to the XStream Administrator
- 4.1.2.3 If Required, Configure Network Connectivity and Database Links
- 4.1.2.4 Ensure That Each Source Database Is in ARCHIVELOG Mode
- 4.1.2.5 Set the Relevant Initialization Parameters
- 4.1.2.6 Configure the Streams pool
-
4.1.2.7
If Required, Configure Supplemental Logging
- 4.1.2.7.1 Required Supplemental Logging in an XStream Environment
- 4.1.2.7.2 Specifying Table Supplemental Logging Using Unconditional Log Groups
- 4.1.2.7.3 Specifying Table Supplemental Logging Using Conditional Log Groups
- 4.1.2.7.4 Dropping a Supplemental Log Group
- 4.1.2.7.5 Specifying Database Supplemental Logging of Key Columns
- 4.1.2.7.6 Dropping Database Supplemental Logging of Key Columns
- 4.1.2.7.7 Procedures That Automatically Specify Supplemental Logging
- 4.1.2.8 If Required, Configure Log File Transfer to a Downstream Database
- 4.1.2.9 If Required, Add Standby Redo Logs for Real-Time Downstream Capture
- 4.2 Configuring XStream Out
-
4.1
Preparing for XStream Out
-
5
Managing XStream Out
- 5.1 About Managing XStream Out
- 5.2 Managing an Outbound Server
-
5.3
Managing the Capture Process for an Outbound Server
- 5.3.1 Checking Whether the DBMS_XSTREAM_ADM Package Can Manage a Capture Process
- 5.3.2 Starting a Capture Process
- 5.3.3 Stopping a Capture Process
- 5.3.4 Setting a Capture Process Parameter
- 5.3.5 Changing the Capture User of an Outbound Server's Capture Process
- 5.3.6 Changing the Start SCN or Start Time of an Outbound Server's Capture Process
- 5.3.7 Setting the First SCN for a Capture Process
- 5.4 Managing Rules for an XStream Out Configuration
- 5.5 Managing Declarative Rule-Based Transformations
- 5.6 Dropping Components in an XStream Out Configuration
- 5.7 Removing an XStream Out Configuration
-
6
Monitoring XStream Out
- 6.1 About Monitoring XStream Out
- 6.2 Monitoring Session Information About XStream Out Components
- 6.3 Monitoring the History of Events for XStream Out Components
-
6.4
Monitoring an Outbound Server
- 6.4.1 Displaying General Information About an Outbound Server
- 6.4.2 Displaying Status and Error Information for an Outbound Server
- 6.4.3 Displaying Information About an Outbound Server's Current Transaction
- 6.4.4 Displaying Statistics for an Outbound Server
- 6.4.5 Displaying the Processed Low Position for an Outbound Server
- 6.4.6 Determining the Process Information for an Outbound Server
- 6.4.7 Displaying the Apply Parameter Settings for an Outbound Server
-
6.5
Monitoring the Capture Process for an Outbound Server
- 6.5.1 Displaying Change Capture Information About Each Capture Process
- 6.5.2 Displaying the Registered Redo Log Files for Each Capture Process
- 6.5.3 Displaying Redo Log Files That Are Required by Each Capture Process
- 6.5.4 Displaying SCN Values for Each Redo Log File Used by Each Capture Process
- 6.5.5 Listing the Parameter Settings for Each Capture Process
- 6.5.6 Determining the Applied SCN for Each Capture Process
- 6.5.7 Displaying the Redo Log Scanning Latency for Each Capture Process
- 6.5.8 Displaying the Extra Attributes Captured by a Capture Process
- 6.6 Monitoring XStream Rules
- 6.7 Monitoring Declarative Rule-Based Transformations
-
7
Troubleshooting XStream Out
- 7.1 Diagnosing Problems with XStream Out
-
7.2
Problems and Solutions for XStream Out
- 7.2.1 An OCI Client Application Cannot Attach to the Outbound Server
- 7.2.2 Changes Are Failing to Reach the Client Application in XStream Out
- 7.2.3 The Capture Process Is Missing Required Redo Log Files
- 7.2.4 LCRs Streaming from an Outbound Server Are Missing Extra Attributes
- 7.2.5 The XStream Out Client Application Is Unresponsive
- 7.3 How to Get More Help with XStream Out
-
3
XStream Out Concepts
-
Part III XStream In
-
8
XStream In Concepts
- 8.1 Introduction to XStream In
- 8.2 The Inbound Server
- 8.3 Position of LCRs and XStream In
- 8.4 XStream In and Performance Considerations
- 8.5 XStream In and Security
- 8.6 XStream In and Other Oracle Database Components
- 9 Configuring XStream In
-
10
Managing XStream In
- 10.1 About Managing XStream In
- 10.2 Starting an Inbound Server
- 10.3 Stopping an Inbound Server
- 10.4 Setting an Apply Parameter for an Inbound Server
- 10.5 Changing the Apply User for an Inbound Server
-
10.6
Managing XStream In Conflict Detection and Resolution
- 10.6.1 About DML Conflicts in an XStream Environment
- 10.6.2 Conflict Types in an XStream Environment
- 10.6.3 Conflicts and Transaction Ordering in an XStream Environment
- 10.6.4 Conflict Detection in an XStream Environment
- 10.6.5 Conflict Avoidance in an XStream Environment
-
10.6.6
Conflict Resolution in an XStream Environment
- 10.6.6.1 About Conflict Resolution in an XStream Environment
- 10.6.6.2 Prebuilt DML Conflict Handlers
- 10.6.6.3 Types of Prebuilt DML Conflict Handlers
- 10.6.6.4 Column Lists
- 10.6.6.5 Resolution Columns
- 10.6.6.6 Data Convergence
- 10.6.6.7 Collision Handling Without a DML Conflict Handler
- 10.6.6.8 Custom Conflict Handlers
- 10.6.7 Managing DML Conflict Handlers
- 10.6.8 Stopping Conflict Detection for Non-Key Columns
- 10.7 Managing Apply Errors
- 10.8 Conflict and Error Handling Precedence
- 10.9 Dropping Components in an XStream In Configuration
-
11
Monitoring XStream In
- 11.1 Displaying Session Information for Inbound Servers
- 11.2 Displaying General Information About an Inbound Server
- 11.3 Monitoring the History of Events for XStream In Components
- 11.4 Displaying the Status and Error Information for an Inbound Server
- 11.5 Displaying Apply Parameter Settings for an Inbound Server
- 11.6 Displaying the Position Information for an Inbound Server
- 11.7 Displaying Information About DML Conflict Handlers
- 11.8 Displaying Information About Error Handlers
- 11.9 Checking for Apply Errors
-
11.10
Displaying Detailed Information About Apply Errors
- 11.10.1 Step 1: Grant Explicit SELECT Privilege on the ALL_APPLY_ERROR View
- 11.10.2 Step 2: Create a Procedure that Prints the Value in an ANYDATA Object
- 11.10.3 Step 3: Create a Procedure that Prints a Specified LCR
- 11.10.4 Step 4: Create a Procedure that Prints All the LCRs in the Error Queue
- 11.10.5 Step 5: Create a Procedure that Prints All the Error LCRs for a Transaction
- 12 Troubleshooting XStream In
-
8
XStream In Concepts
-
Part IV Oracle GoldenGate Capabilities in Oracle Database
- 13 Oracle GoldenGate Automatic Conflict Detection and Resolution
- 14 Oracle GoldenGate Procedural Replication
-
Appendixes
- A Sample XStream Client Application
-
B
XStream Out 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 with XStream Out
- B.1.5 Capture Processes Do Not Support Oracle Label Security
- B.2 Propagation Restrictions
- B.3 Outbound Server Restrictions
- B.4 XStream Out Rule Restrictions
- B.5 XStream Out Rule-Based Transformation Restrictions
- B.6 XStream Out Limitations for Extended Data Types
-
B.1
Capture Process Restrictions
- C XStream In Restrictions
- Index