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,一切恢复正常。

GoldengateFORMATRELEASE(二)