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

《模拟一下goldengate中断后,重新同步操作.doc》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、模拟一下goldengata中断后，重新同步操作：1、关掉源端抽取进程GGSCI(20081122-2105)15>infoallProgramStatusGroupLagTimeSinceChkptMANAGERRUNNINGEXTRACTRUNNINGEORA00:00:0000:00:03EXTRACTRUNNINGPUMP_SO00:00:0000:00:09GGSCI(20081122-2105)16>stopeoraSendingSTOPrequesttoEXTRACTEORA...Requestprocessed.GGSCI(20081122-2105)1

2、7>stoppump_soSendingSTOPrequesttoEXTRACTPUMP_SO...Requestprocessed.GGSCI(20081122-2105)18>infoallProgramStatusGroupLagTimeSinceChkptMANAGERRUNNINGEXTRACTSTOPPEDEORA00:00:0000:00:07EXTRACTSTOPPEDPUMP_SO00:00:0000:00:022、关掉目标端进程GGSCI(PC0527ZQM)16>infoallProgramStatusGroupLagTimeSinceChkptM

3、ANAGERRUNNINGREPLICATRUNNINGREPL00:00:0000:00:09GGSCI(PC0527ZQM)17>stopreplSendingSTOPrequesttoREPLICATREPL...Requestprocessed.GGSCI(PC0527ZQM)18>infoallProgramStatusGroupLagTimeSinceChkptMANAGERRUNNINGREPLICATSTOPPEDREPL00:00:0000:00:023、检查源端demo表SQL>selectcount(*)fromdemo;COUNT(*)-----

4、-----04、检查目标端demo表SQL>selectcount(1)fromdemo;COUNT(1)----------05、源端插入100000表数据SQL>insertintodemo2selectlevel,level

5、

6、'a'fromdualconnectbylevel<=100000;100000rowsinsertedSQL>commit;Commitcomplete6、如果现在直接重启goldengate，数据是能同步过去的，这没有问题，也没有难度。我现在要做的操作是：(1)结束当前的本地日志，重新开始一个日志。(2)然后从当前序列重新抓取。7、源端

7、操作。D:goldengatedirdat>lset000151et000153et000155et000157et000159et000161et000163et000152et000154et000156et000158et000160et000162et000164--当前是164号文件，重启的时候自动会变成165，--现在我手动结束164号文件，然后设置抽取进程从165号文件开始抓取。GGSCI(20081122-2105)19>alterextracteoraetrollover2011-12-1413:43:21INFOOGG-01520Rollover

8、performed.ForeachaffectedoutputtrailofVersion10orhigherformat,afterstartingthesourceextract,issueALTEREXTSEQNOforthattrail'sreader(eitherpumpEXTRACTorREPLICAT)tomovethereader'sscantothenewtrailfile;itwillnothappenautomatically.EXTRACTaltered.GGSCI(20081122-2105)20>altereoraextseqno165,ex

9、trba0EXTRACTaltered.--同时我也设置投递进程的号也为165号文件GGSCI(20081122-2105)22>alterextractpump_soetrollover2011-12-1413:46:03INFOOGG-01520Rolloverperformed.ForeachaffectedoutputtrailofVersion10orhigherformat,afterstartingthesourceextract,issueALTEREXTSEQNOforthattrail'sreader(eitherpu