data pump可以看作一个extract组,可以提供过滤,转换等功能,分担一部分主extract的任务
配置了data pump,一旦网络或者target不可用,extract会把数据库保存在磁盘上,这样当网络恢复后,extract会提取数据并发送到target
建议配置该功能
source:
ADD EXTRACT ext2, TRANLOG, BEGIN now
ADD EXTTRAIL E:\gg_forwin\dirdat\p1, EXTRACT ext2
edit param ext2
USERID test1, PASSWORD test1
EXTTRAIL E:\gg_forwin\dirdat\p1
TABLE load1.*;
ADD EXTRACT pump, EXTTRAILSOURCE E:\gg_forwin\dirdat\p1, BEGIN now
ADD RMTTRAIL /oracle/gg/dirdat/p1, EXTRACT pump
edit param pump
EXTRACT pump
USERID test1, PASSWORD test1
RMTHOST 192.168.137.127, mgrport 7809
RMTTRAIL /oracle/gg/dirdat/p1
TABLE load1.*;
target :
EDIT PARAMS ./GLOBALS
CHECKPOINTTABLE ogg.ckpt_table
DBLOGIN USERID ogg@target10 PASSWORD oracle
ADD CHECKPOINTTABLE test1.ckpt_table
ADD REPLICAT rep_pump, EXTTRAIL /oracle/gg/dirdat/p1, BEGIN now
edit param rep_pump
REPLICAT rep_pump
ASSUMETARGETDEFS
USERID test1, PASSWORD test1
reperror default,discard
discardfile /oracle/gg/rep_pump.dsc,append,megabytes 100
MAP load1.*, target load2.*;
阅读(735) | 评论(0) | 转发(0) |