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

DDBBAA nneevveerr sslleeeepp--DDBBAA，，永永不不眠眠 FFooccuuss oonn OOrraaccllee DDaattaabbaassee,, GGooddeennGGaattee aanndd UUnniixx [[ 顶顶]] OOrraaccllee GGoollddeennGGaattee 系系列列：：配配 DDaattaa PPuummpp 进进程程实实现现多多点点传传输输 分类： Oracle GoldenGate Oracle Troubleshooting 2013-05-14 23:10 403人阅读 评论 (0) 收藏 举报 Oracle GoldenGate 系列配 Data Pump进程实现多点传输RMTHOSTADD RMTTRAIL RRMMTTHHOOSSTT VVaalliidd ffoorr 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; RMTHOSTla, MGRPORT 7888, ENCRYPT AES 192 KEYNAME mykey2 RMTTRAIL/ggs/dirdat/bb TABLEora.orders; Do not use RMTHOST for anExtract created in PASSIVE mode. See page 17 for more information about a passive Extract.   AADDDD RRMMTTTTRRAAIILL Use ADD RMTTRAIL tocreate a trail for online processing on a remote system and: ● Assigna maximum file size. ● Associatethe trail with an Extract group. In the parameterfile, specify a RMTHOST entry before any RMTTRAIL entries to identify the remote system andTCP/IP port for the Manager process. SSyynnttaaxx ADD RMTTRAIL trail name,EXTRACT group name