暂无图片
ogg数据同步12c多租户pdb到11g单机数据库数据同步,源端插入数据,目标端没有反应
我来答
分享
NIU
2019-08-20
ogg数据同步12c多租户pdb到11g单机数据库数据同步,源端插入数据,目标端没有反应

源端操作:insert into lz.zm values(5);--commit

目标端没有数据更新。

源端ogg  ggserr.log日志


2019-08-18T21:20:18.086+0800  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info all.

2019-08-18T21:20:18.537+0800  INFO    OGG-03522  Oracle GoldenGate Capture for Oracle, eora4.prm:  Setting session time zone to source database time zone 'GMT'.

2019-08-18T21:20:27.293+0800  INFO    OGG-02255  Oracle GoldenGate Capture for Oracle, eora4.prm:  The MININGDBLOGIN is connected to the source database ORCL.

2019-08-18T21:20:27.441+0800  INFO    OGG-06604  Oracle GoldenGate Capture for Oracle, eora4.prm:  Database ORCL CPU info: CPU Count 1, CPU Core Count 0, CPU Socket Count 0.

2019-08-18T21:20:34.633+0800  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info all.

2019-08-18T21:20:36.306+0800  WARNING OGG-02045  Oracle GoldenGate Capture for Oracle, eora4.prm:  Database does not have streams_pool_size initialization parameter configured.

2019-08-18T21:20:39.589+0800  INFO    OGG-02248  Oracle GoldenGate Capture for Oracle, eora4.prm:  Logmining server DDL filtering enabled.

2019-08-18T21:20:42.939+0800  INFO    OGG-02068  Oracle GoldenGate Capture for Oracle, eora4.prm:  Integrated capture successfully attached to logmining server OGG$CAP_EORA4 using OGGCapture API.

2019-08-18T21:20:42.941+0800  INFO    OGG-02089  Oracle GoldenGate Capture for Oracle, eora4.prm:  Source redo compatibility version is: 12.2.0.

2019-08-18T21:20:42.951+0800  INFO    OGG-02086  Oracle GoldenGate Capture for Oracle, eora4.prm:  Integrated Dictionary will be used.

2019-08-18T21:20:45.108+0800  WARNING OGG-02905  Oracle GoldenGate Capture for Oracle, eora4.prm:  Replication of OID column in object tables may diverge.

2019-08-18T21:20:45.188+0800  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, eora4.prm:  EXTRACT EORA4 started.

2019-08-18T21:20:45.396+0800  INFO    OGG-01052  Oracle GoldenGate Capture for Oracle, eora4.prm:  No recovery is required for target file ./dirdat/eo000000000, at RBA 0 (file not opened).

2019-08-18T21:20:45.396+0800  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, eora4.prm:  Output file ./dirdat/eo is using format RELEASE 12.3.

2019-08-18T21:20:46.362+0800  INFO    OGG-02243  Oracle GoldenGate Capture for Oracle, pump4.prm:  Opened trail file /home/oracle/ogg/dirdat/eo000000000 at 2019-08-18 21:20:46.362485.

2019-08-18T21:20:46.362+0800  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, pump4.prm:  Output file ./dirdat/pu is using format RELEASE 12.3.

2019-08-18T21:20:49.842+0800  INFO    OGG-03522  Oracle GoldenGate Capture for Oracle, eora4.prm:  Setting session time zone to source database time zone 'GMT'.

2019-08-18T21:22:16.171+0800  INFO    OGG-06507  Oracle GoldenGate Capture for Oracle, eora4.prm:  MAP (TABLE) resolved (entry PDB1.lz.zm): TABLE "PDB1"."LZ"."ZM".

2019-08-18T21:22:24.344+0800  INFO    OGG-06509  Oracle GoldenGate Capture for Oracle, eora4.prm:  Using the following key columns for source table PDB1.LZ.ZM: ID.

2019-08-18T21:22:24.409+0800  INFO    OGG-06507  Oracle GoldenGate Capture for Oracle, eora4.prm:  MAP (TABLE) resolved (entry PDB1.lz.zm): TABLE "PDB1"."LZ"."ZM".

2019-08-18T21:22:24.462+0800  INFO    OGG-06509  Oracle GoldenGate Capture for Oracle, eora4.prm:  Using the following key columns for source table PDB1.LZ.ZM: ID.

2019-08-18T21:22:25.840+0800  INFO    OGG-02263  Oracle GoldenGate Capture for Oracle, pump4.prm:  Passthru MAP (TABLE) resolved (entry PDB1.lz.zm): TABLE "PDB1"."LZ"."ZM".





目标端 ogg ggserr.log

2019-08-14T00:26:42.980+0800  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, repl4.prm:  REPLICAT REPL4 started.

2019-08-14T00:26:42.980+0800  INFO    OGG-02243  Oracle GoldenGate Delivery for Oracle, repl4.prm:  Opened trail file /home/oracle/ogg1/dirdat/pu000000000 at 2019-08-14 00:26:42.980666.

2019-08-14T00:26:43.869+0800  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info all.

2019-08-14T00:30:49.319+0800  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info all.

2019-08-14T00:31:49.794+0800  INFO    OGG-03522  Oracle GoldenGate Delivery for Oracle, repl4.prm:  Setting session time zone to source database time zone 'GMT'.

2019-08-14T00:31:49.921+0800  WARNING OGG-02760  Oracle GoldenGate Delivery for Oracle, repl4.prm:  ASSUMETARGETDEFS is ignored because trail file /home/oracle/ogg1/dirdat/pu000000000 contains table definitions.

2019-08-14T00:31:52.175+0800  INFO    OGG-03506  Oracle GoldenGate Delivery for Oracle, repl4.prm:  The source database character set, as determined from the trail file, is UTF-8.

2019-08-14T00:31:52.342+0800  INFO    OGG-06505  Oracle GoldenGate Delivery for Oracle, repl4.prm:  MAP resolved (entry PDB1.LZ.ZM): MAP "PDB1"."LZ"."ZM",TARGET nzw.nz.

2019-08-14T00:31:56.776+0800  INFO    OGG-02756  Oracle GoldenGate Delivery for Oracle, repl4.prm:  The definition for table PDB1.LZ.ZM is obtained from the trail file.

2019-08-14T00:31:56.823+0800  INFO    OGG-06511  Oracle GoldenGate Delivery for Oracle, repl4.prm:  Using following columns in default map by name: ID.

2019-08-14T00:31:56.823+0800  INFO    OGG-06510  Oracle GoldenGate Delivery for Oracle, repl4.prm:  Using the following key columns for target table NZW.NZ: ID.


我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
张小帅

检查下源端抽取进程和投递进程,看看分别有数据捕获到?

stats 

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


请输入正文
提交
相关推荐
现在有台Oracle server 应用那边反应连接数据库很慢,但是数据库没有什么慢查询,还可以从哪些方面去troubleshooting性能问题?
回答 2
看一下/etc/resolv.conf配置文件,是否配置了nameserver,如果不通外网但是配置了nameserver那么就会有连接缓慢的问题,直接注释掉就好了
白求恩巡检脚本执行时报错
回答 3
有可能是监听日志太大,可以缩小范围:开始采集(采集7天内的信息,且不采集DG数据)perlrunMe.ple7L7St7T7
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 能直接升级到21c吗?还是要先升级到19c
回答 1
直接可以升级到21c的版本:oracle数据库12.2.0.1,18c,19c所以您这个可以直接升级到21c
请教各位,下面的语句怎么改回默认值 ?
回答 3
已采纳
重置参数即可ALTERPROFILEDEFAULTLIMITIDLETIMEDEFAULT;
rehl8 安装 19c
回答 2
md5校验一下安装包。
oracle 11g 使用EXpdp 导出数据如何优化导出速度, CPU是32逻辑cpu
回答 4
已采纳
不到每秒10m的落地速度,瓶颈可能在数据库。看下是不是主要是几张表慢?这张表是否有lob类字段。是否有行链接、行迁移问题。
oracle bbed 中的 offset 这样理解对吗?
回答 1
8192就outofrange了最大可以设置8191
sysctl -w vm.dirty_ratio ,修改后,怎么不生效?
回答 2
你看一下你的/etc/sysctl.conf里面现在是否已经添加有这么一行,值是多少?如果没有请添加如下:vm.dirtyratio10然后执行sysctlp生效
请问Oracle ADG优化建议
回答 4
最大性能是对受DG库影响最小的,不太可能造成Standby库出问题,是否是主库性能不足造成进程被卡住造成的啊,还是多看看日志吧。
DBT-05505:Unable to execute sql script
回答 3
已采纳
我直接在sqlplus中执行:命令报如下错误,感觉是OMF的原因,请问如何处理这个呢?SQL>CREATEPLUGGABLEDATABASE"dbcadw4othdb"FROM"noncdbdw