程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> SyBase數據庫 >> SyBase教程 >> OGG "Loading data from file to Replicat"table數據的靜態同步配置過程

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

編輯:SyBase教程

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


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文件的終點。

 

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved