OGG "Loading data from file to Replicat"table資料的靜態同步配置過程，loadingreplicat

OGG "Loading data from file to Replicat"table資料的靜態同步配置過程，loadingreplicat

OGG "Loading data from file to Replicat"table資料的靜態同步配置過程

一、mgr進程

GGSCI (lei1) 3> view params mgrport 7809

 

二、抽取進程extftor

GGSCI (lei1) 4> view params extftorSOURCEISTABLEuserid goldengate, password yyyyyrmthost 192.168.100.189, mgrport 7809RMTFILE /u02/ggs/dirdat/pp, MAXFILES 1000, MEGABYTES 100table test.xxx;

 

三、抽取進程repftor

GGSCI (lei1) 5> view params repftorSPECIALRUNEND RUNTIMEuserid goldengate, password yyyyextfile /u02/ggs/dirdat/ppASSUMETARGETDEFSmap 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 -l424[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:         0REDO 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 98987715Opened trail file /u02/ggs/dirdat/pp000422 at 2015-06-02 04:48:11Switching to next trail file /u02/ggs/dirdat/pp000423 at 2015-06-02 04:48:39 due to EOF, with current RBA 97717950Opened 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/pp000423Hdr-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   : 0Continued  :     Y  (x01)     RecCount   :     1  (x01)2015-06-02 00:03:04.183247 Insert             Len    83 RBA 82048951Name: TEST.XXXX___________________________________________________________________Reading /u02/ggs/dirdat/pp000423, current RBA 96448185, 3005 recordsReport 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:         0Last log location read:     FILE:      /u02/ggs/dirdat/pp000423     SEQNO:     423     RBA:       96448185     TIMESTAMP: 2015-06-02 00:03:04.183247     EOF:       NO     READERR:   400CACHE OBJECT MANAGER statisticsCACHE MANAGER VM USAGEvm current     =  23.82M   vm anon queues =  23.82Mvm anon in use =      0    vm file        =      0 vm used max    =  23.82M   ==> CACHE BALANCEDCACHE CONFIGURATIONcache size       = 512M   cache force paging = 881Mbuffer min       =  64K   buffer highwater   =   4Mpageout eligible size =   4M================================================================================RUNTIME STATS FOR SUPERPOOLCACHE Transaction Statstrans active   =      0    max concurrent =      3 non-zero total =   8.81K   trans total    =   8.81KCACHE File Cachingdisk current   =      0    disk total  =      0 disk caching   =      0    file cached =      0 file retrieves =      0 CACHE MANAGEMENTbuffer 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 SUPERPOOLCACHE Transaction Statstrans active   =      0    max concurrent =      0 non-zero total =      0    trans total    =      0 CACHE File Cachingdisk current   =      0    disk total  =      0 disk caching   =      0    file cached =      0 file retrieves =      0 CACHE MANAGEMENTbuffer 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 #0POOL INFO   group: repftor  id: p22586_BLOBtrans active  =       0   trans concurrent (max) =     3 trans total   =    8.81K  (9015 )flag          = 0x00000030last error    = (0=<none>)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 #0POOL INFO   group: repftor  id: p22586_BLOBtrans active  =       0   trans concurrent (max) =     0 trans total   =       0   (0 )flag          = 0x00000030last error    = (0=<none>)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 #0POOL INFO   group: repftor  id: p22586_BLOBtrans active  =       0   trans concurrent (max) =     3 trans total   =    8.81K  (9015 )flag          = 0x00000030last error    = (0=<none>)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 #0POOL INFO   group: repftor  id: p22586_BLOBtrans active  =       0   trans concurrent (max) =     0 trans total   =       0   (0 )flag          = 0x00000030last error    = (0=<none>)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檔案的終點。