OGG Replicat Failed Due To Check_point Table beingTruncated

Michael_DD發表於2014-11-05
AI
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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29500582/viewspace-1321577/，如需轉載，請註明出處，否則將追究法律責任。

相關文章