1,报错日志
2017-03-23 12:48:00 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start YLREP.
2017-03-23 12:48:00 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host qs-proxydb2.800best.com (START REPLICAT YLREP ).
2017-03-23 12:48:00 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT YLREP starting.
2017-03-23 12:48:00 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, ylrep.prm: REPLICAT YLREP starting.
2017-03-23 12:48:00 INFO OGG-03035 Oracle GoldenGate Delivery for Oracle, ylrep.prm: Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2017-03-23 12:48:00 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, ylrep.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/tmpdata/ogg/dirtmp.
2017-03-23 12:48:00 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, ylrep.prm: REPLICAT YLREP started.
2017-03-23 12:48:00 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, ylrep.prm: OCI Error ORA-26945: unsupported hint RESTRICT_ALL_REF_CONS (status = 26945). UPDATE /*+ RESTRICT_ALL_REF_CONS */ "BTR_WYVERN"."WY_ONLINE_SCHEDULE" SET "LOCK_VERSION" = :a1,"MODIFY_FLAG" = :a2,"STATUS" = :a3,"PRE_EFFECT_TO" = :a4 WHERE "ID" = :b0.
2017-03-23 12:48:00 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, ylrep.prm: Aborted grouped transaction on 'BTR_WYVERN.WY_ONLINE_SCHEDULE', Database error 26945 (OCI Error ORA-26945: unsupported hint RESTRICT_ALL_REF_CONS (status = 26945). UPDATE /*+ RESTRICT_ALL_REF_CONS */ "BTR_WYVERN"."WY_ONLINE_SCHEDULE" SET "LOCK_VERSION" = :a1,"MODIFY_FLAG" = :a2,"STATUS" = :a3,"PRE_EFFECT_TO" = :a4 WHERE "ID" = :b0).
2017-03-23 12:48:00 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, ylrep.prm: Repositioning to rba 1260 in seqno 73.
2017-03-23 12:48:00 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, ylrep.prm: SQL error 26945 mapping BTR_WYVERN.WY_ONLINE_SCHEDULE to BTR_WYVERN.WY_ONLINE_SCHEDULE OCI Error ORA-26945: unsupported hint RESTRICT_ALL_REF_CONS (status = 26945). UPDATE /*+ RESTRICT_ALL_REF_CONS */ "BTR_WYVERN"."WY_ONLINE_SCHEDULE" SET "LOCK_VERSION" = :a1,"MODIFY_FLAG" = :a2,"STATUS" = :a3,"PRE_EFFECT_TO" = :a4 WHERE "ID" = :b0.
2017-03-23 12:48:00 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, ylrep.prm: Repositioning to rba 1260 in seqno 73.
2017-03-23 12:48:00 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, ylrep.prm: Error mapping from BTR_WYVERN.WY_ONLINE_SCHEDULE to BTR_WYVERN.WY_ONLINE_SCHEDULE.
2017-03-23 12:48:00 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, ylrep.prm: PROCESS ABENDING.
GGSCI (qs-proxydb2.800best.com) 3> view params YLREP
replicat ylrep
setenv (NLS_LANG = AMERICAN_AMERICA.ZHS16GBK)
setenv (ORACLE_SID =prob阿萨德飞洒发的 )
userid ggs, password A, encryptkey default
reperror default,abend
purgeoldextracts /tmpdata/ogg/dirdat/yl/*, usecheckpoints, minkeepdays 7
discardfile /tmpdata/ogg/dirdat/ylrep.dsc,append, megabytes 20
discardrollover on sunday
assumetargetdefs
dboptions deferrefconst
2,修改oracle参数
12:47:28 sys@proxydb2>show parameter ENABLE_GOLDENGATE_REPLICATION;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication boolean FALSE
12:49:53 sys@proxydb2>ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE SCOPE=BOTH;
System altered.
Elapsed: 00:00:00.08
3,重新启动进程
GGSCI (qs-proxydb2.800best.com) 5> start YLREP
Sending START request to MANAGER ...
REPLICAT YLREP starting
GGSCI (qs-proxydb2.800best.com) 6> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED TMREP 01:05:31 00:10:22
REPLICAT ABENDED V5REP 01:07:25 00:09:00
REPLICAT RUNNING YLREP 00:00:00 00:00:06
2017-03-23 12:48:00 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start YLREP.
2017-03-23 12:48:00 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host qs-proxydb2.800best.com (START REPLICAT YLREP ).
2017-03-23 12:48:00 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT YLREP starting.
2017-03-23 12:48:00 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, ylrep.prm: REPLICAT YLREP starting.
2017-03-23 12:48:00 INFO OGG-03035 Oracle GoldenGate Delivery for Oracle, ylrep.prm: Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2017-03-23 12:48:00 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, ylrep.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/tmpdata/ogg/dirtmp.
2017-03-23 12:48:00 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, ylrep.prm: REPLICAT YLREP started.
2017-03-23 12:48:00 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, ylrep.prm: OCI Error ORA-26945: unsupported hint RESTRICT_ALL_REF_CONS (status = 26945). UPDATE /*+ RESTRICT_ALL_REF_CONS */ "BTR_WYVERN"."WY_ONLINE_SCHEDULE" SET "LOCK_VERSION" = :a1,"MODIFY_FLAG" = :a2,"STATUS" = :a3,"PRE_EFFECT_TO" = :a4 WHERE "ID" = :b0.
2017-03-23 12:48:00 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, ylrep.prm: Aborted grouped transaction on 'BTR_WYVERN.WY_ONLINE_SCHEDULE', Database error 26945 (OCI Error ORA-26945: unsupported hint RESTRICT_ALL_REF_CONS (status = 26945). UPDATE /*+ RESTRICT_ALL_REF_CONS */ "BTR_WYVERN"."WY_ONLINE_SCHEDULE" SET "LOCK_VERSION" = :a1,"MODIFY_FLAG" = :a2,"STATUS" = :a3,"PRE_EFFECT_TO" = :a4 WHERE "ID" = :b0).
2017-03-23 12:48:00 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, ylrep.prm: Repositioning to rba 1260 in seqno 73.
2017-03-23 12:48:00 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, ylrep.prm: SQL error 26945 mapping BTR_WYVERN.WY_ONLINE_SCHEDULE to BTR_WYVERN.WY_ONLINE_SCHEDULE OCI Error ORA-26945: unsupported hint RESTRICT_ALL_REF_CONS (status = 26945). UPDATE /*+ RESTRICT_ALL_REF_CONS */ "BTR_WYVERN"."WY_ONLINE_SCHEDULE" SET "LOCK_VERSION" = :a1,"MODIFY_FLAG" = :a2,"STATUS" = :a3,"PRE_EFFECT_TO" = :a4 WHERE "ID" = :b0.
2017-03-23 12:48:00 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, ylrep.prm: Repositioning to rba 1260 in seqno 73.
2017-03-23 12:48:00 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, ylrep.prm: Error mapping from BTR_WYVERN.WY_ONLINE_SCHEDULE to BTR_WYVERN.WY_ONLINE_SCHEDULE.
2017-03-23 12:48:00 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, ylrep.prm: PROCESS ABENDING.
GGSCI (qs-proxydb2.800best.com) 3> view params YLREP
replicat ylrep
setenv (NLS_LANG = AMERICAN_AMERICA.ZHS16GBK)
setenv (ORACLE_SID =prob阿萨德飞洒发的 )
userid ggs, password A, encryptkey default
reperror default,abend
purgeoldextracts /tmpdata/ogg/dirdat/yl/*, usecheckpoints, minkeepdays 7
discardfile /tmpdata/ogg/dirdat/ylrep.dsc,append, megabytes 20
discardrollover on sunday
assumetargetdefs
dboptions deferrefconst
2,修改oracle参数
12:47:28 sys@proxydb2>show parameter ENABLE_GOLDENGATE_REPLICATION;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication boolean FALSE
12:49:53 sys@proxydb2>ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE SCOPE=BOTH;
System altered.
Elapsed: 00:00:00.08
3,重新启动进程
GGSCI (qs-proxydb2.800best.com) 5> start YLREP
Sending START request to MANAGER ...
REPLICAT YLREP starting
GGSCI (qs-proxydb2.800best.com) 6> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED TMREP 01:05:31 00:10:22
REPLICAT ABENDED V5REP 01:07:25 00:09:00
REPLICAT RUNNING YLREP 00:00:00 00:00:06
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29108064/viewspace-2135915/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29108064/viewspace-2135915/