1.測試ogg中斷之后，重新同步操作1.1.關(guān)閉源端抽取進(jìn)程GGSCI (cndba) 65> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING EXTRACT RUNNING EXT1 00:00:00 00:00:09 EXTRACT RUNNING PUMP1 00:00:00 00:00:08 GGSCI (cndba) 66> stop ext1Sending STOP request to EXTRACT EXT1 ...Request processed.GGSCI (cndba) 67> stop pump1Sending STOP request to EXTRACT PUMP1 ...Request processed.GGSCI (cndba) 68> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING EXTRACT STOPPED EXT1 00:00:00 00:00:04 EXTRACT STOPPED PUMP1 00:00:00 00:00:01
1.2.關(guān)閉目標(biāo)端進(jìn)程GGSCI (cndba) 55> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING REPLICAT RUNNING REP1 00:00:00 00:00:08 GGSCI (cndba) 56> stop rep1Sending STOP request to REPLICAT REP1 ...Request processed.GGSCI (cndba) 57> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING REPLICAT STOPPED REP1 00:00:00 00:00:01
1.3.檢查源端，目標(biāo)端表數(shù)據(jù)--源端SQL> select * from test1;no rows selected--目標(biāo)端SQL> select * from test1;no rows selected
1.4.源端表插入100000條數(shù)據(jù)記住插入之前的時(shí)間2018-06-07 16:15:24，這個(gè)時(shí)間點(diǎn)很重要，extract 進(jìn)程要從這個(gè)時(shí)間開始抽取SQL> insert into test1 select level,level||'t' from dual connect by level <= 100000;100000 rows created.SQL> commit;Commit complete.SQL> select count(*) from test1; COUNT(*)---------- 100000如果此時(shí)開啟源端extract進(jìn)程，目標(biāo)端replicat，數(shù)據(jù)同步不會(huì)出現(xiàn)問題，現(xiàn)在的操作就是：1）結(jié)束當(dāng)前的本地日志，重新開始一個(gè)日志2）從當(dāng)前新生成的序列重新抓取
1.5.源端操作1.5.1.查看當(dāng)前tail文件信息[root@www.cndba.cn dirdat]# lltotal 12drwxr-xr-x 2 root root 4096 Jun 7 15:47 backup-rw-rw-rw- 1 oracle oinstall 1405 Jun 7 16:11 et000000-rw-rw-rw- 1 oracle oinstall 1016 Jun 7 16:19 et000001可以看到當(dāng)前tail文件是1號(hào)文件，重啟的時(shí)候會(huì)自動(dòng)變成2號(hào)文件。
1.5.2.重新生成新的tail文件，抽取進(jìn)程，投遞進(jìn)程從新的tail文件開始抓取數(shù)據(jù)GGSCI (cndba) 70> alter extract ext1 etrollover2018-06-07 16:33:40 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 REPLICAT) to move the reader's scan to the new trail file; it will not happen automatically.EXTRACT altered.GGSCI (cndba) 71> alter extract ext1,thread 1,extseqno 2,extrba 0EXTRACT altered.GGSCI (cndba) 72> alter extract pump1 etrollover2018-06-07 16:34:26 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 REPLICAT) to move the reader's scan to the new trail file; it will not happen automatically.EXTRACT altered.GGSCI (cndba) 73> alter extract pump1,thread 1,extseqno 2,extrba 0EXTRACT altered.
1.5.3.源端從插入數(shù)據(jù)之前的時(shí)間開始抓取數(shù)據(jù)GGSCI (cndba) 74> ALTER EXTRACT ext1, TRANLOG, BEGIN 2018-06-07 16:15:24EXTRACT altered.
1.5.4.重啟源端進(jìn)程GGSCI (cndba) 58> start ext1Sending START request to MANAGER ...EXTRACT EXT1 startingGGSCI (cndba) 59> start pump1Sending START request to MANAGER ...EXTRACT PUMP1 startingGGSCI (cndba) 64> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING EXTRACT RUNNING EXT1 00:00:00 00:00:06 EXTRACT RUNNING PUMP1 00:00:00 00:00:01
1.6.目標(biāo)端操作1.6.1.查看tail文件可以看到目標(biāo)端也生成了新的tail文件號(hào)，目標(biāo)端從這個(gè)文件應(yīng)用數(shù)據(jù)[root@www.cndba.cn dirdat]# lltotal 21484drwxr-xr-x 2 root root 4096 Jun 7 15:48 backup-rw-rw-rw- 1 oracle oinstall 1444 Jun 7 16:11 et000000-rw-rw-rw- 1 oracle oinstall 0 Jun 7 16:19 et000001-rw-rw-rw- 1 oracle oinstall 21989995 Jun 7 16:35 et000002
1.6.2.設(shè)置目標(biāo)段讀取進(jìn)程，從2號(hào)文件開始讀取GGSCI (cndba) 74> alter REPLICAT rep1 extseqno 2, extrba 0REPLICAT altered.GGSCI (cndba) 75> start rep1Sending START request to MANAGER ...REPLICAT REP1 startingGGSCI (cndba) 76> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING REPLICAT RUNNING REP1 00:00:00 00:00:04
1.6.3.檢查目標(biāo)端數(shù)據(jù)SQL> select count(1) from test1; COUNT(1)---------- 100000
1.7.命令--前滾重新生成一個(gè)新的隊(duì)列文件alter extract xxx etrollover--從指定時(shí)間重新抓?。ㄖ匦伦ト?shù)據(jù)前提：歸檔文件沒有刪除）ALTER EXTRACT xxx, TRANLOG, BEGIN 2010-12-31 08:00--重置抽取進(jìn)程，本地文件序列號(hào)從0開始生成。alter extract ext1,extseqno 0,extrba 0--重置讀取進(jìn)程，重新從0號(hào)trial文件開始讀取。alter replicat rep1,extseqno 0,extrba 0
|
