模擬一下goldengate中斷后,重新同步操作

-.z.模擬一下goldengata中斷后，重新同步操作：1、關(guān)掉源端抽取進程GGSCI(20081122-2105)15>infoallProgramStatusGroupLagTimeSinceChkptMANAGERRUNNINGE*TRACTRUNNINGEORA00:00:0000:00:03E*TRACTRUNNINGPUMP_SO00:00:0000:00:09GGSCI(20081122-2105)16>stopeoraSendingSTOPrequesttoE*TRACTEORA...Requestprocessed.GGSCI(20081122-2105)17>stoppump_soSendingSTOPrequesttoE*TRACTPUMP_SO...Requestprocessed.GGSCI(20081122-2105)18>infoallProgramStatusGroupLagTimeSinceChkptMANAGERRUNNINGE*TRACTSTOPPEDEORA00:00:0000:00:07E*TRACTSTOPPEDPUMP_SO00:00:0000:00:022、關(guān)掉目標端進程GGSCI(PC0527ZQM)16>infoallProgramStatusGroupLagTimeSinceChkptMANAGERRUNNINGREPLICATRUNNINGREPL00:00:0000:00:09GGSCI(PC0527ZQM)17>stopreplSendingSTOPrequesttoREPLICATREPL...Requestprocessed.GGSCI(PC0527ZQM)18>infoallProgramStatusGroupLagTimeSinceChkptMANAGERRUNNINGREPLICATSTOPPEDREPL00:00:0000:00:023、檢查源端demo表SQL>selectcount(*)fromdemo;COUNT(*)----------04、檢查目標端demo表SQL>selectcount(1)fromdemo;COUNT(1)----------05、源端插入100000表數(shù)據(jù)SQL>insertintodemo2selectlevel,level||'a'fromdualconnectbylevel<=100000;100000rowsinsertedSQL>mit;mitplete6、如果現(xiàn)在直接重啟goldengate，數(shù)據(jù)是能同步過去的，這沒有問題，也沒有難度。我現(xiàn)在要做的操作是：(1)完畢當前的本地日志，重新開場一個日志。(2)然后從當前序列重新抓取。7、源端操作。D:\goldengate\dirdat>lset000151et000153et000155et000157et000159et000161et000163et000152et000154et000156et000158et000160et000162et000164--當前是164號文件，重啟的時候自動會變成165，--現(xiàn)在我手動完畢164號文件，然后設(shè)置抽取進程從165號文件開場抓取。GGSCI(20081122-2105)19>altere*tracteoraetrollover2011-12-1413:43:21INFOOGG-01520Rolloverperformed.ForeachaffectedoutputtrailofVersion10orhigherformat,afterstartingthesourcee*tract,issueALTERE*TSEQNOforthattrail'sreader(eitherpumpE*TRACTorREPLICAT)tomovethereader'sscantothenewtrailfile;itwillnothappenautomatically.E*TRACTaltered.GGSCI(20081122-2105)20>altereorae*tseqno165,e*trba0E*TRACTaltered.--同時我也設(shè)置投遞進程的號也為165號文件GGSCI(20081122-2105)22>altere*tractpump_soetrollover2011-12-1413:46:03INFOOGG-01520Rolloverperformed.ForeachaffectedoutputtrailofVersion10orhigherformat,afterstartingthesourcee*tract,issueALTERE*TSEQNOforthattrail'sreader(eitherpumpE*TRACTorREPLICAT)tomovethereader'sscantothenewtrailfile;itwillnothappenautomatically.E*TRACTaltered.GGSCI(20081122-2105)23>alterpump_soe*tseqno165,e*trba0E*TRACTaltered.8、現(xiàn)在是關(guān)鍵一步，設(shè)置從哪個時間點開場抓取事務(wù)。ALTERE*TRACTeora,TRANLOG,BEGIN2011-12-1413:309、重啟源端進程。GGSCI(20081122-2105)25>starteoraSendingSTARTrequesttoMANAGER('GGSMGR')...E*TRACTEORAstartingGGSCI(20081122-2105)26>startpump_soSendingSTARTrequesttoMANAGER('GGSMGR')...E*TRACTPUMP_SOstartingGGSCI(20081122-2105)27>infoallProgramStatusGroupLagTimeSinceChkptMANAGERRUNNINGE*TRACTRUNNINGEORA00:00:0000:00:05E*TRACTRUNNINGPUMP_SO00:00:0000:05:1510、看看源端本地日志，重新生成了165、166、167號文件。而164號文件沒寫滿就完畢了。D:\goldengate\dirdat>ls-l總用量44552-rw*rw*---+1AdministratorsSYSTEM359769十一1608:58et000151-rw*rw*---+1AdministratorsSYSTEM17448十二509:39et000152-rw*rw*---+1AdministratorsSYSTEM978十二1410:48et000153-rw*rw*---+1AdministratorsSYSTEM1270十二1410:50et000154-rw*rw*---+1AdministratorsSYSTEM919十二1411:16et000155-rw*rw*---+1AdministratorsSYSTEM1414十二1411:17et000156-rw*rw*---+1AdministratorsSYSTEM1414十二1411:17et000157-rw*rw*---+1AdministratorsSYSTEM919十二1411:30et000158-rw*rw*---+1AdministratorsSYSTEM1559十二1411:30et000159-rw*rw*---+1AdministratorsSYSTEM1500十二1411:33et000160-rw*rw*---+1AdministratorsSYSTEM919十二1413:25et000161-rw*rw*---+1AdministratorsSYSTEM9999953十二1413:25et000162-rw*rw*---+1AdministratorsSYSTEM9999978十二1413:31et000163-rw*rw*---+1AdministratorsSYSTEM2570306十二1413:31et000164-rw*rw*---+1AdministratorsSYSTEM9999953十二1413:51et000165-rw*rw*---+1AdministratorsSYSTEM9999961十二1413:51et000166-rw*rw*---+1AdministratorsSYSTEM2569952十二1413:51et00016711、此時查看目標端遠程日志。D:\ggs\ggs\dirdat>dir驅(qū)動器D中的卷沒有標簽。卷的序列號是30DD-ABBCD:\ggs\ggs\dirdat的目錄2011-12-1413:51.2011-12-1413:51..2011-12-0509:3917,595pt0001512011-12-0510:131,167pt0001522011-12-1410:481,150pt0001532011-12-1411:021,543pt0001542011-12-1411:131,234pt0001552011-12-1411:272,266pt0001562011-12-1411:311,318pt0001572011-12-1411:331,360pt0001582011-12-1411:341,983pt0001592011-12-1413:269,999,996pt0001612011-12-1413:319,999,915pt0001622011-12-1413:312,570,455pt0001632011-12-1413:519,999,996pt0001642011-12-1413:519,999,884pt0001652011-12-1413:512,570,115pt000166可以看出，163號文件完畢，重新開場了165,166文件，但是和源端差一個文件號。源端是165-167，目的端是164-166，這沒有關(guān)系。12、設(shè)置目標段讀取進程，從164號文件開場讀取。GGSCI(PC0527ZQM)21>alterREPLICATreple*tseqno164,e*trba0REPLICATaltered.GGSCI(PC0527ZQM)23>startreplSendingSTARTrequesttoMANAGER('GGSMGR')...REPLICATREPLstartingGGSCI(PC0527ZQM)24>infoallProgramStatusGroupLagTimeSinceChkptMANAGERRUNNINGREPLICATRUNNINGREPL00:00:0000:00:1213、檢查源端端數(shù)據(jù)情況。SQL>selectcount(1)fromdemo;COUNT(1)----------10000014、檢查目標端數(shù)據(jù)情況SQL>selectcount(1)fromdemo;COUNT(1)----------100000至此，golde