模拟一下goldengate中断后,重新同步操作介绍.doc

模拟一下goldengata中断后，重新同步操作： 1、关掉源端抽取进程 GGSCI 2105) 15 info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EORA 00:00:00 00:00:03 EXTRACT RUNNING PUMP_SO 00:00:00 00:00:09 GGSCI 2105) 16 stop eora Sending STOP request to EXTRACT EORA ... Request processed. GGSCI 2105) 17 stop pump_so Sending STOP request to EXTRACT PUMP_SO ... Request processed. GGSCI 2105) 18 info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING EXTRACT STOPPED EORA 00:00:00 00:00:07 EXTRACT STOPPED PUMP_SO 00:00:00 00:00:02 2、关掉目标端进程 GGSCI (PC0527ZQM) 16 info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING REPLICAT RUNNING REPL 00:00:00 00:00:09 GGSCI (PC0527ZQM) 17 stop repl Sending STOP request to REPLICAT REPL ... Request processed. GGSCI (PC0527ZQM) 18 info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING REPLICAT STOPPED REPL 00:00:00 00:00:02 3、检查源端demo表 SQL select count(*) from demo; COUNT(*) ---------- 0 4、检查目标端demo表 SQL select count(1) from demo; COUNT(1) ---------- 0 5、源端插入100000表数据 SQL insert into demo 2 select level,level||a from dual connect by level = 100000; 100000 rows inserted SQL commit; Commit complete 6、如果现在直接重启goldengate，数据是能同步过去的，这没有问题，也没有难度。 我现在要做的操作是： (1)结束当前的本地日志，重新开始一个日志。 (2)然后从当前序列重新抓取。 7、源端操作。 D:\goldengate\dirdatls et000151 et000153 et000155 et000157 et000159 et000161 et000163 et000152 et000154 et000156 et000158 et000160 et000162 et000164 --当前是164号文件，重启的时候自动会变成165， --现在我手动结束164号文件，然后设置抽取进程从165号文件开始抓取。 GGSCI 2105) 19 alter extract eora etrollover 2011-12-14 13:43:21 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 trails reader (either pump EXTRACT or REPLICAT) to move the readers scan to the new trail file; it will not happen automatically. EXTRACT altered. GGSCI 2105) 20 alter eora extseqno 165,extrba 0 EXTRACT altered. --同时我也