OGG "Loading data from file to Replicat"table數據的靜態同步配置過程
一、mgr進程
GGSCI (lei1) 3> view params mgr port 7809
二、抽取進程extftor
GGSCI (lei1) 4> view params extftor SOURCEISTABLE userid goldengate, password yyyyy rmthost 192.168.100.189, mgrport 7809 RMTFILE /u02/ggs/dirdat/pp, MAXFILES 1000, MEGABYTES 100 table test.xxx;
三、抽取進程repftor
GGSCI (lei1) 5> view params repftor SPECIALRUN END RUNTIME userid goldengate, password yyyy extfile /u02/ggs/dirdat/pp ASSUMETARGETDEFS map test.xxx target testhvr.xxxx;
四、從操作系統命令行發起extract(注意:此種extract,ggsci的info all是看不到的)
[oracle@lei1 ggs]$ cd /u02/ggs [oracle@lei1 ggs]$ pwd /u02/ggs [oracle@lei1 ggs]$ extract paramfile /u02/ggs/dirprm/extftor.prm reportfile /u02/ggs/dirrpt/EXTFTOR.rpt ---->請務必確保發起上面extract的securecrt不中斷!建議在vncserver或者以nohup方式執行此extract。 nohup方式執行請參考:http://blog.csdn.net/msdnchina/article/details/46333375
此時,extract會在/u02/ggs/dirdat/下如下的文件:
[oracle@lei1 dirdat]$ pwd /u02/ggs/dirdat [oracle@lei1 dirdat]$ ls -lrt pp* | wc -l 424 [oracle@lei1 dirdat]$
等待extract完成(可以從/u02/ggs/dirrpt/EXTFTOR.rpt中判斷):
---------------------------------------以上省略------------------------------------------- 2015-06-02 01:35:10 INFO OGG-01026 Rolling over remote file /u02/ggs/dirdat/pp000422. 2015-06-02 01:35:22 INFO OGG-01026 Rolling over remote file /u02/ggs/dirdat/pp000423. *********************************************************************** * ** Run Time Statistics ** * *********************************************************************** Report at 2015-06-02 01:35:32 (activity since 2015-06-02 00:02:59) Output to /u02/ggs/dirdat/pp: From Table TEST.XXXX: # inserts: 3005 --------->抽取了3005條記錄 # updates: 0 # deletes: 0 # discards: 0 REDO Log Statistics Bytes parsed 0 Bytes output 43269697047 --->此處是該rpt文件的終點。
五、從操作系統命令行發起repftor(注意:此種repftor,ggsci的info all是看不到的)
[oracle@lei1 ggs]$ cd /u02/ggs [oracle@lei1 ggs]$ pwd /u02/ggs [oracle@lei1 ggs]$replicat paramfile /u02/ggs/dirprm/repftor.prm reportfile /u02/ggs/dirrpt/REPFTOR.rpt ---->請務必確保發起上面replicat的securecrt不中斷!建議在vncserver或者以nohup方式執行此replicat。 nohup方式執行請參考:http://blog.csdn.net/msdnchina/article/details/46333375
等待replicat完成(可以從/u02/ggs/dirrpt/REPFTOR.rpt中判斷):
---------------------------------------以上省略------------------------------------------- Switching to next trail file /u02/ggs/dirdat/pp000422 at 2015-06-02 04:48:11 due to EOF, with current RBA 98987715 Opened trail file /u02/ggs/dirdat/pp000422 at 2015-06-02 04:48:11 Switching to next trail file /u02/ggs/dirdat/pp000423 at 2015-06-02 04:48:39 due to EOF, with current RBA 97717950 Opened trail file /u02/ggs/dirdat/pp000423 at 2015-06-02 04:48:39 *********************************************************************** * ** Run Time Statistics ** * *********************************************************************** Last record for the last committed transaction is the following: ___________________________________________________________________ Trail name : /u02/ggs/dirdat/pp000423 Hdr-Ind : E (x45) Partition : . (x04) UndoFlag : . (x00) BeforeAfter: A (x41) RecLength : 83 (x0053) IO Time : 2015-06-02 00:03:04.183247 IOType : 5 (x05) OrigNode : 255 (xff) TransInd : . (x03) FormatType : R (x52) SyskeyLen : 0 (x00) Incomplete : . (x00) AuditRBA : 0 AuditPos : 0 Continued : Y (x01) RecCount : 1 (x01) 2015-06-02 00:03:04.183247 Insert Len 83 RBA 82048951 Name: TEST.XXXX ___________________________________________________________________ Reading /u02/ggs/dirdat/pp000423, current RBA 96448185, 3005 records Report at 2015-06-02 04:48:52 (activity since 2015-06-02 03:03:36) From Table TEST.XXXX to TESTHVR.XXXX: # inserts: 3005 --------->插入了3005條記錄 # updates: 0 # deletes: 0 # discards: 0 Last log location read: FILE: /u02/ggs/dirdat/pp000423 SEQNO: 423 RBA: 96448185 TIMESTAMP: 2015-06-02 00:03:04.183247 EOF: NO READERR: 400 CACHE OBJECT MANAGER statistics CACHE MANAGER VM USAGE vm current = 23.82M vm anon queues = 23.82M vm anon in use = 0 vm file = 0 vm used max = 23.82M ==> CACHE BALANCED CACHE CONFIGURATION cache size = 512M cache force paging = 881M buffer min = 64K buffer highwater = 4M pageout eligible size = 4M ================================================================================ RUNTIME STATS FOR SUPERPOOL CACHE Transaction Stats trans active = 0 max concurrent = 3 non-zero total = 8.81K trans total = 8.81K CACHE File Caching disk current = 0 disk total = 0 disk caching = 0 file cached = 0 file retrieves = 0 CACHE MANAGEMENT buffer links = 52.83K anon gets = 0 forced unmaps = 0 cnnbl try = 0 cached out = 0 force out = 0 Allocation Request Distribution < 128B: 0 128B: 0 0 | 512B: 2.94K 5.87K 2K: 19.79M 0 | 8K: 0 0 32K: 0 0 | 128K: 0 0 512K: 0 0 | 2M: 0 0 8M: 0 0 | 32M: 0 0 128M: 0 0 | 512M: 0 0 2G: 0 0 | 8G: 0 Cached Transaction Size Distribution 0: 0 < 4K: 0 4K: 0 0 | 16K: 0 0 64K: 0 0 | 256K: 0 0 1M: 0 0 | 4M: 8.81K 0 16M: 0 0 | 64M: 0 0 256M: 0 0 | 1G: 0 0 4G: 0 0 | 16G: 0 0 64G: 0 0 | 256G: 0 0 1T: 0 0 | 4T: 0 0 16T: 0 0 | 64T: 0 0 256T: 0 0 |1024T: 0 0 ================================================================================ CUMULATIVE STATS FOR SUPERPOOL CACHE Transaction Stats trans active = 0 max concurrent = 0 non-zero total = 0 trans total = 0 CACHE File Caching disk current = 0 disk total = 0 disk caching = 0 file cached = 0 file retrieves = 0 CACHE MANAGEMENT buffer links = 0 anon gets = 0 forced unmaps = 0 cnnbl try = 0 cached out = 0 force out = 0 Allocation Request Distribution < 128B: 0 128B: 0 0 | 512B: 0 0 2K: 0 0 | 8K: 0 0 32K: 0 0 | 128K: 0 0 512K: 0 0 | 2M: 0 0 8M: 0 0 | 32M: 0 0 128M: 0 0 | 512M: 0 0 2G: 0 0 | 8G: 0 Cached Transaction Size Distribution 0: 0 < 4K: 0 4K: 0 0 | 16K: 0 0 64K: 0 0 | 256K: 0 0 1M: 0 0 | 4M: 0 0 16M: 0 0 | 64M: 0 0 256M: 0 0 | 1G: 0 0 4G: 0 0 | 16G: 0 0 64G: 0 0 | 256G: 0 0 1T: 0 0 | 4T: 0 0 16T: 0 0 | 64T: 0 0 256T: 0 0 |1024T: 0 0 QUEUE Statistics: num queues = 15 default index = 0 cur len = 0 max len = 0 q vm current = 0 vm max = 0 q hits = 61.61K q misses = 21 queue size q hits curlen maxlen cannibalized 0 64K 8.81K 3 3 0 1 128K 8.81K 3 3 0 2 256K 8.81K 3 3 0 3 512K 8.81K 3 3 0 4 1M 8.81K 3 3 0 5 2M 8.81K 3 3 0 6 4M 8.81K 3 3 0 7 8M 0 0 0 0 8 16M 0 0 0 0 9 32M 0 0 0 0 10 64M 0 0 0 0 11 128M 0 0 0 0 12 256M 0 0 0 0 13 512M 0 0 0 0 14 1G 0 0 0 0 ================================================================================ RUNTIME STATS FOR CACHE POOL #0 POOL INFO group: repftor id: p22586_BLOB trans active = 0 trans concurrent (max) = 3 trans total = 8.81K (9015 ) flag = 0x00000030 last error = (0=) Allocation Request Distribution < 128B: 0 128B: 0 0 | 512B: 2.94K 5.87K 2K: 19.79M 0 | 8K: 0 0 32K: 0 0 | 128K: 0 0 512K: 0 0 | 2M: 0 0 8M: 0 0 | 32M: 0 0 128M: 0 0 | 512M: 0 0 2G: 0 0 | 8G: 0 ================================================================================ CUMULATIVE STATS FOR CACHE POOL #0 POOL INFO group: repftor id: p22586_BLOB trans active = 0 trans concurrent (max) = 0 trans total = 0 (0 ) flag = 0x00000030 last error = (0= ) Allocation Request Distribution < 128B: 0 128B: 0 0 | 512B: 0 0 2K: 0 0 | 8K: 0 0 32K: 0 0 | 128K: 0 0 512K: 0 0 | 2M: 0 0 8M: 0 0 | 32M: 0 0 128M: 0 0 | 512M: 0 0 2G: 0 0 | 8G: 0 QUEUE Statistics: num queues = 15 default index = 0 cur len = 0 max len = 0 q vm current = 0 vm max = 0 q hits = 61.61K q misses = 21 queue size q hits curlen maxlen cannibalized 0 64K 8.81K 3 3 0 1 128K 8.81K 3 3 0 2 256K 8.81K 3 3 0 3 512K 8.81K 3 3 0 4 1M 8.81K 3 3 0 5 2M 8.81K 3 3 0 6 4M 8.81K 3 3 0 7 8M 0 0 0 0 8 16M 0 0 0 0 9 32M 0 0 0 0 10 64M 0 0 0 0 11 128M 0 0 0 0 12 256M 0 0 0 0 13 512M 0 0 0 0 14 1G 0 0 0 0 ================================================================================ RUNTIME STATS FOR CACHE POOL #0 POOL INFO group: repftor id: p22586_BLOB trans active = 0 trans concurrent (max) = 3 trans total = 8.81K (9015 ) flag = 0x00000030 last error = (0= ) Allocation Request Distribution < 128B: 0 128B: 0 0 | 512B: 2.94K 5.87K 2K: 19.79M 0 | 8K: 0 0 32K: 0 0 | 128K: 0 0 512K: 0 0 | 2M: 0 0 8M: 0 0 | 32M: 0 0 128M: 0 0 | 512M: 0 0 2G: 0 0 | 8G: 0 ================================================================================ CUMULATIVE STATS FOR CACHE POOL #0 POOL INFO group: repftor id: p22586_BLOB trans active = 0 trans concurrent (max) = 0 trans total = 0 (0 ) flag = 0x00000030 last error = (0= ) Allocation Request Distribution < 128B: 0 128B: 0 0 | 512B: 0 0 2K: 0 0 | 8K: 0 0 32K: 0 0 | 128K: 0 0 512K: 0 0 | 2M: 0 0 8M: 0 0 | 32M: 0 0 128M: 0 0 | 512M: 0 0 2G: 0 0 | 8G: 0 --->此處是該rpt文件的終點。