OGG_Best_Practice_-_Configuring_Downstream_Integrated_Extract_v20-1485620.pdf
免费下载
Oracle GoldenGate Best Practices: Configuring Downstream Integrated Extract
An Oracle White Paper
July 2012
Oracle GoldenGate Best Practices: Configuring
Downstream Integrated Extract
Document ID: 1485620.1
Last Update: 10 November 2014
Oracle GoldenGate Best Practices: Configuring Downstream Integrated Extract
2
DOCUMENT ID: 1485620.1 .............................................................................. 1
EXECUTIVE OVERVIEW ................................................................................. 5
INTRODUCTION ............................................................................................... 6
DOWNSTREAM INTEGRATED EXTRACT SETUP ......................................... 7
Evaluating capture options for a downstream deployment .................................................................. 7
Configuring redo transport from a source to the downstream mining database ............................... 8
Creating a mining user account and source database user account .................................................. 10
Set Streams pool at downstream mining database .............................................................................. 10
Preparing a downstream mining database for real-time capture ...................................................... 11
Configure the downstream database to archive local redo data ........................................................... 11
Configure the downstream database to receive and write shipped redo data locally ........................... 11
Create the standby redo log files for real-time downstream mining .................................................... 12
Create the Downstream Integrated Extract ........................................................................................ 14
OPTIONAL PARAMETERS FOR INTEGRATED EXTRACT ......................... 14
DATABASE PATCHING OR UPGRADE CONSIDERATIONS ...................... 15
EXAMPLE 1: CONFIGURATION OF REAL-TIME DOWNSTREAM MINING
DATABASE FOR INTEGRATED EXTRACT.................................................. 16
Configure the downstream database to archive the local redo data .................................................. 17
Prepare the mining database to accept redo from the source database ............................................ 17
Prepare the source database to send redo to the mining database .................................................... 18
Configure the downstream database to receive and write shipped foreign redo data ..................... 19
Set up Integrated Extract on DBMSCAP ............................................................................................ 19
of 41
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论