没有合适的资源?快使用搜索试试~ 我知道了~
Oracle Database 2 Day + Data Replication and Integration Guide 1
需积分: 5 0 下载量 53 浏览量
2023-06-18
13:35:27
上传
评论
收藏 2.61MB PDF 举报
温馨提示
试读
244页
Oracle Database 2 Day + Data Replication and Integration Guide 1g Release 2 (11.2)-244
资源推荐
资源详情
资源评论
Oracle® Database
2 Day + Data Replication and Integration Guide
11g Release 2 (11.2)
E17516-08
August 2011
Covers using Oracle Streams, materialized views, and other
distributed database functionality
Oracle Database 2 Day + Data Replication and Integration Guide, 11g Release 2 (11.2)
E17516-08
Copyright © 2007, 2011, Oracle and/or its affiliates. All rights reserved.
Primary Author: Randy Urbano
Contributor: Janet Blowney, Steve Fogel, Vira Goorah, Thuvan Hoang, Stella Kister, Sushil Kumar, Patricia
McElroy, Colin McGregor, Ashok Mishra, Valarie Moore, Ashish Ray, Subbanarasimha Shastry, Sreejesh
Srinivasan, Jim Stamos, Mark Townsend, Byron Wang, Lik Wong, Jingwei Wu, Jun Yuan
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 RIGHTS Programs, software, databases, and related documentation and technical data
delivered to U.S. Government customers are "commercial computer software" or "commercial technical data"
pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As
such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and
license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of
the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software
License (December 2007). Oracle America, Inc., 500 Oracle Parkway, Redwood City, CA 94065.
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
1 Introduction to Data Replication and Integration
About This Guide..................................................................................................................................... 1-1
Before Using This Guide ................................................................................................................... 1-1
What This Guide Is Not..................................................................................................................... 1-2
About Data Replication and Integration ............................................................................................. 1-2
About Data Replication and Integration Features............................................................................. 1-3
When to Access and Modify Information in Multiple Databases............................................... 1-4
When to Replicate Data with Oracle Streams................................................................................ 1-4
When to Replicate Data with Materialized Views ........................................................................ 1-5
When to Send Messages Between Databases................................................................................. 1-6
2 Common Data Replication and Integration Tasks
Setting the GLOBAL_NAMES Initialization Parameter to TRUE ................................................. 2-1
Tutorial: Configuring an Oracle Streams Administrator.................................................................. 2-2
Tutorial: Creating the Tablespace for the Oracle Streams Administrator ................................. 2-3
Tutorial: Creating an Oracle Streams Administrator.................................................................... 2-5
Creating an ANYDATA Queue.............................................................................................................. 2-7
Tutorial: Creating a Database Link ....................................................................................................... 2-8
3 Accessing and Modifying Information in Multiple Databases
About Accessing and Modifying Information in Multiple Databases.......................................... 3-1
About Distributed SQL ..................................................................................................................... 3-2
About Synonyms and Location Transparency .............................................................................. 3-2
About Accessing and Modifying Information in Non-Oracle Databases.................................. 3-2
About Stored Procedures.................................................................................................................. 3-3
Preparing to Access and Modify Information in Multiple Oracle Databases.............................. 3-3
Tutorial: Querying Multiple Oracle Databases .................................................................................. 3-4
Tutorial: Modifying Data in Multiple Oracle Databases ................................................................. 3-5
Tutorial: Running a Stored Procedure in a Remote Oracle Database ............................................ 3-7
iv
Working with Data in Non-Oracle Databases .................................................................................... 3-8
Configuring Oracle Databases to Work with Non-Oracle Databases ........................................ 3-8
Best Practices for Working with Non-Oracle Databases .............................................................. 3-9
4 Replicating Data Using Oracle Streams
About Oracle Streams Replication........................................................................................................ 4-1
About Change Capture ..................................................................................................................... 4-2
About Change Capture with a Capture Process .................................................................... 4-3
About Change Capture with a Synchronous Capture .......................................................... 4-4
About Change Propagation Between Databases........................................................................... 4-5
About Change Apply......................................................................................................................... 4-6
About Rules for Controlling the Behavior of Capture, Propagation, and Apply..................... 4-7
About Rule-Based Transformations for Nonidentical Copies..................................................... 4-8
About Supplemental Logging.......................................................................................................... 4-9
About Conflicts and Conflict Resolution........................................................................................ 4-9
About Tags for Avoiding Change Cycling.................................................................................. 4-10
About the Common Types of Oracle Streams Replication Environments ............................. 4-11
About Two-Database Replication Environments................................................................ 4-11
About Hub-And-Spoke Replication Environments............................................................ 4-12
About N-Way Replication Environments ............................................................................ 4-14
About Key Oracle Streams Supplied PL/SQL Packages and Data Dictionary Views ......... 4-15
About Key Oracle Streams Supplied PL/SQL Packages ................................................... 4-16
About Key Oracle Streams Data Dictionary Views ............................................................ 4-17
Preparing for Oracle Streams Replication........................................................................................ 4-18
Configuring Oracle Streams Replication: Examples...................................................................... 4-19
Tutorial: Configuring Two-Database Replication with Local Capture Processes................. 4-21
Tutorial: Configuring Two-Database Replication with a Downstream Capture Process .... 4-27
Tutorial: Configuring Hub-and-Spoke Replication with Local Capture Processes .............. 4-34
Tutorial: Configuring Two-Database Replication with Synchronous Captures.................... 4-42
Tutorial: Configuring Latest Time Conflict Resolution for a Table ......................................... 4-52
5 Administering an Oracle Streams Replication Environment
Managing an Oracle Streams Replication Environment .................................................................. 5-1
Managing Capture Processes ........................................................................................................... 5-2
Starting and Stopping a Capture Process................................................................................ 5-2
Setting a Capture Process Parameter ....................................................................................... 5-3
Enabling and Disabling a Propagation ........................................................................................... 5-5
Managing Apply Processes .............................................................................................................. 5-6
Starting and Stopping an Apply Process................................................................................. 5-6
Setting an Apply Process Parameter........................................................................................ 5-7
Monitoring an Oracle Streams Replication Environment................................................................ 5-9
Displaying an Overview of the Replication Components at a Database................................... 5-9
Displaying the Stream Paths ......................................................................................................... 5-10
Displaying Performance Analysis Information for Oracle Streams Components ................ 5-11
Displaying the Topology of the Oracle Streams Environment at a Database ........................ 5-12
Monitoring Capture Processes ...................................................................................................... 5-13
Viewing Information About a Capture Process .................................................................. 5-14
v
Viewing Statistics for a Capture Process .............................................................................. 5-15
Viewing Active Capture Process Transactions.................................................................... 5-17
Monitoring Propagations............................................................................................................... 5-19
Viewing Information About a Propagation ......................................................................... 5-19
Viewing Statistics for a Propagation ..................................................................................... 5-20
Monitoring Apply Processes ......................................................................................................... 5-22
Viewing Information About an Apply Process................................................................... 5-23
Viewing Statistics for an Apply Process............................................................................... 5-24
Viewing Active and Spilled Apply Process Transactions.................................................. 5-26
Displaying the Configured Update Conflict Handlers ...................................................... 5-28
Viewing Buffered Queue Statistics............................................................................................... 5-29
Troubleshooting an Oracle Streams Replication Environment ................................................... 5-30
Responding to Automated Alerts in Enterprise Manager ........................................................ 5-31
Capture Aborts Alert............................................................................................................... 5-32
Propagation Aborts Alert........................................................................................................ 5-32
Apply Aborts Alert.................................................................................................................. 5-33
Apply Error Alert..................................................................................................................... 5-34
Oracle Streams Pool Alert....................................................................................................... 5-34
Managing Apply Errors ................................................................................................................. 5-35
Correcting Apply Errors in Database Objects...................................................................... 5-35
Retrying or Deleting Apply Error Transactions.................................................................. 5-36
Managing a Replication Environment When a Destination Is Unavailable........................... 5-38
6 Extending an Oracle Streams Replication Environment
About Extending an Oracle Streams Replication Environment ..................................................... 6-1
Tutorial: Adding Database Objects to a Replication Environment................................................ 6-3
Tutorial: Adding Databases to a Replication Environment ............................................................. 6-7
7 Replicating Data Using Materialized Views
About Materialized View Replication ................................................................................................. 7-1
About Master Sites, Master Tables, and Materialized View Sites............................................... 7-2
About Materialized View Refresh ................................................................................................... 7-2
About Refresh Groups....................................................................................................................... 7-3
Preparing for Materialized View Replication..................................................................................... 7-3
Configuring Materialized View Sites .................................................................................................. 7-4
Configuring Materialized View Logs at the Master Site.................................................................. 7-6
Replicating Read-Only Data Using Materialized Views.................................................................. 7-7
About Replicating Read-Only Data Using Materialized Views.................................................. 7-8
Tutorial: Configuring Read-Only Data Replication Using Materialized Views....................... 7-9
Replicating Read/Write Data Using Materialized Views .............................................................. 7-12
About Replicating Read/Write Data Using Materialized Views............................................. 7-12
About Replication Groups and Updatable Materialized Views ....................................... 7-13
About Scheduled Links and Deferred Transactions........................................................... 7-15
About Conflicts and Updatable Materialized Views.......................................................... 7-16
Configuring Replication of Read/Write Data Using Materialized Views.............................. 7-16
Configuring a Refresh Group............................................................................................................. 7-23
剩余243页未读,继续阅读
资源评论
weixin_40191861_zj
- 粉丝: 62
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功