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

1、模擬一下goldengata中斷后，重新同步操作：1、關(guān)掉源端抽取進(jìn)程GGSCI (20081122-2105) 15> info allProgram Status Group Lag Time Since ChkptMANAGER RUNNINGEXTRACT RUNNING EORA 00:00:00 00:00:03EXTRACT RUNNING PUMP_SO 00:00:00 00:00:09GGSCI (20081122-2105) 16> stop eoraSending STOP request to EXTRACT EORA .Request processed

2、.GGSCI (20081122-2105) 17> stop pump_soSending STOP request to EXTRACT PUMP_SO .Request processed.GGSCI (20081122-2105) 18> info allProgram Status Group Lag Time Since ChkptMANAGER RUNNINGEXTRACT STOPPED EORA 00:00:00 00:00:07EXTRACT STOPPED PUMP_SO 00:00:00 00:00:022、關(guān)掉目標(biāo)端進(jìn)程GGSCI (PC0527ZQM)

3、16> info allProgram Status Group Lag Time Since ChkptMANAGER RUNNINGREPLICAT RUNNING REPL 00:00:00 00:00:09GGSCI (PC0527ZQM) 17> stop replSending STOP request to REPLICAT REPL .Request processed.GGSCI (PC0527ZQM) 18> info allProgram Status Group Lag Time Since ChkptMANAGER RUNNINGREPLICAT S

4、TOPPED REPL 00:00:00 00:00:023、檢查源端demo表SQL> select count(*) from demo;COUNT(*)-04、檢查目標(biāo)端demo表SQL> select count(1) from demo;COUNT(1)-0 5、源端插入100000表數(shù)據(jù)SQL> insert into demo2 select level,level|'a' from dual connect by level <= 100000;100000 rows insertedSQL> commit;Commit compl

5、ete 6、如果現(xiàn)在直接重啟goldengate，數(shù)據(jù)是能同步過去的，這沒有問題，也沒有難度。我現(xiàn)在要做的操作是：(1)結(jié)束當(dāng)前的本地日志，重新開始一個(gè)日志。(2)然后從當(dāng)前序列重新抓取。7、源端操作。D:goldengatedirdat>lset000151 et000153 et000155 et000157 et000159 et000161 et000163et000152 et000154 et000156 et000158 et000160 et000162 et000164-當(dāng)前是164號(hào)文件，重啟的時(shí)候自動(dòng)會(huì)變成165，-現(xiàn)在我手動(dòng)結(jié)束164號(hào)文件，然后設(shè)置抽取進(jìn)程從16

6、5號(hào)文件開始抓取。GGSCI (20081122-2105) 19> alter extract eora etrollover2011-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 trail's reader (either pump EXTRACT or REPLICA

7、T) to move the reader's scan to the new trail file; it will not happen automatically.EXTRACT altered.GGSCI (20081122-2105) 20> alter eora extseqno 165,extrba 0EXTRACT altered.-同時(shí)我也設(shè)置投遞進(jìn)程的號(hào)也為165號(hào)文件GGSCI (20081122-2105) 22> alter extract pump_so etrollover2011-12-14 13:46:03 INFO OGG-01520 R

8、ollover performed. For each affected output trail of Version 10 or higher format, after starting the source extract, issue ALTER EXTSEQNO for that trail's reader (either pump EXTRACT or REPLICAT) to move the reader's scan to the new trail file; it will not happen automatically.EXTRACT altere

9、d.GGSCI (20081122-2105) 23> alter pump_so extseqno 165,extrba 0EXTRACT altered.8、現(xiàn)在是關(guān)鍵一步，設(shè)置從哪個(gè)時(shí)間點(diǎn)開始抓取事務(wù)。ALTER EXTRACT eora, TRANLOG, BEGIN 2011-12-14 13:309、重啟源端進(jìn)程。GGSCI (20081122-2105) 25> start eoraSending START request to MANAGER ('GGSMGR') .EXTRACT EORA startingGGSCI (20081122-2105

10、) 26> start pump_soSending START request to MANAGER ('GGSMGR') .EXTRACT PUMP_SO startingGGSCI (20081122-2105) 27> info allProgram Status Group Lag Time Since ChkptMANAGER RUNNINGEXTRACT RUNNING EORA 00:00:00 00:00:05EXTRACT RUNNING PUMP_SO 00:00:00 00:05:1510、看看源端本地日志，重新生成了165、166、167號(hào)

11、文件。而164號(hào)文件沒寫滿就結(jié)束了。D:goldengatedirdat>ls -l總用量 44552-rwxrwx-+ 1 Administrators SYSTEM 359769 十一 16 08:58 et000151-rwxrwx-+ 1 Administrators SYSTEM 17448 十二 5 09:39 et000152-rwxrwx-+ 1 Administrators SYSTEM 978 十二 14 10:48 et000153-rwxrwx-+ 1 Administrators SYSTEM 1270 十二 14 10:50 et000154-rwxrwx-+

12、 1 Administrators SYSTEM 919 十二 14 11:16 et000155-rwxrwx-+ 1 Administrators SYSTEM 1414 十二 14 11:17 et000156-rwxrwx-+ 1 Administrators SYSTEM 1414 十二 14 11:17 et000157-rwxrwx-+ 1 Administrators SYSTEM 919 十二 14 11:30 et000158-rwxrwx-+ 1 Administrators SYSTEM 1559 十二 14 11:30 et000159-rwxrwx-+ 1 Admi

13、nistrators SYSTEM 1500 十二 14 11:33 et000160-rwxrwx-+ 1 Administrators SYSTEM 919 十二 14 13:25 et000161-rwxrwx-+ 1 Administrators SYSTEM 9999953 十二 14 13:25 et000162-rwxrwx-+ 1 Administrators SYSTEM 9999978 十二 14 13:31 et000163-rwxrwx-+ 1 Administrators SYSTEM 2570306 十二 14 13:31 et000164-rwxrwx-+ 1 A

14、dministrators SYSTEM 9999953 十二 14 13:51 et000165-rwxrwx-+ 1 Administrators SYSTEM 9999961 十二 14 13:51 et000166-rwxrwx-+ 1 Administrators SYSTEM 2569952 十二 14 13:51 et00016711、此時(shí)查看目標(biāo)端遠(yuǎn)程日志。D:ggsggsdirdat>dir驅(qū)動(dòng)器 D 中的卷沒有標(biāo)簽。卷的序列號(hào)是 30DD-ABBCD:ggsggsdirdat 的目錄2011-12-14 13:51 .2011-12-14 13:51 .2011-12

15、-05 09:39 17,595 pt0001512011-12-05 10:13 1,167 pt0001522011-12-14 10:48 1,150 pt0001532011-12-14 11:02 1,543 pt0001542011-12-14 11:13 1,234 pt0001552011-12-14 11:27 2,266 pt0001562011-12-14 11:31 1,318 pt0001572011-12-14 11:33 1,360 pt0001582011-12-14 11:34 1,983 pt0001592011-12-14 13:26 9,999,996

16、pt0001612011-12-14 13:31 9,999,915 pt0001622011-12-14 13:31 2,570,455 pt0001632011-12-14 13:51 9,999,996 pt0001642011-12-14 13:51 9,999,884 pt0001652011-12-14 13:51 2,570,115 pt000166可以看出，163號(hào)文件結(jié)束，重新開始了165,166文件，但是和源端差一個(gè)文件號(hào)。源端是165-167，目的端是164-166，這沒有關(guān)系。12、設(shè)置目標(biāo)段讀取進(jìn)程，從164號(hào)文件開始讀取。GGSCI (PC0527ZQM) 21&g

17、t; alter REPLICAT repl extseqno 164, extrba 0REPLICAT altered.GGSCI (PC0527ZQM) 23> start replSending START request to MANAGER ('GGSMGR') .REPLICAT REPL startingGGSCI (PC0527ZQM) 24> info allProgram Status Group Lag Time Since ChkptMANAGER RUNNINGREPLICAT RUNNING REPL 00:00:00 00:00:1213、檢查源端端數(shù)據(jù)情況。SQL> select count(1) from demo;COUNT(1)-10000014、檢查目標(biāo)端數(shù)據(jù)情況 SQL> select count(1) from demo;COUNT(1)-100000至此，gold