Oracle GoldenGate 系列:配置 Data Pump 进程实现多点传输

本文详细介绍了如何使用Oracle GoldenGate的RMTHOST和ADD RMTTRAIL参数配置Data Pump进程,实现从本地到多个远程系统的多点数据传输。通过示例展示了配置过程,并解释了配置中遇到的问题及解决方法,强调了正确的Trail分配和顺序对数据投递的重要性。
摘要由CSDN通过智能技术生成

RMTHOST

Valid for Extract

Use the RMTHOST parameterto:

Identifya remote system to which the local Extract process connects

Specifythe TCP/IP port number on that system where the Manager process is running

Controlvarious attributes of the TCP/IP connections

This parametercontrols compression, data encryption, buffer attributes, TCP/IP

streaming,connection timeout threshold, and the wait period for a connection request. It

also can be used toset Collector parameters.

To identifymultiple remote systems in a parameter file, use one RMTHOST statement for

each one, followedby the associated trails and table maps, for example:

EXTRACTsales

USERIDggs, PASSWORD AACAAAAAAAAAAAJAUEUGODSCVGJEEIUGKJDJTFNDKEJFFFTC &

AES128,ENCRYPTKEY securekey1

RMTHOSTny, MGRPORT 7888, ENCRYPT AES 192 KEYNAME mykey

RMTTRAIL/ggs/dirdat/aa

TABLEora.orders;

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值