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/ex, extract load1, megab

当GoldenGate网络断开导致目标机器无法生成trail文件时,通过增加datadump进程,将trail文件先存储在本地,待网络恢复后再传输。配置包括添加extract、exttrail、rmttrail等步骤,并解决在启动pump1时遇到的错误。
最低0.47元/天 解锁文章
1408

被折叠的 条评论
为什么被折叠?



