错误原因：
因两边同步出错，数据已不一致，我添加字段后也没有有同步过去，所以我把表删除重建。
但后来错误更多，想直接删除同步文件（./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
因两边同步出错，数据已不一致，我添加字段后也没有有同步过去，所以我把表删除重建。
但后来错误更多，想直接删除同步文件（./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
