ogg 故障解决一则

自己今天一个解决过程，希望能给大家一点启发

错误原因：
因两边同步出错，数据已不一致，我添加字段后也没有有同步过去，所以我把表删除重建。
但后来错误更多，想直接删除同步文件（./dirdat/gg000000）看看。但目标端一直要求此文件。
后来
重置Extract 和Replicat 进程的Trail 序列号

    alter extract ext1,extseqno 0,extrba 0

       alter replicat rep1,extseqno 0,extrba 0

目标端问题解决，但源端问题仍旧，搞了半天，没解决，只好重新配置EXTRACT了。
这操作的感慨是：OGG还是有很多运维的工作可做，如果老师能讲解得更详细一些就好。


操作如下：

GGSCI (gg1) 78> alter extract ext1,begin now

EXTRACT altered.

GGSCI (gg1) 79> alter extract ext1,extseqno 0,extrba 0

EXTRACT altered.


GGSCI (dg1) 55> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     STOPPED     EXT1        00:00:00      00:15:52    
REPLICAT    RUNNING     REP2        00:00:00      00:00:03    


EXT1 无法启动。
查看日志如下：
tail -100f ggserr.log

2013-08-28 16:56:30  INFO    OGG-01226  Oracle GoldenGate Capture for Oracle, ext1.prm:  Socket buffer size set to 27985 (flush size 27985).
2013-08-28 16:56:30  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  REPLICAT REP2 starting.
2013-08-28 16:56:30  ERROR   OGG-01496  Oracle GoldenGate Capture for Oracle, ext1.prm:  Failed to open target trail file ./dirdat/gg000000, at RBA 1765.
2013-08-28 16:56:30  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, ext1.prm:  PROCESS ABENDING.

。。。。。。。。。。。
2013-08-28 17:22:40  INFO    OGG-01515  Oracle GoldenGate Capture for Oracle, ext1.prm:  Positioning to begin time 1956-11-26 上午01:05:04.
2013-08-28 17:22:40  ERROR   OGG-01158  Oracle GoldenGate Capture for Oracle, ext1.prm:  Timestamp out of range: 0.
2013-08-28 17:22:40  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, ext1.prm:  PROCESS ABENDING.

[oracle@dg1 11.2]$ tail -100f /opt/app/ggs/11.2/dirrpt/EXT1.rpt

2013-08-28 17:22:40  INFO    OGG-01515  Positioning to begin time 1956-11-26 上午01:05:04.











GGSCI (dg1) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     STOPPED     EXT1        00:00:00      00:28:35    
REPLICAT    RUNNING     REP2        00:00:00      00:00:01    


GGSCI (dg1) 2> alter extract ext1,begin now
EXTRACT altered.


GGSCI (dg1) 3>  alter extract ext1,extseqno 1,extrba 0

GGSCI (dg1) 4> start extract ext1

Sending START request to MANAGER ...
EXTRACT EXT1 starting


GGSCI (dg1) 5> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EXT1        00:00:00      00:00:09    
REPLICAT    RUNNING     REP2        00:00:00      00:00:05    


GGSCI (dg1) 6> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     ABENDED     EXT1        00:00:00      00:00:24    
REPLICAT    RUNNING     REP2        00:00:00      00:00:08    


GGSCI (dg1) 7> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     ABENDED     EXT1        00:00:00      00:05:06    
REPLICAT    RUNNING     REP2        00:00:00      00:00:09    


GGSCI (dg1) 8> delete extract ext1

2013-08-28 17:40:03  WARNING OGG-01753  Cannot unregister EXTRACT EXT1 from database because no database login was provid unregister this group later with the UNREGISTER EXTRACT command with LOGRETENTION. Issue DBLOGIN first.
Deleted EXTRACT EXT1.


GGSCI (dg1) 9> dblogin userid ggs,password ggs
Successfully logged into database.

GGSCI (dg1) 10> delete extract ext1
ERROR: EXTRACT EXT1 does not exist.


GGSCI (dg1) 11> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
REPLICAT    RUNNING     REP2        00:00:00      00:00:01    


GGSCI (dg1) 12> add extract ext1,tranlog,begin now
EXTRACT added.


GGSCI (dg1) 13> add exttrail ./dirdat/gg,extract ext1,megabytes 100
EXTTRAIL added.


GGSCI (dg1) 14> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     STOPPED     EXT1        00:00:00      00:00:10    
REPLICAT    RUNNING     REP2        00:00:00      00:00:02    


GGSCI (dg1) 15> start extract ext1

Sending START request to MANAGER ...
EXTRACT EXT1 starting


GGSCI (dg1) 15> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EXT1        00:00:00      00:00:20    
REPLICAT    RUNNING     REP2        00:00:00      00:00:02