168大数据

标题: OGG-01193 Remote tasks cannot be used when other targets files or trails are ... [打印本页]

作者: dbdream 时间: 2015-5-28 11:19
标题: OGG-01193 Remote tasks cannot be used when other targets files or trails are ...

最近做OGG测试，MYSQL-ORACLE单向同步，遇到OGG-01193 Remote tasks cannot be used when other targets files or trails are specified.错误。

MYSQL版本5.6，ORACLE版本11.2.0.4，OGG版本11.2.1.0.1。

2015-05-26 15:35:15 ERROR OGG-01193 Remote tasks cannot be used when other targets files or trails are specified.

2015-05-26 15:35:15 ERROR OGG-01668 PROCESS ABENDING.

抽取进程参数配置如下：

EXTRACT EMYSQL
FETCHOPTIONS FETCHPKUPDATECOLS
dboptions host localhost, connectionport 3306
SOURCEDB xxx, USERID ogg, PASSWORD 123456
RMTHOST xx.xx.xx.xx, MGRPORT 7809
rmtfile /home/app/ggs/dirdat/lo,maxfiles 999999,megabytes 100
rmttask replicat, group rora
TABLE xxx.xxxxxx;

这个错误的原因是rmttask和rmtfile不能同时出现导致的，如果使用rmtfile，就不能使用rmttask。

EXTRACT EMYSQL
FETCHOPTIONS FETCHPKUPDATECOLS
dboptions host localhost, connectionport 3306
SOURCEDB xxx, USERID ogg, PASSWORD 123456
RMTHOST xx.xx.xx.xx, MGRPORT 7809
rmtfile /home/app/ggs/dirdat/lo,maxfiles 999999,megabytes 100
--rmttask replicat, group rora
TABLE xxx.xxxxxx;

注释掉rmttask后，即可解决这个问题。

[groupid=393]Oracle DBA交流[/groupid]

欢迎光临 168大数据 (http://www.bi168.cn/)