ogg- 因为机器重启而停掉

./ggsci

GGSCI (sdbmzdb2) 1> info all


Program     Status      Group       Lag at Chkpt  Time Since Chkpt


MANAGER     RUNNING                                           
EXTRACT     ABENDED     DPEB        00:00:00      01:58:22    
EXTRACT     RUNNING     EXTB        00:00:00      00:00:06   

GGSCI (sdbmzdb2) 13> view report dpeb

发现如下错误：

2012-12-12 15:58:36  ERROR   OGG-01031  There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if usin

g ENCRYPT) or an unknown error. (Reply received is Unable to open file "/home/ogg/dirdat/rb003373" (error 11, Resource temporarily unavailable)).

源端有个文件，，，rb00373那个文件，在目标端会有个对应的文件，，，这个对应的文件由于，源端机器重启了，，，造成两个文件间的信息不匹配了，，，

GGSCI (sdbmzdb2) 2> alter extract dpeb etrollover    


2012-12-12 16:12:34  INFO    OGG-01520  Rollover performed.  For each affected output trail of Version 10 or higher format, after starting the source extract, issue ALTER EXTSEQNO for that trail's reader (either pump EXTRACT or REPLICAT) to move the reader's scan to the new trail file;  it will not happen automatically.
EXTRACT altered.

 

再次传送373这个文件到目标端，，，生成新的文件。。。

GGSCI (sdbmzdb2) 2> stop mgr

GGSCI (sdbmzdb2) 2> stop dpeb

GGSCI (sdbmzdb2) 2> stop extb

 

 

GGSCI (sdbmzdb2) 2> start mgr

GGSCI (sdbmzdb2) 2> start dpeb

GGSCI (sdbmzdb2) 2> start extb

源端也进行重启

查看源端日志

 

vi /home/ogg/ggserr.log

2012-12-12 18:38:43  WARNING OGG-01519  Oracle GoldenGate Delivery for Oracle, repb.prm:  Waiting at EOF on input trail file /home/ogg/dirdat/rb00995, which is not marked as complete; but succeeding trail file /home/ogg/dirdat/rb00996 exists. If ALTER ETROLLOVER has been performed on source extract, ALTER EXTSEQNO must be performed on each corresponding downstream reader.

  

这样新生成的 995文件 并没有被ogg识别，这种情况下 需要命令让ogg识别新生成的996文件

在目的端 首先停止 repb进行

GGSCI (sdbmzbb) 31> >stop rep_lte

GGSCI (sdbmzbb) 31> >alter replicat  rep_lte extseqno 996 extrba 0.

重新启动repb

GGSCI (sdbmzbb) 31> >start  rep_lte

查看日志：

2012-12-12 18:42:05  INFO    OGG-01020  Oracle GoldenGate Delivery for Oracle, repb.prm:  Processed extract process RESTART_ABEND record at seq 996, rba 1029 (aborted 0 records).

则同步成功！