OGG Replicat Failed Due To Check_point Table beingTruncated
目标端replicat进程启动异常
GGSCI (aix211) 16> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED RORA_1 00:00:00 43:38:02
查看日志:
日志1:
2014-09-25 16:03:42 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, rora_1.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/ogg/dirtmp.
2014-09-25 16:03:42 ERROR OGG-00446 Oracle GoldenGate Delivery for Oracle, rora_1.prm: Checkpoint table ogg.checkpoint does not exist. Pleas
e create the table or recreate the RORA_1 group using the correct table.
2014-09-25 16:03:42 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rora_1.prm: PROCESS ABENDING.
无法找到checkpint table !
GGSCI (aix211) 2> delete checkpointtable
GGSCI (aix211) 3> edit param ./GLOBALS
CHECKPOINTTABLE ogg.checkpoint
GGSCI (aix211) 3>exit
必须退出ggsci,checkpoint table 才会生效
[oracle@rh6 ogg]$ ./ggsci
GGSCI (aix211) 1> dblogin userid ogg,password ogg
Successfully logged into database.
GGSCI (aix211) 2> add checkpointtable
No checkpoint table specified, using GLOBALS specification (ogg.checkpoint)...
Successfully created checkpoint table ogg.checkpoint.
重新启动replicat进程:
GGSCI (aix211) 16> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED RORA_1 00:00:00 43:38:02
启动失败,查看日志!
日志2:
[oracle@aix211 ogg]$tail ggserr.log
2014-09-25 16:11:47 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT RORA_1 starting.
2014-09-25 16:11:48 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, rora_1.prm: REPLICAT RORA_1 starting.
2014-09-25 16:11:48 INFO OGG-03035 Oracle GoldenGate Delivery for Oracle, rora_1.prm: Operating system character set identified as ISO-8859-1. Locale: en_US_POSIX, LC_ALL:.
2014-09-25 16:11:48 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, rora_1.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/ogg/dirtmp.
2014-09-25 16:11:48 ERROR OGG-00446 Oracle GoldenGate Delivery for Oracle, rora_1.prm: No data selecting position from checkpoint table ogg.checkpoint for group 'RORA_1', key 1056363220 (0x3ef6d2d4), SQL .
2014-09-25 16:11:48 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rora_1.prm: PROCESS ABENDING.
checkpointtable 错误 !
处理方法:
删除replicat进程:
GGSCI (aix211) 7> delete replicat rora_1
Deleted REPLICAT RORA_1.
添加新的replicat进程:
GGSCI (aix211) 8> add replicat rora_1,exttrail ./dirdat/pa,checkpointtable ogg.checkpoint
REPLICAT added.
GGSCI (aix211) 9> edit param rora_1
"/ogg/dirprm/rora_1.prm" 7 lines, 198 characters
REPLICAT RORA_1
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
USERID ogg,PASSWORD ogg
HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/RORA_aa.DSC,PURGE
MAP scott.oem_ogg, TARGET scott.emp_ogg;
~
重新启动replicat进程
GGSCI (aix211) 10> start replicat rora_1
Sending START request to MANAGER ...
REPLICAT RORA_1 starting
GGSCI (aix211) 11> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING RORA_1 00:00:00 00:00:03
启动成功!
查看ogg日志:
GGSCI (aix211) 12> view ggsevt
2014-09-25 16:25:13 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT RORA_1 starting.
2014-09-25 16:25:13 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, rora_1.prm: REPLICAT RORA_1 starting.
2014-09-25 16:25:13 INFO OGG-03035 Oracle GoldenGate Delivery for Oracle, rora_1.prm: Operating system characte
r set identified as ISO-8859-1. Locale: en_US_POSIX, LC_ALL:.
2014-09-25 16:25:13 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, rora_1.prm: Virtual Memory Facilities
for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/ogg/dirtmp.
2014-09-25 16:25:13 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, rora_1.prm: REPLICAT RORA_1 started.
案例分析2:
源端初始化进程(eini_1)和目标端初始化进程(rini_1)
目标端初始化进程rini_1:
GGSCI (aix211) 13> info rini_1
REPLICAT RINI_1 Initialized 2014-09-23 15:40 Status STOPPED
Checkpoint Lag 00:00:00 (updated 48:46:37 ago)
Log Read Checkpoint Not Available
Task SPECIALRUN
源端初始化进程eini_1:
GGSCI (aix212) 21> info eini_1
EXTRACT EINI_1 Last Started 2014-09-25 16:09 Status STOPPED
Checkpoint Lag Not Available
Log Read Checkpoint Table SCOTT.EMP_OGG
2014-09-25 16:09:35 Record 14
Task SOURCEISTABLE
启动源端初始化进程:
GGSCI (aix212) 22> start eini_1
Sending START request to MANAGER ...
EXTRACT EINI_1 starting
GGSCI (aix212) 23> info eini_1
EXTRACT EINI_1 Last Started 2014-09-25 16:09 Status RUNNING
Checkpoint Lag Not Available
Log Read Checkpoint Table SCOTT.EMP_OGG
2014-09-25 16:09:35 Record 14
Task SOURCEISTAB
进程启动后,目标端初始化进程自动启动!
GGSCI (aix211) 14> info rini_1
REPLICAT RINI_1 Initialized 2014-09-23 15:40 Status RUNNING
Checkpoint Lag 00:00:00 (updated 48:47:03 ago)
Log Read Checkpoint Not Available
Task SPECIALRUN
目标端replicat进程启动异常
GGSCI (aix211) 16> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED RORA_1 00:00:00 43:38:02
查看日志:
日志1:
2014-09-25 16:03:42 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, rora_1.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/ogg/dirtmp.
2014-09-25 16:03:42 ERROR OGG-00446 Oracle GoldenGate Delivery for Oracle, rora_1.prm: Checkpoint table ogg.checkpoint does not exist. Pleas
e create the table or recreate the RORA_1 group using the correct table.
2014-09-25 16:03:42 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rora_1.prm: PROCESS ABENDING.
无法找到checkpint table !
GGSCI (aix211) 2> delete checkpointtable
GGSCI (aix211) 3> edit param ./GLOBALS
CHECKPOINTTABLE ogg.checkpoint
GGSCI (aix211) 3>exit
必须退出ggsci,checkpoint table 才会生效
[oracle@rh6 ogg]$ ./ggsci
GGSCI (aix211) 1> dblogin userid ogg,password ogg
Successfully logged into database.
GGSCI (aix211) 2> add checkpointtable
No checkpoint table specified, using GLOBALS specification (ogg.checkpoint)...
Successfully created checkpoint table ogg.checkpoint.
重新启动replicat进程:
GGSCI (aix211) 16> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED RORA_1 00:00:00 43:38:02
启动失败,查看日志!
日志2:
[oracle@aix211 ogg]$tail ggserr.log
2014-09-25 16:11:47 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT RORA_1 starting.
2014-09-25 16:11:48 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, rora_1.prm: REPLICAT RORA_1 starting.
2014-09-25 16:11:48 INFO OGG-03035 Oracle GoldenGate Delivery for Oracle, rora_1.prm: Operating system character set identified as ISO-8859-1. Locale: en_US_POSIX, LC_ALL:.
2014-09-25 16:11:48 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, rora_1.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/ogg/dirtmp.
2014-09-25 16:11:48 ERROR OGG-00446 Oracle GoldenGate Delivery for Oracle, rora_1.prm: No data selecting position from checkpoint table ogg.checkpoint for group 'RORA_1', key 1056363220 (0x3ef6d2d4), SQL .
2014-09-25 16:11:48 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rora_1.prm: PROCESS ABENDING.
checkpointtable 错误 !
处理方法:
删除replicat进程:
GGSCI (aix211) 7> delete replicat rora_1
Deleted REPLICAT RORA_1.
添加新的replicat进程:
GGSCI (aix211) 8> add replicat rora_1,exttrail ./dirdat/pa,checkpointtable ogg.checkpoint
REPLICAT added.
GGSCI (aix211) 9> edit param rora_1
"/ogg/dirprm/rora_1.prm" 7 lines, 198 characters
REPLICAT RORA_1
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
USERID ogg,PASSWORD ogg
HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/RORA_aa.DSC,PURGE
MAP scott.oem_ogg, TARGET scott.emp_ogg;
~
重新启动replicat进程
GGSCI (aix211) 10> start replicat rora_1
Sending START request to MANAGER ...
REPLICAT RORA_1 starting
GGSCI (aix211) 11> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING RORA_1 00:00:00 00:00:03
启动成功!
查看ogg日志:
GGSCI (aix211) 12> view ggsevt
2014-09-25 16:25:13 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT RORA_1 starting.
2014-09-25 16:25:13 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, rora_1.prm: REPLICAT RORA_1 starting.
2014-09-25 16:25:13 INFO OGG-03035 Oracle GoldenGate Delivery for Oracle, rora_1.prm: Operating system characte
r set identified as ISO-8859-1. Locale: en_US_POSIX, LC_ALL:.
2014-09-25 16:25:13 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, rora_1.prm: Virtual Memory Facilities
for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/ogg/dirtmp.
2014-09-25 16:25:13 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, rora_1.prm: REPLICAT RORA_1 started.
案例分析2:
源端初始化进程(eini_1)和目标端初始化进程(rini_1)
目标端初始化进程rini_1:
GGSCI (aix211) 13> info rini_1
REPLICAT RINI_1 Initialized 2014-09-23 15:40 Status STOPPED
Checkpoint Lag 00:00:00 (updated 48:46:37 ago)
Log Read Checkpoint Not Available
Task SPECIALRUN
源端初始化进程eini_1:
GGSCI (aix212) 21> info eini_1
EXTRACT EINI_1 Last Started 2014-09-25 16:09 Status STOPPED
Checkpoint Lag Not Available
Log Read Checkpoint Table SCOTT.EMP_OGG
2014-09-25 16:09:35 Record 14
Task SOURCEISTABLE
启动源端初始化进程:
GGSCI (aix212) 22> start eini_1
Sending START request to MANAGER ...
EXTRACT EINI_1 starting
GGSCI (aix212) 23> info eini_1
EXTRACT EINI_1 Last Started 2014-09-25 16:09 Status RUNNING
Checkpoint Lag Not Available
Log Read Checkpoint Table SCOTT.EMP_OGG
2014-09-25 16:09:35 Record 14
Task SOURCEISTAB
进程启动后,目标端初始化进程自动启动!
GGSCI (aix211) 14> info rini_1
REPLICAT RINI_1 Initialized 2014-09-23 15:40 Status RUNNING
Checkpoint Lag 00:00:00 (updated 48:47:03 ago)
Log Read Checkpoint Not Available
Task SPECIALRUN
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29500582/viewspace-1321577/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29500582/viewspace-1321577/