设为首页 加入收藏

TOP

GoldengateFORMATRELEASE(二)
2015-07-24 12:04:37 来源: 作者: 【 】 浏览:26
Tags:GoldengateFORMATRELEASE
cle, ext1.prm: DDL found, operation [drop table test (size 16)], start SCN [1393784], commit SCN [1393812] instance [orcl11g (1)], DDL seqno [17501], marker seqno [16501]. 2015-03-05 02:21:18 INFO OGG-00487 Oracle GoldenGate Capture for Oracle, ext1.prm: DDL operation included [INCLUDE MAPPED OBJTYPE 'TABLE'], optype [DROP], objtype [TABLE], objowner [ZBDBA], objname [TEST]. 2015-03-05 02:21:18 INFO OGG-00497 Oracle GoldenGate Capture for Oracle, ext1.prm: Writing DDL operation to extract trail file.
发现现在的trail文件版本已经改变

?

开启复制进程:

?

GGSCI (zbdba2) 1> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING                                          
REPLICAT    RUNNING     REP1        00:00:00      00:00:02     
监控日志:

?

?

2015-03-05 02:20:02  INFO    OGG-01669  Oracle GoldenGate Collector:  Opening ./dirdat/sa000002 (byte -1, current EOF 0).
2015-03-05 02:21:19  INFO    OGG-00482  Oracle GoldenGate Delivery for Oracle, rep1.prm:  DDL found, operation [drop table test  (size 16)].
2015-03-05 02:21:19  INFO    OGG-00489  Oracle GoldenGate Delivery for Oracle, rep1.prm:  DDL is of mapped scope, after mapping new operation [drop table "ZBDBA"."TEST"  (size 26)].
2015-03-05 02:21:19  INFO    OGG-00487  Oracle GoldenGate Delivery for Oracle, rep1.prm:  DDL operation included [INCLUDE MAPPED], optype [DROP], objtype [TABLE], objowner [ZBDBA], objname [TEST].
2015-03-05 02:21:19  INFO    OGG-01407  Oracle GoldenGate Delivery for Oracle, rep1.prm:  Setting current schema for DDL operation to [ZBDBA].
2015-03-05 02:21:19  INFO    OGG-00484  Oracle GoldenGate Delivery for Oracle, rep1.prm:  Executing DDL operation.
2015-03-05 02:21:23  INFO    OGG-00483  Oracle GoldenGate Delivery for Oracle, rep1.prm:  DDL operation successful.
2015-03-05 02:21:23  INFO    OGG-01408  Oracle GoldenGate Delivery for Oracle, rep1.prm:  Restoring current schema for DDL operation to [OGG].

?

ok,一切恢复正常。






首页 上一页 1 2 下一页 尾页 2/2/2
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇数据库调优教程(六)索引的相关.. 下一篇EncryptingGoldengatePassword

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: