GoldentGateOracletoOracle初始化详解 - 数据库编程

E vm current = 0 vm anon queues = 0 vm anon in use = 0 vm file = 0 vm used max = 0 ==> CACHE BALANCED CACHE CONFIGURATION cache size = 512M cache force paging = 881M buffer min = 64K buffer highwater = 4M pageout eligible size = 4M 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 = 0 q misses = 0 queue size q hits curlen maxlen cannibalized 0 64K 0 0 0 0 1 128K 0 0 0 0 2 256K 0 0 0 0 3 512K 0 0 0 0 4 1M 0 0 0 0 5 2M 0 0 0 0 6 4M 0 0 0 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 ================================================================================ CACHE POOL #0 POOL INFO group: rinikk id: p3888_BLOB trans active = 0 trans concurrent (max) = 0 trans total = 0 (0 ) flag = 0x00000000 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 = 0 q misses = 0 queue size q hits curlen maxlen cannibalized 0 64K 0 0 0 0 1 128K 0 0 0 0 2 256K 0 0 0 0 3 512K 0 0 0 0 4 1M 0 0 0 0 5 2M 0 0 0 0 6 4M 0 0 0 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 ================================================================================ CACHE POOL #0 POOL INFO group: rinikk id: p3888_BLOB trans active = 0 trans concurrent (max) = 0 trans total = 0 (0 ) flag = 0x00000000 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
六、验证初始化是否成功

    23、在目标端查看表信息是否进来了,我们可以看到表数据已经传输过来了。
    SQL> select * from tcustmer;

    CUST NAME CITY ST
    ---- ------------------------------ -------------------- --
    WILL BG SOFTWARE CO. SEATTLE WA
    JANE ROCKY FLYER INC. DENVER CO

    SQL> select * from tcustord;

    CUST ORDER_DAT PRODUCT_ ORDER_ID PRODUCT_PRICE PRODUCT_AMOUNT TRANSACTION_ID
    ---- --------- -------- ---------- ------------- -------------- --------------
    WILL 30-SEP-94 CAR 144 17520 3 100
    JANE 11-NOV-95 PLANE 256 133300 1 100

七、配置实时同步

    24、在源端添加抓取进程
    GGSCI (source) 39> add extract eorakk, tranlog, begin now, threads 1
    EXTRACT added.


    GGSCI (source) 40> info extract * --查看抓取进程信息

    EXTRACT EORAKK Initialized 2014-09-04 14:26 Status STOPPED
    Checkpoint Lag 00:00:00 (updated 00:00:06 ago)
    Log Read Checkpoint Oracle Redo Logs
                         2014-09-04 14:26:51 Thread 1, Seqno 0, RBA 0

    GGSCI (source) 41> edit params eorakk ---编辑抓取进程参数
    EXTRACT EORAKK
    USERID system, PASSWORD oracle
    RMTHOST 192.168.7.21, MGRPORT 7809
    RMTTRAIL ./dirdat/kk
    TABLE ggs.TCUSTMER;
    TABLE ggs.TCUSTORD;

    GGSCI (source) 42> ADD RMTTRAIL ./dirdat/kk, EXTRACT EORAKK, MEGABYTES 5 ---添加TRAIL
    RMTTRAIL added.

    GGSCI (source) 43> info rmttrail *

           Extract Trail: ./dirdat/kk
                 Extract: EORAKK
                   Seqno: 0
                     RBA: 0
               File Size: 5M

    GGSCI (source) 44> start extract eorakk ---启动TRAIL

    Sending START request to MANAGER ...
    EXTRACT EORAKK starting


    GGSCI (source) 45> info all

    Program Status Group Lag Time Since Chkpt

    MANAGER RUNNING
    EXTRACT RUNNING EORAKK 00:00:00 00:08:57


    GGSCI (source) 46> info extract eorakk, detail

    EXTRACT EORAKK Last Started 2014-09-04 14:35 Status RUNNING
    Checkpoint Lag 00:00:00 (updated 00:00:09 ago)
    Log Read Checkpoint Oracle Redo Logs
                         2014-09-04 14:35:50 Thread 1, Seqno 23, RBA 10829824

      Target Extract Trails:

      Remote Trail Name Seqno RBA Max MB

      ./dirdat/kk 0 921 5

      Extract Source Begin End

      /DBData/woo/redo02.log 2014-09-04 14:26 2014-09-04 14:35
      Not Available * Initialized * 2014-09-04 14:26


    Current directory /DBSoft/ogg

    Report file /DBSoft/ogg/dirrpt/EORAKK.rpt
    Parameter file /DBSoft/ogg/dirprm/eorakk.prm
    Checkpoint file /DBSoft/ogg/dirchk/EORAKK.cpe
    Process file /DBSoft/ogg/dirpcs/EORAKK.pce
    Stdout file /DBSoft/ogg/dirout/EORAKK.out
    Error log /DBSoft/ogg/ggserr.log


    GGSCI (source) 47> view report eorakk


    ***********************************************************************
                     Oracle GoldenGate Capture for Oracle
                         Version 11.1.1.0.0 Build 078
       Linux, x64, 64bit (optimized), Oracle 11 on Jul 28 2010 14:58:37
     
    Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.


                        Starting at 2014-09-04 14:35:44
    ***********************************************************************

    Operating System Version:
    Linux
    Version #1 SMP Fri Jan 27 17:17:51 EST 201

GoldentGateOracletoOracle初始化详解(三)