OGG & quot; Loading data from file to Replicat & quot; static synchronization configuration process of table data, loadingreplicat

Static synchronization configuration process of OGG "Loading data from file to Replicat" table data, loadingreplicat

Static synchronization configuration process of OGG "Loading data from file to Replicat" table data

1. mgr Process

GGSCI (lei1) 3> view params mgrport 7809

 

Ii. Extraction Process 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;

 

3. Extraction Process repftor

GGSCI (lei1) 5> view params repftorSPECIALRUNEND RUNTIMEuserid goldengate, password yyyyextfile /u02/ggs/dirdat/ppASSUMETARGETDEFSmap test.xxx target testhvr.xxxx;

4. Initiate extract from the command line of the Operating System (note: the info of ggsci is invisible to this extract)

[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 ----> make sure that the securecrt that initiates the extract is not interrupted! We recommend that you execute this extract on vncserver or nohup. Nohup method execution see: http://blog.csdn.net/msdnchina/article/details/46333375

 

In this case, extract will file the following in/u02/ggs/dirdat:

[oracle@lei1 dirdat]$ pwd/u02/ggs/dirdat[oracle@lei1 dirdat]$ ls -lrt pp* | wc -l424[oracle@lei1 dirdat]$ 

Wait until the extract is completed (you can judge from/u02/ggs/dirrpt/EXTFTOR. rpt ):

Earlier omitted later than 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 01:35:32 (activity since 00:02:59) output to/u02/ggs/dirdat/pp: From Table TEST. XXXX: # inserts: 3005 ---------> 3005 records are extracted # updates: 0 # deletes: 0 # discards: 0 REDO Log Statistics Bytes parsed 0 Bytes output 43269697047 ---> This is the end point of the rpt file.

5. Initiate a repftor from the operating system command line (note: the info of ggsci is invisible to this repftor)

[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 ----> make sure that the securecrt that initiates the replicat above is not interrupted! We recommend that you run this replicat on vncserver or nohup. Nohup method execution see: http://blog.csdn.net/msdnchina/article/details/46333375

Wait until replicat is completed (you can judge from/u02/ggs/dirrpt/REPFTOR. rpt ):

------------------------------------- The preceding rule Switching to next trail file/u02/ggs/dirdat/pp000422 at 04:48:11 due to EOF, with current RBA 98987715 Opened trail file/u02/ggs/dirdat/pp000422 at 04: 48: 11 Switching to next trail file/u02/ggs/dirdat/pp000423 at 04:48:39 due to EOF, with current RBA 97717950 Opened trail file/u0 2/ggs/dirdat/pp000423 at 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: 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) 00:03:04. 183247 Insert Len 83 RBA 82048951 Name: TEST. XXXX _______________________________ ____________________________________ Reading/u02/ggs/dirdat/pp000423, current RBA 96448185,300 5 recordsReport at 04:48:52 (activity since 03:03:36) From Table TEST. XXXX to TESTHVR. XXXX: # inserts: 3005 ---------> 3005 records inserted # updates: 0 # deletes: 0 # discards: 0 Last log location read: FILE: /u02/ggs/dirdat/pp000423 SEQNO: 423 RBA: 96448185 TIMESTAMP: 00:03:04. 18324 7 EOF: no readerr: 400 cache object manager statisticsCACHE manager vm USAGEvm current = 23.82 M vm anon queues = 23.82Mvm anon in use = 0 vm file = 0 vm used max = 23.82 M => cache balancedcache CONFIGURATIONcache size = 512 M cache force paging = 881 Mbuffer min = 64 K buffer highwater = 4 Mpageout eligible size = 4 M ================ ========================================================== =================================== RUNTIM E stats for superpoolcache Transaction Statstrans active = 0 max concurrent = 3 non-zero total = 8.81 K trans total = 8.81 KCACHE File Cachingdisk current = 0 disk total = 0 disk caching = 0 file cached = 0 file retrieves = 0 CACHE MANAGEMENTbuffer links = 52.83 K anon gets = 0 forced unmaps = 0 cnnbl try = 0 cached out = 0 force out = 0 Allocation Request Distribution <B: 0 128B: 0 0 | 512B: 2.94 K 5.87 K 2 K: 19.79 M 0 | 8 K: 0 32 K: 0 0 | 128 K: 0 0 512 K: 0 0 | 2 M: 0 0 8 M: 0 0 | 32 M: 0 0 128 M: 0 0 | 512 M: 0 0 2G: 0 0 0 | 8G: 0 Cached Transaction Size Distribution 0: 0 <4 K: 0 4 K: 0 0 | 16 K: 0 64 K: 0 0 | 256 K: 0 0 1 M: 0 0 | 4 M: 8.81 K 0 16 M: 0 0 | 64 M: 0 0 256 M: 0 0 | 1G: 0 0 4G: 0 0 0 | 16G: 0 0 64G: 0 0 0 | 256G: 0 0 1 T: 0 0 | 4 T: 0 16 T: 0 0 | 64 T: 0 0 256 T: 0 0 | 1024 T: 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 Alloc Ation Request Distribution <128B: 0 128B: 0 0 | 512B: 0 0 2 K: 0 0 | 8 K: 0 0 32 K: 0 0 0 | 128 K: 0 0 512 K: 0 0 | 2 M: 0 0 8 M: 0 0 | 32 M: 0 0 128 M: 0 0 | 512 M: 0 0 2G: 0 0 | 8G: 0 Cached Transaction Size Distribution 0: 0 <4 K: 0 4 K: 0 0 | 16 K: 0 0 64 K: 0 0 0 | 256 K: 0 0 1 M: 0 0 | 4 M: 0 0 16 M: 0 0 | 64 M: 0 0 256 M: 0 0 | 1G: 0 0 4G: 0 0 | 16G: 0 0 64G: 0 0 | 256G: 0 0 1 T: 0 0 0 | 4 T: 0 0 16 T: 0 0 0 | 64 T: 0 0 256 T: 0 0 | 1024 T: 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.61 K q misses = 21 queue size q hits curlen maxlen cannibalized 0 64 K 8.81 K 3 3 0 1 128 K 8.81 K 3 3 0 2 256 K 8.81 K 3 3 0 3 512 K 8.81 K 3 3 0 4 1 M 8.81 K 3 3 0 5 2 M 8.81 K 3 3 0 6 4 M 8.81 K 3 3 0 7 8 M 0 0 0 8 16 M 0 0 0 0 9 32 M 0 0 0 0 10 64 M 0 0 0 0 11 128 M 0 0 0 12 256 M 0 0 0 13 512 M 0 0 0 14 1G 0 0 0 0 0 ====================== ========================================================== ============================ runtime stats for cache pool #0 pool info group: repftor id: p22586_BLOBtrans active = 0 trans concurrent (max) = 3 trans total = 8.81 K (9015) flag = 0x00000030last error = (0 = <none>) Allocation Request Distribution <128B: 0 128B: 0 0 | 512B: 2.94 K 5.87 K 2 K: 19.79 M 0 | 8 K: 0 0 32 K: 0 0 | 128 K: 0 0 512 K: 0 0 | 2 M: 0 0 8 M: 0 0 | 32 M: 0 0 128 M: 0 0 | 512 M: 0 0 2G: 0 0 | 8G: 0 =================================================== ========================================================== = cumulative stats for cache pool #0 pool 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 128 B: 0 0 | 512B: 0 0 2 K: 0 0 | 8 K: 0 32 K: 0 0 | 128 K: 0 0 512 K: 0 0 | 2 M: 0 0 8 M: 0 0 | 32 M: 0 0 128 M: 0 0 | 512 M: 0 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.61 K q misses = 21 queue size q hits curlen maxlen cannibalized 0 64 K 8.81 K 3 3 0 1 128 K 8.81 K 3 3 0 2 256 K 8.81 K 3 3 0 3 512 K 8.81 K 3 3 0 4 1 M 8.81 K 3 3 0 5 2 M 8.81 K 3 3 0 6 4 M 8.81 K 3 3 0 7 8 M 0 0 0 8 16 M 0 0 0 0 9 32 M 0 0 0 0 10 64 M 0 0 0 11 128 M 0 0 0 12 256 M 0 0 0 0 13 512 M 0 0 0 0 14 1G 0 0 0 0 = ========================================================== ====================================== runtime stats for cache pool #0 pool info group: repftor id: p22586_BLOBtrans active = 0 trans concurrent (max) = 3 trans total = 8.81 K (9015) flag = 0x00000030last Error = (0 = <none>) Allocation Request Distribution <128B: 0 128B: 0 0 | 512B: 2.94 K 5.87 K 2 K: 19.79 M 0 | 8 K: 0 0 32 K: 0 0 | 128 K: 0 0 512 K: 0 0 | 2 M: 0 0 8 M: 0 0 | 32 M: 0 0 128 M: 0 0 | 512 M: 0 0 2G: 0 0 | 8G: 0 =================================================== ========================================================== = cumulative stats for cache pool #0 pool 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 2 K: 0 0 | 8 K: 0 32 K: 0 0 | 128 K: 0 0 512 K: 0 0 | 2 M: 0 0 8 M: 0 0 | 32 M: 0 0 128 M: 0 0 | 512 M: 0 0 2G: 0 0 | 8G: 0 ---> This is the end point of the rpt file.