OGG " Loading data from the file to replicat"table static synchronization configuration process

OGG "Loading data from File to Replicat" table static synchronization configuration process

One, Mgr Process

Ggsci (LEI1) 3> view params mgrport 7809

Second, the extraction process Extftor

Ggsci (LEI1) 4> view params extftorsourceistableuserid goldengate, password yyyyyrmthost 192.168.100.189, Mgrport 7809 RMTFILE/U02/GGS/DIRDAT/PP, Maxfiles, megabytes 100table test.xxx;

Third, the replication process Repftor

Ggsci (LEI1) 5> view params repftorspecialrunend runtimeuserid goldengate, password yyyyexttrail/u02/ggs/dirdat/ Ppassumetargetdefsmap test.xxx Target testhvr.xxxx;

Please note:

The above is Exttrail (not extfile), Exttrail is used in conjunction with the maxfiles and megabytes of the extraction process, and, in layman's terms, Exttrail is the corresponding/u02/ggs/dirdat/pp000000. /u02/ggs/dirdat/pp000001,/u02/ggs/dirdat/pp000002. /u02/ggs/dirdat/pp000003 and so on.

and Extfile, the corresponding is/U02/GGS/DIRDAT/PP

Iv. initiating extract from the operating system command line (note: This kind of extract,ggsci info all is not visible)

[[email protected] ggs]$ cd/u02/ggs[[email protected] ggs]$ Pwd/u02/ggs[[email protected] ggs]$ extract Paramfile/u02/gg S/DIRPRM/EXTFTOR.PRM reportfile/u02/ggs/dirrpt/extftor.rpt----> Be sure to initiate the securecrt of the above extract without interruption!
It is recommended to run this extract in Vncserver or Nohup mode.
Nohup mode operation please refer to: http://blog.csdn.net/msdnchina/article/details/46333375

At this point, extract will be under/u02/ggs/dirdat/for example the following files:

Wait for extract to complete (can be inferred from/U02/GGS/DIRRPT/EXTFTOR.RPT):

---------------------------------------above omitted------------------------------------------- 2015-06-02 01:35:10 info OGG-01026 rolling over remote file/u02/ggs/dirdat/pp000422.2015-06-02 01:35:22 INFO OG G-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---------> extracted 3,005 Records # updates:0 # deletes:0 # Discards:0redo Log Statistics Bytes Parse D 0 Bytes Output 43269697047---> Here is the end point of the RPT file. 
 
 
 
 

V. Launch Repftor from the operating system command line (note: This type of Repftor,ggsci info all is not visible)

[[email protected] ggs]$ cd/u02/ggs[[email protected] ggs]$ Pwd/u02/ggs[[email protected] GGs] $replicat paramfile/u02/g GS/DIRPRM/REPFTOR.PRM reportfile/u02/ggs/dirrpt/repftor.rpt----> Be sure to initiate the securecrt of the above replicat without interruption! It is recommended to run this replicat in Vncserver or Nohup mode. Nohup mode operation please refer to: http://blog.csdn.net/msdnchina/article/details/46333375

Wait for Replicat to complete (can be inferred from/U02/GGS/DIRRPT/REPFTOR.RPT):

---------------------------------------above omitted-------------------------------------------switching to next trail file /u02/ggs/dirdat/pp000422 at 2015-06-02 04:48:11 due-EOF, with current RBA 98987715Opened Trail File/u02/ggs/dirdat/pp0 00422 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.183 247 Insert Len 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---------> inserted 3,005 Records # 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 VMS anon queues = 23.82MVM anon in use = 0 VM fil  E = 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 li      nks = 52.83K Anon gets = 0 forced unmaps = 0 CNNBL try = 0 Cached out = 0 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 di   SK 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 D istribution< 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 = 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.81   K 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 64M 0       0 0 0 128M 0 0 0 0 256M 0 0 0 0 512M 0 0 0 0 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 PO       OL #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 = default index = 0 cur len = 0 Max len = 0 q vm current = 0 VM max = 0 Q hits = 61.61K Q misses =      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 64M 0       0 0 0 128M 0 0 0 0 256M 0 0 0 0 512M 0 0 0 0 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 distr ibution< 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 PO       OL #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---> Here is the end of the RPT file.

Copyright notice: This article blog original articles, blogs, without consent, may not be reproduced.

OGG " Loading data from the file to replicat"table static synchronization configuration process