先说问题,后面附上配置:
在源端ggsci中启动start w1extdp 的时候,报错信息如下:在目标端也有类似错误:这些文件的确不存在,但在/opt/gg/trails/下有类似的文件,但文件名比上面的文件名要长(多了3个零)ogg抽取生成的日志文件名称长度,比ogg replicat需要的日志文件名长度要长,所以肯定会报错,
问题是,为什么会产生这种不一致的情况呢?如何解决?--源端配置:
GGSCI (rhel7ogg2.localdomain) 33> view params mgrPORT 7809
USERID goldengate@orcl, PASSWORD goldengate
PURGEOLDEXTRACTS /opt/gg/trails/w1*, USECHECKPOINTS, MINKEEPFILES 10
AUTORESTART ER *, RETRIES 3, WAITMINUTES 5
PURGEMARKERHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 5, FREQUENCYMINUTES 30
ACCESSRULE, PROG SERVER, ALLOW
GGSCI (rhel7ogg2.localdomain) 34> view params w1extEXTRACT w1ext
USERID goldengate@orcl, PASSWORD goldengate
EXTTRAIL /opt/gg/trails/w1
DISCARDFILE w1extdsc,APPEND,MEGABYTES 5
DDL INCLUDE MAPPED
DDLOPTIONS ADDTRANDATA
FETCHOPTIONS, USESNAPSHOT, NOUSELATESTVERSION, MISSINGROW REPORT
STATOPTIONS REPORTFETCH
WARNLONGTRANS 1H, CHECKINTERVAL 5M
TABLE goldengate.*;GGSCI (rhel7ogg2.localdomain) 35> view params w1extdpEXTRACT w1extdp
USERID goldengate@orcl, PASSWORD goldengate
RMTHOST 192.168.56.101, MGRPORT 7809
RMTTRAIL /opt/gg/trails/w1
DISCARDFILE w1extdpdsc,APPEND,MEGABYTES 5
TABLE goldengate.*;
GGSCI (rhel7ogg2.localdomain) 36> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING
EXTRACT RUNNING W1EXT 00:00:00 00:00:02
EXTRACT ABENDED W1EXTDP 18:26:33 00:55:05
-------------------------------------------------------------------------------------
--目标端配置:
GGSCI (rhel7ogg1.localdomain as goldengate@orcl) 83> view params mgrPORT 7809
USERID goldengate@orcl, PASSWORD goldengate
PURGEOLDEXTRACTS /opt/gg/trails/w1*, USECHECKPOINTS, MINKEEPFILES 10
AUTORESTART ER *, RETRIES 3, WAITMINUTES 5
PURGEMARKERHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 5, FREQUENCYMINUTES 30
ACCESSRULE, PROG SERVER, ALLOW
GGSCI (rhel7ogg1.localdomain as goldengate@orcl) 84> view params w1repREPLICAT w1rep
ASSUMETARGETDEFS
USERID goldengate@orcl, PASSWORD goldengate
DISCARDFILE w1repdsc,APPEND,MEGABYTES 5
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
BATCHSQL
DBOPTIONS DEFERREFCONST
DBOPTIONS LOBWRITESIZE 102400
HANDLECOLLISIONS
DDLERROR DEFAULT DISCARD RETRYOP MAXRETRIES 5 RETRYDELAY 20
MAP goldengate.* , TARGET goldengate.* ;
在源端ggsci中启动start w1extdp 的时候,报错信息如下:在目标端也有类似错误:这些文件的确不存在,但在/opt/gg/trails/下有类似的文件,但文件名比上面的文件名要长(多了3个零)ogg抽取生成的日志文件名称长度,比ogg replicat需要的日志文件名长度要长,所以肯定会报错,
问题是,为什么会产生这种不一致的情况呢?如何解决?--源端配置:
GGSCI (rhel7ogg2.localdomain) 33> view params mgrPORT 7809
USERID goldengate@orcl, PASSWORD goldengate
PURGEOLDEXTRACTS /opt/gg/trails/w1*, USECHECKPOINTS, MINKEEPFILES 10
AUTORESTART ER *, RETRIES 3, WAITMINUTES 5
PURGEMARKERHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 5, FREQUENCYMINUTES 30
ACCESSRULE, PROG SERVER, ALLOW
GGSCI (rhel7ogg2.localdomain) 34> view params w1extEXTRACT w1ext
USERID goldengate@orcl, PASSWORD goldengate
EXTTRAIL /opt/gg/trails/w1
DISCARDFILE w1extdsc,APPEND,MEGABYTES 5
DDL INCLUDE MAPPED
DDLOPTIONS ADDTRANDATA
FETCHOPTIONS, USESNAPSHOT, NOUSELATESTVERSION, MISSINGROW REPORT
STATOPTIONS REPORTFETCH
WARNLONGTRANS 1H, CHECKINTERVAL 5M
TABLE goldengate.*;GGSCI (rhel7ogg2.localdomain) 35> view params w1extdpEXTRACT w1extdp
USERID goldengate@orcl, PASSWORD goldengate
RMTHOST 192.168.56.101, MGRPORT 7809
RMTTRAIL /opt/gg/trails/w1
DISCARDFILE w1extdpdsc,APPEND,MEGABYTES 5
TABLE goldengate.*;
GGSCI (rhel7ogg2.localdomain) 36> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING
EXTRACT RUNNING W1EXT 00:00:00 00:00:02
EXTRACT ABENDED W1EXTDP 18:26:33 00:55:05
-------------------------------------------------------------------------------------
--目标端配置:
GGSCI (rhel7ogg1.localdomain as goldengate@orcl) 83> view params mgrPORT 7809
USERID goldengate@orcl, PASSWORD goldengate
PURGEOLDEXTRACTS /opt/gg/trails/w1*, USECHECKPOINTS, MINKEEPFILES 10
AUTORESTART ER *, RETRIES 3, WAITMINUTES 5
PURGEMARKERHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 5, FREQUENCYMINUTES 30
ACCESSRULE, PROG SERVER, ALLOW
GGSCI (rhel7ogg1.localdomain as goldengate@orcl) 84> view params w1repREPLICAT w1rep
ASSUMETARGETDEFS
USERID goldengate@orcl, PASSWORD goldengate
DISCARDFILE w1repdsc,APPEND,MEGABYTES 5
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
BATCHSQL
DBOPTIONS DEFERREFCONST
DBOPTIONS LOBWRITESIZE 102400
HANDLECOLLISIONS
DDLERROR DEFAULT DISCARD RETRYOP MAXRETRIES 5 RETRYDELAY 20
MAP goldengate.* , TARGET goldengate.* ;
解决方案 »
- Oracle 10g 导出空库(导出某个用户下的所有对象结构)
- 触发器的错误,找了半天没发现?急
- linux下EM启动不了,求助
- oracle10.2 在fedora 7 安装成功后的几点疑惑,需要请教各位前辈??
- 有一个巨难实现的sql 谁能帮我
- 请教各位高手:如何在客户端应用程序(比如VB、delphi)中如何使用绑定变量?
- LGQDUCKY(飘),请过来接分。
- ORA-04074,无效的REFERENCING名称
- pl/sql问题
- 动态执行sql 报错CODE:-911 ERROR:ORA-00911: invalid character
- 如何用sql解决多条件过滤
- 能否将datatable作为参数传给oracle数据库存储过程
到目标端 192.168.56.101
2、确定下目标端存放 /opt/gg/trails/ 是否有足够权限
网络通的,可以拷贝。这个目录下生成的文件名称长度太长,跟报错日志里需要的文件名不一致,多了3个0
已经生成的文件是/opt/gg/trails/w1000000001,但需要的文件名是:/opt/gg/trails/w1000001
你改下路径到 OGG的 子目录 dirdat目录下。
你自己玩的环境,重新建下进程吧。
SETENV(ORACLE_HOME = "/oracle/database/product/11.2.0/dbhome_1")
SETENV(NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
USERID ggs, PASSWORD ggs
TRANLOGOPTIONS EXCLUDEUSER ggs
EXTTRAIL /opt/ggs/dirdat/muser/ac
DISCARDFILE ./dirrpt/mgroupext1.dsc,APPEND,MEGABYTES 512
DBOPTIONS ALLOWNOLOGGING
DBOPTIONS ALLOWUNUSEDCOLUMN
TRANLOGOPTIONS DBLOGREADER
FETCHOPTIONS, USESNAPSHOT, NOUSELATESTVERSION, MISSINGROW REPORT
STATOPTIONS REPORTFETCH
DDL INCLUDE mapped
DDLOPTIONS ADDTRANDATA
WARNLONGTRANS 2H, CHECKINTERVAL 15M
TABLE MUSER.*;
EXTRACT modtoss
SETENV(ORACLE_HOME = "/oracle/database/product/11.2.0/dbhome_1")
SETENV(NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
USERID ggs, PASSWORD oracleggs
RMTHOST **.***.**.**, MGRPORT 7809,compress
RMTTRAIL /opt/ggs/dirdat/muser/ac
DISCARDFILE ./dirrpt/modtosh1.dsc,APPEND,MEGABYTES 512
TABLE MUSER.*;
抽取进程和传输进程的配置给你参考。
现在启动是正常了,但是数据没有同步过去。也没报错。
.查看统计信息
GGSCI> stats <进程名称>,<时间频度>,table . 可以查看进程处理的记录数。该报告会详细的列出处理的类型和记录数。
如:GGSCI> stats edr, total列出自进程启动以来处理的所有记录数。
GGSCI> stats edr, daily, table gg.test列出当天以来处理的有关gg.test表的所有记录数。
stats MGOUPEXT, daily, table group.t_f_recordsstats MGOUPEXT, HOURLY, table group.t_f_records