datapump
提取进程ext1首先将trail生成在本地,然后datapump读取本地trail再发送到目标服务器,即便网络故障,提取进程仍然能随着事务生成trail文件,而datapump则会暂时停止传输,等待网络通畅后在将堆积的本地trail文件发送至目标服务器,从而实现了断点传输的功能。
- ---源端配置
- GGSCI (ogg1) 5> add extract ext1,tranlog,begin now
- GGSCI (ogg1) 6> ADD EXTTRAIL c:\gg\dirdat\sd, EXTRACT EXT1
- GGSCI (ogg1) 7> edit param ext1
- extract ext1
- userid ggs,password ggs
- exttrail c:\gg\dirdat\sd
- dynamicresolution
- gettruncates
- table ggs.*;
- GGSCI (ogg1) 8>
- GGSCI (ogg1) 9>ADD EXTRACT pp1, EXTTRAILSOURCE c:\gg\dirdat\sd
- GGSCI (ogg1) 10>edit param pp1
- extract pp1
- userid ggate, password ggate
- rmthost 192.168.6.10, mgrport 7809
- rmttrail c:\gg\dirdat\lt
- PASSTHRU
- gettruncates
- table ggate.*;
- GGSCI (ogg1) 11>add rmttrail c:\gg\dirdat\lt extract pp1
- GGSCI (ogg1) 12>start mgr
- GGSCI (ogg1) 13>start pp1
- GGSCI (ogg1) 14>start ext1
- ---目标端配置
- GGSCI (ogg2) 2> ADD replicat rep1 EXTTRAIL c:\gg\dirdat\lt,nodbcheckpoint
- GGSCI (ogg2) 3> edit param rep1
- replicat rep1
- userid ggs,password ggs
- assumetargetdefs
- reperror default,discard
- discardfile c:\gg\rep1_dis.log,append,megabytes 100
- map ggs.*, target ggs.*;