1.在GolddenGate文章中,如果网络断开的话,在目标机器上并不能生成trail文件,因此就会出现错误。
2011-04-23 17:44:16 ERROR OGG-01033 There is a problem in network communication, a remote file problem, encryption keys f
or target and source do not match (if using ENCRYPT) or an unknown error. (Remote file used is ./dirdat/ma000001, reply recei
ved is Unable to lock file "./dirdat/ma000001" (error 11, Resource temporarily unavailable). Lock currently held by process
id (PID) 9556.).
2.为了解决以上问题,特增加datadump进程,通过此进程把trail文件先放在本地,待网络畅通后,再传到目标机器的响应文件夹下。
3.添加数据抽取进程
add extract load1, translog, begin now
4.配置本地数据抽取文件位置及抽取进程
add exttrail ./dirdat/