Shulou(Shulou.com)06/02 Report--

1. Turn off the source-side extraction process GGSCI (20081122 - 2105) 15> info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EORA 00:00:00:03 EXTRACT RUNNING PUMP_SO 00:00:00:09 GGSCI (20081122 - 2105) 16> stop eora Sending STOP request to EXTRACT EORA... Request processed. GGSCI (20081122-2105) 17> stop pump_so Sending STOP request to EXTRACT PUMP_SO ... Request processed. GGSCI (20081122 - 2105) 18> info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING EXTRACT STOPPED EORA 00:00:00:07 EXTRACT STOPPED PUMP_SO 00:00:00 00:02 2 2, Close Target End Process GGSCI (PC0527ZQM) 16> info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING REPLICAT RUNNING REPL 00:00:00:09 GGSCI (PC0527ZQM) 17> stop repl Sending request to REPLICAT REPL... STOP Request processed. GGSCI (PC0527 ZQM) 18> info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING REPLICAT STOPPED REPL 00:00:00:02 3. Check the source-side demo table SQL> select count (*) from demo; COUNT (*)-------0 4. Check the target-side demo table SQL> select count (1) from demo; COUNT (1)-------0 5. Insert 100000 table data from the source-side SQL> insert into demo 2 select level, level|| 'a' from dual connect by level commit; Commit complete 6. If you restart goldengate directly now, the data can be synchronized in the past. There is no problem or difficulty. What I'm going to do now is: (1) End the current local log and restart a log. (2)Then re-grab from the current sequence. 7. Source operation. D: \goldengate\dirdat> ls et 000151 et 000153 et 000155 et 000157 et 000159 et 000161 et 000163 et 000152 et 000154 et 000156 et 000158 et 000160 et 000162 et 000164--The current file number is 164, which will automatically change to 165 when restarting, --Now I manually end file number 164, and then set the extraction process to start from file number 165. GGSCI (20081122-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 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 (20081122-2105) 20> alter eora extseqno 165,extrba 0 EXTRACT altered. GGSCI (20081122 - 2105) 22> alternate extract pump_so rollover 2011 - 12 - 14 13:46:03 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 rea der (either pump EXTRACT or REPLICAT) to move the reader's scan to the new trail file; it will not happen automatically. EXTRACT altered. GGSCI (20081122-2105) 23> alter pump_so extseqno 165,extrba 0 EXTRACT altered. 8, now is the key step, set from which point in time to start fetching transactions. ALTER EXTRACT eora, TRANLOG, BEGIN 2011 - 12 - 14 13:30 9, Restart the source process. GGSCI (20081122-2105) 25> start eora Sending START request to MANAGER ('GGSMGR') ... EXTRACT EORA starting GGSCI (20081122-2105) 26> start pump_so Sending START request to MANAGER ('GGSMGR') ... EXTRACT PUMP_SO starting GGSCI (20081122 - 2105) 27> info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EORA 00:00:00 00:05 EXTRACT RUNNING PUMP_SO 00:00:00 00:05:15 10. Look at the source local log and regenerate files 165, 166 and 167. And file 164 ends before it's full. D:\goldengate\dirdat> ls-l Total Usage 44552-rwxrwx--+1 Administrators SYSTEM 359769 Eleven 16 08:58 et 000151-rwxrwx---+1 Administrators SYSTEM 17448 XII 5 09:39 et 000152-rwxrwx---+1 Administrators SYSTEM 978 XII 14 10:48 et 000153-rwxrwx---+1 Administrators SYSTEM 1270 XII 14 10:50 et 000154-rwxrwx---+1 Administrators SYSTEM 919 XII 14 11:16 et 000155-rwxrwx---+1 Administrators SYSTEM 1414 Twelve 14 11:17 et 000156-rwxrwx---+1 Administrators SYSTEM 1414 Twelve 14 11:17 et 000157-rwxrwx---+1 Administrators SYSTEM 919 XII 14 11:30 et 000158-rwxrwx---+1 Administrators SYSTEM 1559 Twelve 14 11:30 et 000159-rwxrwx---+1 Administrators SYSTEM 1500 XII 14 11:33 et 000160-rwxrwx---+1 Administrators SYSTEM 919 XII 14 13: 25 et 000161-rwxrwx---+1 Administrators SYSTEM 999953 Twelve 14 13:25 et 000162-rwxrwx---+1 Administrators SYSTEM 999978 Twelve 14 13:31 et 000163-rwxrwx---+1 Administrators SYSTEM 2570306 Twelve 14 13:31 et 000164-rwxrwx---+1 Administrators SYSTEM 999953 Twelve 14 13:51 et 000165-rwxrwx---+1 Administrators SYSTEM 999961 Twelve 14 13:51 et 000166-rwxrwx---+1 Administrators SYSTEM 2569952 Twelve 14 13:51 et 000167 11. Check the remote log on the target side at this time. D: \ggs\ggs\dirdat> dir Volumes in drive D do not have labels. The serial number of the volume is 30 DD-ABBC D: \ggs\ggs\dirdat directory 2011 - 12 - 14 13:51. 2011-12-14 13:51 .. 2011 - 12 - 05 09:39 17,595 pt 000151 2011 - 12 - 05 10:00 13 1,167 pt 000152 2011 - 12 - 14 10:48 1,150 pt 000153 2011 - 12 - 14 11:02 1,543 pt 000154 2011 - 12 - 14 11:13 1,234 pt 000155 2011 - 12 - 14 27 2,266 pt 000156 2011 - 12 - 14 11:31 1,318 pt 000157 2011 - 12 - 14 11:33 1,360 pt 000158 2011 - 12 - 14 11:34 1,983 pt 000159 2011 - 12 - 14 13 26 9,999,996 pt 000161 December 14, 2011 13:31 9,999,915 pt 000162 December 14, 2011 13:31 2,570,455 pt 000163 December 14, 2011 13:51 9,999,996 pt 000164 December 14, 2011 13:51 9,999,884 pt 000165 December 14, 2011 13:51 2,570,115 pt 000166 It can be seen that file 163 ends and file 165,166 is restarted, but there is a file number difference from the source end. The source is 165 - 167 and the destination is 164 - 166, which doesn't matter. 12. Set the target segment reading process, starting with file 164. GGSCI (PC0527ZQM) 21> alter REPLICAT repl extseqno 164, extrba 0 REPLICAT altered. GGSCI (PC0527ZQM) 23> start repl Sending START request to MANAGER ('GGSMGR') ... REPLICAT REPL starting GGSCI (PC0527 ZQM) 24> info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING REPLICAT RUNNING REPL 00:00:00:12 13. Check the source data. SQL> select count (1) from demo; COUNT (1)--------100000 14. Check the target data. SQL> select count (1) from demo; COUNT (1)---------100000 At this point, after goldengate was interrupted, resynchronization succeeded again. The following command is critical: --Roll forward to regenerate a new queue file alter extract xxx etrollover--Refetch from specified time ALTER EXTRACT xxx, TRANLOG, BEGIN 2010 - 12 - 31 08:00--Reset extraction process, local file serial number generated from 0. alter extract ext 1, abstrseqno 0, extrba 0--Reset the reading process, starting reading again from trial file number 0. alter replicat rep1,extseqno 0,extrba 0

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.