OGG 出錯,日志如下:
2013-09-13 17:05:12 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, repl_001.prm: REPLICAT REPL_001 started.
2013-09-13 17:05:15 WARNING OGG-03504 Oracle GoldenGate Delivery for Oracle, repl_001.prm: NLS_LANG character set ZHS16GBK
on the target is different from the source database character set AL32UTF8. Replication may not be valid if the source data
has an incompatible character for the target NLS_LANG character set.
2013-09-13 17:05:15 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repl_001.prm: No unique key is defined for ta
ble 'G_SN_COUNT'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be use
d to define the key.
2013-09-13 17:05:16 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repl_001.prm: No unique key is defined for ta
ble 'G_SN_TRAVEL'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be us
ed to define the key.
2013-09-13 17:05:18 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repl_001.prm: No unique key is defined for ta
ble 'G_WO_SN'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used t
o define the key.
2013-09-13 17:05:18 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repl_001.prm: No unique key is defined for ta
ble 'SYS_TERMINAL_EMP'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may
be used to define the key.
2013-09-13 17:05:18 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repl_001.prm: No unique key is defined for ta
ble 'SYS_HT_TERMINAL_EMP'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS m
ay be used to define the key.
2013-09-13 17:05:19 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repl_001.prm: No unique key is defined for ta
ble 'G_WO_BASE'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used
to define the key.
2013-09-13 17:05:20 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repl_001.prm: No unique key is defined for ta
ble 'G_SN_DEFECT_COUNT'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may
be used to define the key.
2013-09-13 17:05:20 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repl_001.prm: No unique key is defined for ta
ble 'G_SN_DEFECT'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be us
ed to define the key.
2013-09-13 17:05:20 ERROR OGG-01161 Oracle GoldenGate Delivery for Oracle, repl_001.prm: Bad column index (20) specified
for table SAJET.G_SN_DEFECT, max columns = 20.
2013-09-13 17:05:20 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, repl_001.prm: PROCESS ABENDING.
2013-09-13 17:08:57 INFO OGG-01735 Oracle GoldenGate Collector for Oracle: Synchronizing ./dirdat/rt000501 to disk.
2013-09-13 17:08:57 INFO OGG-01735 Oracle GoldenGate Collector for Oracle: Synchronizing ./dirdat/rt000501 to disk.
2013-09-13 17:08:57 INFO OGG-01670 Oracle GoldenGate Collector for Oracle: Closing ./dirdat/rt000501.
2013-09-13 17:08:57 INFO OGG-01669 Oracle GoldenGate Collector for Oracle: Opening ./dirdat/rt000502 (byte -1, current
EOF 0).
2013-09-13 17:05:15 WARNING OGG-03504 Oracle GoldenGate Delivery for Oracle, repl_001.prm: NLS_LANG character set ZHS16GBK
on the target is different from the source database character set AL32UTF8. Replication may not be valid if the source data
has an incompatible character for the target NLS_LANG character set.
2013-09-13 17:05:15 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repl_001.prm: No unique key is defined for ta
ble 'G_SN_COUNT'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be use
d to define the key.
2013-09-13 17:05:16 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repl_001.prm: No unique key is defined for ta
ble 'G_SN_TRAVEL'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be us
ed to define the key.
2013-09-13 17:05:18 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repl_001.prm: No unique key is defined for ta
ble 'G_WO_SN'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used t
o define the key.
2013-09-13 17:05:18 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repl_001.prm: No unique key is defined for ta
ble 'SYS_TERMINAL_EMP'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may
be used to define the key.
2013-09-13 17:05:18 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repl_001.prm: No unique key is defined for ta
ble 'SYS_HT_TERMINAL_EMP'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS m
ay be used to define the key.
2013-09-13 17:05:19 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repl_001.prm: No unique key is defined for ta
ble 'G_WO_BASE'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used
to define the key.
2013-09-13 17:05:20 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repl_001.prm: No unique key is defined for ta
ble 'G_SN_DEFECT_COUNT'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may
be used to define the key.
2013-09-13 17:05:20 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repl_001.prm: No unique key is defined for ta
ble 'G_SN_DEFECT'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be us
ed to define the key.
2013-09-13 17:05:20 ERROR OGG-01161 Oracle GoldenGate Delivery for Oracle, repl_001.prm: Bad column index (20) specified
for table SAJET.G_SN_DEFECT, max columns = 20.
2013-09-13 17:05:20 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, repl_001.prm: PROCESS ABENDING.
2013-09-13 17:08:57 INFO OGG-01735 Oracle GoldenGate Collector for Oracle: Synchronizing ./dirdat/rt000501 to disk.
2013-09-13 17:08:57 INFO OGG-01735 Oracle GoldenGate Collector for Oracle: Synchronizing ./dirdat/rt000501 to disk.
2013-09-13 17:08:57 INFO OGG-01670 Oracle GoldenGate Collector for Oracle: Closing ./dirdat/rt000501.
2013-09-13 17:08:57 INFO OGG-01669 Oracle GoldenGate Collector for Oracle: Opening ./dirdat/rt000502 (byte -1, current
EOF 0).
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27348/viewspace-772691/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27348/viewspace-772691/