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