没有合适的资源?快使用搜索试试~ 我知道了~
Oracle Database XStream Guide 11g Release 2 (11.2)-302
需积分: 5 0 下载量 10 浏览量
2023-06-18
13:28:37
上传
评论
收藏 3.83MB PDF 举报
温馨提示
试读
302页
Oracle Database XStream Guide 11g Release 2 (11.2)-302
资源推荐
资源详情
资源评论
Oracle® Database
XStream Guide
11g Release 2 (11.2)
E16545-09
July 2013
Oracle Database XStream Guide, 11g Release 2 (11.2)
E16545-09
Copyright © 2009, 2013, Oracle and/or its affiliates. All rights reserved.
Primary Author: Randy Urbano
Contributors: Lance Ashdown, Vinoth Chandar, Alan Downing, Thuvan Hoang, Richard Huang, Joydip
Kundu, Tianshu Li, Edwina Lu, Rui Mao, Pat McElroy, Valarie Moore, Srikanth Nalla, Partha Raghunathan,
Ashish Ray, Jim Stamos, Byron Wang, Lik Wong, Jun Yuan, Rod Ward, Haobo Xu, Kevin Xu
This software and related documentation are provided under a license agreement containing restrictions on
use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your
license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,
transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse
engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is
prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If
you find any errors, please report them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it
on behalf of the U.S. Government, the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software,
any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users
are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and
agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and
adaptation of the programs, including any operating system, integrated software, any programs installed on
the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to
the programs. No other rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management
applications. It is not developed or intended for use in any inherently dangerous applications, including
applications that may create a risk of personal injury. If you use this software or hardware in dangerous
applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other
measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages
caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of
their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks
are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD,
Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced
Micro Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information on content, products,
and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly
disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle
Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your
access to or use of third-party content, products, or services.
iii
Contents
Preface ................................................................................................................................................................. ix
Audience....................................................................................................................................................... ix
Documentation Accessibility..................................................................................................................... ix
Related Documents ..................................................................................................................................... ix
Conventions ................................................................................................................................................. x
Part I XStream Concepts and Use Cases
1 Introduction to XStream
About XStream.......................................................................................................................................... 1-1
Purpose of XStream.................................................................................................................................. 1-3
Prerequisites for XStream ....................................................................................................................... 1-3
Tasks and Tools for XStream ................................................................................................................. 1-4
XStream Tasks..................................................................................................................................... 1-4
XStream Tools..................................................................................................................................... 1-4
2 XStream Concepts
XStream Out .............................................................................................................................................. 2-1
The Outbound Server ........................................................................................................................ 2-2
Outbound Servers and Apply Process Features..................................................................... 2-3
ID Key LCRs........................................................................................................................................ 2-6
ID Key LCRs Demo..................................................................................................................... 2-7
Sequence LCRs ................................................................................................................................... 2-7
Considerations for XStream Outbound Servers ............................................................................ 2-8
XStream Out and Distributed Transactions ................................................................................... 2-8
XStream In ................................................................................................................................................. 2-9
The Inbound Server ........................................................................................................................ 2-10
Considerations for XStream Inbound Servers ............................................................................ 2-10
Position Order in an LCR Stream....................................................................................................... 2-11
About Position Order ..................................................................................................................... 2-11
Position of LCRs and XStream Out .............................................................................................. 2-12
Additional LCR Attributes Related to Position................................................................... 2-12
The Processed Low Position and Restartability for XStream Out .................................... 2-12
Streaming Network Transmission......................................................................................... 2-13
Position of LCRs and XStream In.................................................................................................. 2-13
iv
Summary of Position Use in XStream Out and XStream In...................................................... 2-16
XStream and SQL Generation............................................................................................................. 2-16
Interfaces for Performing SQL Generation.................................................................................. 2-16
SQL Generation Formats................................................................................................................ 2-17
Data Types and Character Sets ..................................................................................................... 2-17
SQL Generation Demo ................................................................................................................... 2-17
XStream and Security ........................................................................................................................... 2-18
Other Ways to Share Information in a Heterogeneous Environment......................................... 2-18
3 XStream Use Cases
Introduction to XStream Use Cases ...................................................................................................... 3-1
XStream Out Use Cases..................................................................................................................... 3-1
XStream In Use Cases........................................................................................................................ 3-2
Replicating Data Changes with Non-Oracle Databases................................................................... 3-2
Using Files to Store Data Changes........................................................................................................ 3-2
XStream Demo That Replicates Database Changes Using Files.................................................. 3-3
Sharing Data Changes with a Client-Side Memory Cache.............................................................. 3-3
Part II XStream Administration
4 Configuring XStream
Preparing for XStream............................................................................................................................. 4-1
Granting Privileges for the XStream Administrator ..................................................................... 4-1
Preparing for XStream Out............................................................................................................... 4-7
Decide How to Configure XStream.......................................................................................... 4-7
Prerequisites for Configuring XStream Out......................................................................... 4-12
Preparing for XStream In ............................................................................................................... 4-15
Configure an XStream Administrator................................................................................... 4-15
Set the Relevant Initialization Parameters Relevant........................................................... 4-15
Configure the Oracle Streams Pool ....................................................................................... 4-15
Configuring XStream Out.................................................................................................................... 4-15
Configuring an XStream Outbound Server................................................................................. 4-16
Configuring Multiple XStream Out Components Using CREATE_OUTBOUND ........ 4-16
Configuring an Outbound Server Using ADD_OUTBOUND.......................................... 4-18
Adding an Additional Outbound Server to a Capture Process Stream.................................. 4-23
Configuring XStream In....................................................................................................................... 4-25
Sample XStream Client Application ................................................................................................. 4-27
Sample XStream Client Application for the Oracle Call Interface API................................... 4-28
Sample XStream Client Application for the Java API................................................................ 4-42
5 Managing XStream
About Managing XStream ...................................................................................................................... 5-1
Managing XStream Out........................................................................................................................... 5-2
Checking Whether the DBMS_XSTREAM_ADM Package Can Manage a Capture Process.. 5-2
Managing Rules for an XStream Out Configuration .................................................................... 5-4
Adding Rules to an XStream Out Configuration ................................................................... 5-4
v
Removing Rules from an XStream Out Configuration ......................................................... 5-7
Changing the Connect User for an Outbound Server .................................................................. 5-9
Changing the Capture User of the Capture Process for an Outbound Server....................... 5-10
Changing the Start SCN or Start Time of the Capture Process for an Outbound Server..... 5-11
Changing the Start SCN of the Capture Process for an Outbound Server...................... 5-11
Changing the Start Time of the Capture Process for an Outbound Server ..................... 5-12
Dropping Components in an XStream Out Configuration....................................................... 5-13
Managing XStream In........................................................................................................................... 5-14
Changing the Apply User for an Inbound Server ...................................................................... 5-15
Managing Eager Errors Encountered by an Inbound Server ................................................... 5-16
Dropping Components in an XStream In Configuration.......................................................... 5-19
6 Monitoring XStream
About Monitoring XStream.................................................................................................................... 6-1
Monitoring Session Information About XStream Components ..................................................... 6-2
Monitoring XStream Out ........................................................................................................................ 6-3
Displaying General Information About an Outbound Server..................................................... 6-3
Displaying Status and Error Information for an Outbound Server............................................ 6-5
Displaying Information About an Outbound Server’s Current Transaction............................ 6-5
Displaying Statistics for an Outbound Server ............................................................................... 6-6
Displaying the Processed Low Position for an Outbound Server .............................................. 6-8
Determining the Process Information for an Outbound Server.................................................. 6-9
Monitoring XStream In ........................................................................................................................ 6-10
Displaying General Information About an Inbound Server..................................................... 6-10
Displaying the Status and Error Information for an Inbound Server ..................................... 6-11
Displaying the Position Information for an Inbound Server.................................................... 6-11
Monitoring XStream Rules.................................................................................................................. 6-12
XStream and the Oracle Streams Performance Advisor ................................................................ 6-13
XStream Components..................................................................................................................... 6-14
Topology and Stream Paths........................................................................................................... 6-14
XStream and Component-Level Statistics ................................................................................... 6-14
The UTL_SPADV Package............................................................................................................. 6-15
Sample Output When an Outbound Server Is the Last Component in a Path ............... 6-16
Sample Output When an Inbound Server Is the Last Component in a Path .................. 6-16
7 Troubleshooting XStream
Diagnosing Problems with XStream .................................................................................................... 7-1
Problems and Solutions for XStream ................................................................................................... 7-1
An OCI Client Application Cannot Attach to the Outbound Server.......................................... 7-2
Changes Are Failing to Reach the Client Application in XStream Out...................................... 7-2
LCRs Streaming from an Outbound Server Are Missing Extra Attributes ............................... 7-4
The XStream Out Client Application Is Unresponsive................................................................. 7-5
XStream In Cannot Identify an Inbound Server............................................................................ 7-6
Changes Are Not Being Applied by an Inbound Server.............................................................. 7-7
How to Get More Help with XStream.................................................................................................. 7-8
剩余301页未读,继续阅读
资源评论
weixin_40191861_zj
- 粉丝: 64
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功