暂无图片
ogg无法同步表
我来答
分享
HGM
2022-10-26
ogg无法同步表

ogg无法同步表。源端插入数据,无法同步表。


源端:

系统:Red Hat Enterprise Linux Server release 7.6 (Maipo)

数据库:19.0.3.0,单节点RAC

ogg:安装包是191004_fbo_ggs_Linux_x64_shiphome.zip

目标端:

系统:Red Hat Enterprise Linux Server release 7.6 (Maipo)

数据库:9.0.3.0,单节点RAC

ogg:安装包是191004_fbo_ggs_Linux_x64_shiphome.zip


源端ogg配置:

  GGSCI (redhat01 as ogg@ora1) 157> view param CAPDB1

extract capdb1
userid ogg,password ogg
SETENV (ORACLE_HOME="/oracle/19.3.0/db/dbhome")
SETENV (ORACLE_SID=ora1)
EXTTRAIL /oracle/19.3.0/ogg/dirdat/lt
tranlogoptions dblogreader
table test.ttt1



GGSCI (redhat01 as ogg@ora1) 158> view param PUMPDB1

EXTRACT pumpdb1
SETENV (ORACLE_HOME = "/oracle/19.3.0/db/dbhome")
SETENV (ORACLE_SID = ora1)
USERID ogg, PASSWORD ogg
RMTHOST 192.168.186.90, MGRPORT 7809
rmttrail /oracle/19.3.0/ogg/dirdat/lt
RMTTASK REPLICAT, GROUP REPDB1
MAP test.ttt1


目标端:

    GGSCI (ogg1 as ogg@ora1) 92> view param REPDB1


REPLICAT repdb1
SETENV (ORACLE_HOME = "/oracle/19.3.0/db/dbhome")
SETENV (ORACLE_SID = ora1)
ASSUMETARGETDEFS
USERID ogg , PASSWORD ogg
DDL INCLUDE ALL
MAP test.ttt1, TARGET test.ttt1;


GGSCI (redhat01 as ogg@ora1) 162> stats CAPDB1 total

Sending STATS request to EXTRACT CAPDB1 ...


Start of Statistics at 2022-10-26 17:31:12.

Output to /oracle/19.3.0/ogg/dirdat/lt:

Extracting from TEST.TT1 to TEST.TT1:

*** Total statistics since 2022-10-26 11:48:36 ***
Total inserts 5.00
Total updates 0.00
Total deletes 0.00
Total upserts 0.00
Total discards 0.00
Total operations 5.00

Extracting from TEST.COURSE to TEST.COURSE:

*** Total statistics since 2022-10-26 11:48:36 ***
Total inserts 3.00
Total updates 0.00
Total deletes 0.00
Total upserts 0.00
Total discards 0.00
Total operations 3.00

Extracting from TEST.STU_COURSE to TEST.STU_COURSE:

*** Total statistics since 2022-10-26 11:48:36 ***
Total inserts 24.00
Total updates 0.00
Total deletes 0.00
Total upserts 0.00
Total discards 0.00
Total operations 24.00

Extracting from TEST.SYS_EXPORT_TABLE_01 to TEST.SYS_EXPORT_TABLE_01:

*** Total statistics since 2022-10-26 11:48:36 ***
Total inserts 621.00
Total updates 352.00
Total deletes 0.00
Total upserts 0.00
Total discards 0.00
Total operations 973.00

Extracting from TEST.TTT1 to TEST.TTT1:

*** Total statistics since 2022-10-26 11:48:36 ***
Total inserts 6.00
Total updates 0.00
Total deletes 0.00
Total upserts 0.00
Total discards 0.00
Total operations 6.00

Extracting from TEST.TTT2 to TEST.TTT2:

*** Total statistics since 2022-10-26 11:48:36 ***
Total inserts 2.00
Total updates 0.00
Total deletes 0.00
Total upserts 0.00
Total discards 0.00
Total operations 2.00

End of Statistics.

我来答
添加附件
收藏
分享
问题补充
2条回答
默认
最新
Thomas

目标端view report REPDB1 或 stats REPDB1看下结果

暂无图片 评论
暂无图片 有用 1
打赏 0
张sir

1、确认源端是否生成trail文件

2、确认trail文件是否传递到目标端

3、看你的输出tt1的insert应该是extract到了,再stats pump和stats rep进程看看。先确认哪个环节有问题。

暂无图片 评论
暂无图片 有用 0
打赏 0
回答交流
Markdown


请输入正文
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏