Table of Contents
- Title and Copyright Information
- Preface
-
Part I XStream General Concepts and Use Cases
- 1 Introduction to XStream
-
2
General XStream Concepts
- Logical Change Records (LCRs)
- Rules and Rule Sets
- Rule-Based Transformations
-
XStream and the Oracle Replication Performance Advisor
- XStream Components
- Topology and Stream Paths
- XStream and Component-Level Statistics
- The UTL_RPADV Package
- XStream and SQL Generation
-
Part II XStream Out
-
3
XStream Out Concepts
- Introduction to XStream Out
-
Capture Processes
- Capture Process Overview
- Data Types Captured by a Capture Process
- Types of DML Changes Captured by Capture Processes
- Local Capture and Downstream Capture
- Capture Processes and RESTRICTED SESSION
- Capture Process Subcomponents
- Capture Process States
- Capture Process Parameters
- Capture Process Checkpoints and XStream Out
- SCN Values Related to a Capture Process
- Outbound Servers
- Position of LCRs and XStream Out
- XStream Out and Distributed Transactions
- XStream Out and Security
- XStream Out and Other Oracle Database Components
-
4
Configuring XStream Out
-
Preparing for XStream Out
- Decide How to Configure XStream Out
-
Prerequisites for Configuring XStream Out
- Configure an XStream Administrator on All Databases
- Granting Additional Privileges to the XStream Administrator
- If Required, Configure Network Connectivity and Database Links
- Ensure That Each Source Database Is in ARCHIVELOG Mode
- Set the Relevant Initialization Parameters
- Configure the Streams pool
-
If Required, Configure Supplemental Logging
- Required Supplemental Logging in an XStream 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
- If Required, Configure Log File Transfer to a Downstream Database
- If Required, Add Standby Redo Logs for Real-Time Downstream Capture
- Configuring XStream Out
-
Preparing for XStream Out
-
5
Managing XStream Out
- About Managing XStream Out
- Managing an Outbound Server
-
Managing the Capture Process for an Outbound Server
- Checking Whether the DBMS_XSTREAM_ADM Package Can Manage a Capture Process
- Starting a Capture Process
- Stopping a Capture Process
- Setting a Capture Process Parameter
- Changing the Capture User of an Outbound Server's Capture Process
- Changing the Start SCN or Start Time of an Outbound Server's Capture Process
- Setting the First SCN for a Capture Process
- Managing Rules for an XStream Out Configuration
- Managing Declarative Rule-Based Transformations
- Dropping Components in an XStream Out Configuration
- Removing an XStream Out Configuration
-
6
Monitoring XStream Out
- About Monitoring XStream Out
- Monitoring Session Information About XStream Out Components
- Monitoring the History of Events for XStream Out Components
-
Monitoring an Outbound Server
- Displaying General Information About an Outbound Server
- Displaying Status and Error Information for an Outbound Server
- Displaying Information About an Outbound Server's Current Transaction
- Displaying Statistics for an Outbound Server
- Displaying the Processed Low Position for an Outbound Server
- Determining the Process Information for an Outbound Server
- Displaying the Apply Parameter Settings for an Outbound Server
-
Monitoring the Capture Process for an Outbound Server
- Displaying Change Capture Information About Each Capture Process
- Displaying the Registered Redo Log Files for Each Capture Process
- Displaying Redo Log Files That Are Required by Each Capture Process
- Displaying SCN Values for Each Redo Log File Used by Each Capture Process
- Listing the Parameter Settings for Each Capture Process
- Determining the Applied SCN for Each Capture Process
- Displaying the Redo Log Scanning Latency for Each Capture Process
- Displaying the Extra Attributes Captured by a Capture Process
- Monitoring XStream Rules
- Monitoring Declarative Rule-Based Transformations
-
7
Troubleshooting XStream Out
- Diagnosing Problems with XStream Out
-
Problems and Solutions for XStream Out
- An OCI Client Application Cannot Attach to the Outbound Server
- Changes Are Failing to Reach the Client Application in XStream Out
- The Capture Process Is Missing Required Redo Log Files
- LCRs Streaming from an Outbound Server Are Missing Extra Attributes
- The XStream Out Client Application Is Unresponsive
- How to Get More Help with XStream Out
-
3
XStream Out Concepts
-
Part III XStream In
-
8
XStream In Concepts
- Introduction to XStream In
- The Inbound Server
- Position of LCRs and XStream In
- XStream In and Performance Considerations
- XStream In and Security
- XStream In and Other Oracle Database Components
- 9 Configuring XStream In
-
10
Managing XStream In
- About Managing XStream In
- Starting an Inbound Server
- Stopping an Inbound Server
- Setting an Apply Parameter for an Inbound Server
- Changing the Apply User for an Inbound Server
-
Managing XStream In Conflict Detection and Resolution
- About DML Conflicts in an XStream Environment
- Conflict Types in an XStream Environment
- Conflicts and Transaction Ordering in an XStream Environment
- Conflict Detection in an XStream Environment
- Conflict Avoidance in an XStream Environment
- Conflict Resolution in an XStream Environment
- Managing DML Conflict Handlers
- Stopping Conflict Detection for Non-Key Columns
- Managing Apply Errors
- Conflict and Error Handling Precedence
- Dropping Components in an XStream In Configuration
-
11
Monitoring XStream In
- Displaying Session Information for Inbound Servers
- Displaying General Information About an Inbound Server
- Monitoring the History of Events for XStream In Components
- Displaying the Status and Error Information for an Inbound Server
- Displaying Apply Parameter Settings for an Inbound Server
- Displaying the Position Information for an Inbound Server
- Displaying Information About DML Conflict Handlers
- Displaying Information About Error Handlers
- Checking for Apply Errors
-
Displaying Detailed Information About Apply Errors
- Step 1: Grant Explicit SELECT Privilege on the ALL_APPLY_ERROR View
- Step 2: Create a Procedure that Prints the Value in an ANYDATA Object
- Step 3: Create a Procedure that Prints a Specified LCR
- Step 4: Create a Procedure that Prints All the LCRs in the Error Queue
- 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
- Capture Process Restrictions
- Propagation Restrictions
- Outbound Server Restrictions
- XStream Out Rule Restrictions
- XStream Out Rule-Based Transformation Restrictions
- XStream Out Limitations for Extended Data Types
- C XStream In Restrictions