| GGSCI (server2) 3> info reptr, showch ? REPLICAT REPTR Initialized 2015-01-30 13:39 Status STOPPED Checkpoint Lag 00:00:00 (updated 00:00:07 ago) Log Read Checkpoint File ./dirdat/tr000004 First Record RBA 0 ? ? Current Checkpoint Detail: ? Read Checkpoint #1 ? GGS Log Trail ? Startup Checkpoint (starting position in the data source): Sequence #: 4 RBA: 0 Timestamp: Not Available Extract Trail: ./dirdat/tr ? Current Checkpoint (position of last record read in the data source): Sequence #: 4 RBA: 0 Timestamp: Not Available Extract Trail: ./dirdat/tr …… |
Start checkpoint 的sequence#和RBA号已经通过手工，都定位到了源端ETROLLOVER后的状态
Current checkpoint的sequence#和RBA号已经通过手工，也都定位到了源端ETROLLOVER后的状态
7.5 查看checkpoint表的数据内容
| SQL>select * from goldengate.checkpoint_reptr_01; No rows selected ? SQL>select * from goldengate.checkpoint_reptr_01_lox; No rows selected |
这时，两个checkpoint表中的数据还是空的，待replicat启动运行后，进行状态信息就会写入到checkpoint表中
?
8、启动源端和目标端进程
8.1 启动目标端的replicat和mgr进程
GGSCI>start mgr
GGSCI>start reptr
8.2 启动源端的datapump进程
GGSCI>start dpetr
9、验证是否能继续同步数据
此步最重要的，是要验证在升级时间时，源端所做的操作能否同步到目标库中来。本案例在升级过程中，对goldengate.ogg_upg表删除了1000000行数据。
9.1 查看目标端goldengate.ogg_upg表的数据变化
| 源端 |
目标端 |
| SQL> select count(*) from goldengate.ogg_upg; COUNT(*) ---------- 2050000 |
SQL> select count(*) from goldengate.ogg_upg; COUNT(*) ---------- 2050000 ? |
9.2 目标端查看checkpoint表内check状态
| select * from goldengate.checkpoint_reptr_01 ------------------------------------------------- REPTR 2149948420 4 19280017 2015-01-30 13:55:59.368501 2015/1/30 13:36:43 2015/1/30 14:01:01 /u01/ogg 17929533 7.16.20512 17929533 7.16.20512 1 |
?
从上面两步看来，升级后replicat正常的，接着升级前的状态在同步数据。
?