GoldentGate Oracle to Oracle 初始化詳解

dbhelper發表於2014-12-03
GoOracle
一、安裝GoldenGate[源端，目標端]
  1. 1、建立ogg目錄
  2. [root@source ~]# mkdir /DBSoft/ogg
  3. [root@source ~]# cd /DBSoft/ogg/

  5. 2、解壓縮ogg安裝介質
  6. [root@source ogg]# unzip /root/OGG_v11_for_ora11g_linux64.zip
  7. Archive: /root/OGG_v11_for_ora11g_linux64.zip
  8.   inflating: ggs_Linux_x64_ora11g_64bit_v11_1_1_0_0_078.tar
  9.   inflating: OGG_WinUnix_Rel_Notes_11.1.1.0.0_078.pdf
  10.   inflating: README.txt

  12. 3、可以看到介質包含一個tar包，pdf檔案以及一個readme
  13. [root@source ogg]# ll
  14. total 201016
  15. -rw-rw---- 1 root root 205096960 Jul 29 2010 ggs_Linux_x64_ora11g_64bit_v11_1_1_0_0_078.tar
  16. -rwxrwxr-x 1 root root 500964 Aug 6 2010 OGG_WinUnix_Rel_Notes_11.1.1.0.0_078.pdf
  17. -rwxrwxr-x 1 root root 26726 Aug 3 2010 README.txt

  19. 4、修改ogg目錄所屬組為oinstall及所屬使用者為oracle
  20. [root@source ogg]# cd ..
  21. [root@source DBSoft]# ll
  22. total 32
  23. drwxr-x--- 3 oracle oinstall 4096 Sep 2 22:40 admin
  24. drwxr-xr-x 6 oracle oinstall 4096 Sep 2 22:44 cfgtoollogs
  25. drwxr-xr-x 3 oracle oinstall 4096 Sep 2 22:38 checkpoints
  26. drwxrwxr-x 11 oracle oinstall 4096 Sep 2 22:39 diag
  27. drwxr-x--- 4 oracle oinstall 4096 Sep 2 22:41 fast_recovery_area
  28. drwxr-xr-x 2 oracle oinstall 4096 Sep 3 10:27 ogg
  29. drwxrwx--- 5 oracle oinstall 4096 Sep 2 22:39 oraInventory
  30. drwxr-xr-x 3 oracle oinstall 4096 Sep 2 22:32 product

  32. [root@source DBSoft]# chown -R oracle:oinstall ogg/
  33. [root@source DBSoft]# su - oracle

  35. 5、再次進入ogg目錄，解壓縮ogg主程式檔案
  36. [oracle@source ~]$ cd /DBSoft/ogg/
  37. [oracle@source ogg]$ ll
  38. total 201016
  39. -rw-rw---- 1 oracle oinstall 205096960 Jul 29 2010 ggs_Linux_x64_ora11g_64bit_v11_1_1_0_0_078.tar
  40. -rwxrwxr-x 1 oracle oinstall 500964 Aug 6 2010 OGG_WinUnix_Rel_Notes_11.1.1.0.0_078.pdf
  41. -rwxrwxr-x 1 oracle oinstall 26726 Aug 3 2010 README.txt

  43. #正在解壓縮
  44. [oracle@source ogg]$ tar -xvf ggs_Linux_x64_ora11g_64bit_v11_1_1_0_0_078.tar
  45. bcpfmt.tpl
  46. bcrypt.txt
  47. chkpt_ora_create.sql
  48. cobgen
  49. convchk
  50. db2cntl.tpl
  51. ddl_access.tpl
  52. ddl_cleartrace.sql
  53. ddlcob
  54. ddl_db2_os390.tpl
  55. ddl_db2.tpl
  56. ddl_ddl2file.sql
  57. ddl_disable.sql
  58. ddl_enable.sql
  59. ddlgen
  60. ddl_informix.tpl
  61. ddl_mss.tpl
  62. ddl_mysql.tpl
  63. ddl_nopurgeRecyclebin.sql
  64. ddl_nssql.tpl
  65. ddl_ora10.sql
  66. ddl_ora10upCommon.sql
  67. ddl_ora11.sql
  68. ddl_ora9.sql
  69. ddl_oracle.tpl
  70. ddl_pin.sql
  71. ddl_purgeRecyclebin.sql
  72. ddl_remove.sql
  73. ddl_session1.sql
  74. ddl_session.sql
  75. ddl_setup.sql
  76. ddl_sqlmx.tpl
  77. ddl_status.sql
  78. ddl_staymetadata_off.sql
  79. ddl_staymetadata_on.sql
  80. ddl_sybase.tpl
  81. ddl_tandem.tpl
  82. ddl_tracelevel.sql
  83. ddl_trace_off.sql
  84. ddl_trace_on.sql
  85. defgen
  86. demo_more_ora_create.sql
  87. demo_more_ora_insert.sql
  88. demo_ora_create.sql
  89. demo_ora_insert.sql
  90. demo_ora_lob_create.sql
  91. demo_ora_misc.sql
  92. demo_ora_pk_befores_create.sql
  93. demo_ora_pk_befores_insert.sql
  94. demo_ora_pk_befores_updates.sql
  95. emsclnt
  96. extract
  97. freeBSD.txt
  98. ggMessage.dat
  99. ggsci
  100. help.txt
  101. keygen
  102. libicudata.so.38
  103. libicui18n.so.38
  104. libicuuc.so.38
  105. libxerces-c.so.28
  106. libxml2.txt
  107. logdump
  108. marker_remove.sql
  109. marker_setup.sql
  110. marker_status.sql
  111. mgr
  112. notices.txt
  113. params.sql
  114. replicat
  115. reverse
  116. role_setup.sql
  117. server
  118. sqlldr.tpl
  119. tcperrs
  120. UserExitExamples/
  121. UserExitExamples/ExitDemo_lobs/
  122. UserExitExamples/ExitDemo_lobs/Makefile_lob.SOLARIS
  123. UserExitExamples/ExitDemo_lobs/readme.txt
  124. UserExitExamples/ExitDemo_lobs/exitdemo_lob.c
  125. UserExitExamples/ExitDemo_lobs/Makefile_lob.AIX
  126. UserExitExamples/ExitDemo_lobs/Makefile_lob.LINUX
  127. UserExitExamples/ExitDemo_lobs/Makefile_lob.HPUX
  128. UserExitExamples/ExitDemo_lobs/exitdemo_lob.vcproj
  129. UserExitExamples/ExitDemo_passthru/
  130. UserExitExamples/ExitDemo_passthru/Makefile_passthru.AIX
  131. UserExitExamples/ExitDemo_passthru/Makefile_passthru.LINUX
  132. UserExitExamples/ExitDemo_passthru/Makefile_passthru.SOLARIS
  133. UserExitExamples/ExitDemo_passthru/exitdemopassthru.vcproj
  134. UserExitExamples/ExitDemo_passthru/readme.txt
  135. UserExitExamples/ExitDemo_passthru/exitdemo_passthru.c
  136. UserExitExamples/ExitDemo_passthru/Makefile_passthru.HP_OSS
  137. UserExitExamples/ExitDemo_passthru/Makefile_passthru.HPUX
  138. UserExitExamples/ExitDemo_more_recs/
  139. UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.AIX
  140. UserExitExamples/ExitDemo_more_recs/readme.txt
  141. UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.vcproj
  142. UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.SOLARIS
  143. UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.LINUX
  144. UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.HPUX
  145. UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.c
  146. UserExitExamples/ExitDemo/
  147. UserExitExamples/ExitDemo/exitdemo.c
  148. UserExitExamples/ExitDemo/Makefile_exit_demo.HPUX
  149. UserExitExamples/ExitDemo/Makefile_exit_demo.SOLARIS
  150. UserExitExamples/ExitDemo/readme.txt
  151. UserExitExamples/ExitDemo/exitdemo.vcproj
  152. UserExitExamples/ExitDemo/Makefile_exit_demo.HP_OSS
  153. UserExitExamples/ExitDemo/Makefile_exit_demo.LINUX
  154. UserExitExamples/ExitDemo/Makefile_exit_demo.AIX
  155. UserExitExamples/ExitDemo_pk_befores/
  156. UserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.vcproj
  157. UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.HPUX
  158. UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.AIX
  159. UserExitExamples/ExitDemo_pk_befores/readme.txt
  160. UserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.c
  161. UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.LINUX
  162. UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.SOLARIS
  163. usrdecs.h
  164. zlib.txt

  166. 6、解壓縮完之後，執行ggsci命令進入OGG互動介面
  167. [oracle@source ogg]$GGSCI
  168. GGSCI (source) 1>

  170. 7、建立OGG所需目錄
  171. GGSCI (source) 1> create subdirs

  173. Creating subdirectories under current directory /DBSoft/ogg

  175. Parameter files /DBSoft/ogg/dirprm: created
  176. Report files /DBSoft/ogg/dirrpt: created
  177. Checkpoint files /DBSoft/ogg/dirchk: created
  178. Process status files /DBSoft/ogg/dirpcs: created
  179. SQL script files /DBSoft/ogg/dirsql: created
  180. Database definitions files /DBSoft/ogg/dirdef: created
  181. Extract data files /DBSoft/ogg/dirdat: created
  182. Temporary files /DBSoft/ogg/dirtmp: created
  183. Veridata files /DBSoft/ogg/dirver: created
  184. Veridata Lock files /DBSoft/ogg/dirver/lock: created
  185. Veridata Out-Of-Sync files /DBSoft/ogg/dirver/oos: created
  186. Veridata Out-Of-Sync XML files /DBSoft/ogg/dirver/oosxml: created
  187. Veridata Parameter files /DBSoft/ogg/dirver/params: created
  188. Veridata Report files /DBSoft/ogg/dirver/report: created
  189. Veridata Status files /DBSoft/ogg/dirver/status: created
  190. Veridata Trace files /DBSoft/ogg/dirver/trace: created
  191. Stdout files /DBSoft/ogg/dirout: created


  194. GGSCI (source) 2>exit

  196. 8、至此我們可以看到目錄已經建立，OGG安裝初始化完成
  197. [oracle@source ogg]$ ls -ltr dir*
  198. dirver:
  199. total 28
  200. drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 trace
  201. drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 status
  202. drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 report
  203. drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 params
  204. drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 oosxml
  205. drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 oos
  206. drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 lock
二、源庫配置OGG所需環境[源端，目標端]
  1. 9、開啟歸檔和附加資訊到redo logfile
  2. SQL> alter database add supplemental log data; ----開啟附加資訊到redo logfile

  4. Database altered.

  6. SQL> shutdown immediate
  7. Database closed.
  8. Database dismounted.
  9. ORACLE instance shut down.

  11. SQL> startup mount;
  12. ORACLE instance started.

  14. Total System Global Area 2505338880 bytes
  15. Fixed Size 2255832 bytes
  16. Variable Size 620758056 bytes
  17. Database Buffers 1862270976 bytes
  18. Redo Buffers 20054016 bytes
  19. Database mounted.
  20. SQL> alter database archivelog;

  22. Database altered.

  24. SQL> alter database open;

  26. Database altered.


  29. SQL> alter system switch logfile;

  31. System altered.

  33. SQL> /

  35. System altered.

  37. SQL> select SUPPLEMENTAL_LOG_DATA_MIN from v$database;

  39. SUPPLEME
  40. --------
  41. YES


  44. 10、建立OGG測試所需表空間及使用者
  45. SQL> select tablespace_name,contents from dba_tablespaces;

  47. TABLESPACE_NAME CONTENTS
  48. ------------------------------ ---------
  49. SYSTEM PERMANENT
  50. SYSAUX PERMANENT
  51. UNDOTBS1 UNDO
  52. TEMP TEMPORARY
  53. USERS PERMANENT

  55. SQL> select file_name from dba_data_files;

  57. FILE_NAME
  58. --------------------------------------------------------------------------------
  59. /DBData/woo/users01.dbf
  60. /DBData/woo/undotbs01.dbf
  61. /DBData/woo/sysaux01.dbf
  62. /DBData/woo/system01.dbf

  64. SQL> create tablespace ggs datafile \
三、透過剛才建立的使用者建立ogg所需的demo
  1. [oracle@source ogg]$ ll /DBSoft/ogg/demo*
  2. -r--r--r-- 1 oracle oinstall 1217 Mar 13 2010 /DBSoft/ogg/demo_more_ora_create.sql
  3. -r--r--r-- 1 oracle oinstall 967 Mar 13 2010 /DBSoft/ogg/demo_more_ora_insert.sql
  4. -r--r--r-- 1 oracle oinstall 883 Mar 13 2010 /DBSoft/ogg/demo_ora_create.sql
  5. -r--r--r-- 1 oracle oinstall 821 Mar 13 2010 /DBSoft/ogg/demo_ora_insert.sql
  6. -r--r--r-- 1 oracle oinstall 4015 Mar 13 2010 /DBSoft/ogg/demo_ora_lob_create.sql
  7. -r--r--r-- 1 oracle oinstall 2275 Mar 13 2010 /DBSoft/ogg/demo_ora_misc.sql
  8. -r--r--r-- 1 oracle oinstall 1269 Mar 13 2010 /DBSoft/ogg/demo_ora_pk_befores_create.sql
  9. -r--r--r-- 1 oracle oinstall 1227 Mar 13 2010 /DBSoft/ogg/demo_ora_pk_befores_insert.sql
  10. -r--r--r-- 1 oracle oinstall 2520 Mar 13 2010 /DBSoft/ogg/demo_ora_pk_befores_updates.sql

  12. SQL> @/DBSoft/ogg/demo_ora_create.sql

  14. Table created.

  16. Table created.


  19. SQL> @/DBSoft/ogg/demo_ora_insert.sql ###target端不需要執行

  21. 1 row created.


  24. 1 row created.


  27. 1 row created.


  30. 1 row created.


  33. Commit complete.

  35. 11、在源端和目標端查詢剛才建立的表
  36. SQL> col object_name format a15
  37. SQL> select object_name,object_type from user_objects;

  39. OBJECT_NAME OBJECT_TYPE
  40. --------------- -------------------
  41. SYS_C0011106 INDEX
  42. TCUSTMER TABLE
  43. TCUSTORD TABLE
  44. SYS_C0011107 INDEX

  46. SQL>

  48. 12、僅在源端查詢表中所插入的資料，目標端應為空表
  49. SQL> select * from tcustord;

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

  56. SQL> select * from tcustmer;

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

  63. SQL>
###Prepare the Environment
###
四、配置ogg mgr程式
  1. 13、配置mgr程式[源端，目標端]
  2. [oracle@source ogg]$ ggsci

  4. Oracle GoldenGate Command Interpreter for Oracle
  5. Version 11.1.1.0.0 Build 078
  6. Linux, x64, 64bit (optimized), Oracle 11 on Jul 28 2010 13:13:42

  8. Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.



  12. GGSCI (source) 1> edit params mgr ----新增如下兩行內容

  14. --This is the minimal configuration of manager process
  15. PORT 7809


  18. ###透過系統命令檢視剛才配置的，實際上將配置寫入了一個檔案

  20. [oracle@source ogg]$ cd dirprm/

  22. [oracle@source dirprm]$ pwd
  23. /DBSoft/ogg/dirprm

  25. [oracle@source dirprm]$ ls
  26. mgr.prm

  28. [oracle@source dirprm]$ cat mgr.prm
  29. --This is the minimal configuration of manager process
  30. PORT 7809


  33. 14、啟動mgr，及檢視mgr狀態[源端、目標端]
  34. GGSCI (source) 1> start mgr

  36. Manager started.


  39. GGSCI (source) 2> info mgr

  41. Manager is running (IP port source.7809).

  43. [oracle@source ogg]$ ps -ef|grep mgr
  44. oracle 6185 1 0 16:14 ? 00:00:00 ./mgr PARAMFILE /DBSoft/ogg/dirprm/mgr.prm REPORTFILE /DBSoft/ogg/dirrpt/MGR.rpt PROCESSID MGR PORT 7809


  47. 15、檢視mgr程式資訊[源端、目標端]
  48. GGSCI (source) 3> view report mgr


  51. ***********************************************************************
  52.                  Oracle GoldenGate Manager for Oracle
  53.                      Version 11.1.1.0.0 Build 078
  54.    Linux, x64, 64bit (optimized), Oracle 11 on Jul 28 2010 13:12:40
  55.  
  56. Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.


  59.                     Starting at 2014-09-03 16:14:10
  60. ***********************************************************************

  62. Operating System Version:
  63. Linux
  64. Version #1 SMP Fri Jan 27 17:17:51 EST 2012, Release 2.6.18-308.el5
  65. Node: source
  66. Machine: x86_64
  67.                          soft limit hard limit
  68. Address Space Size : unlimited unlimited
  69. Heap Size : unlimited unlimited
  70. File Size : unlimited unlimited
  71. CPU Time : unlimited unlimited

  73. Process id: 6185

  75. Parameters...

  77. --This is the minimal configuration of manager process
  78. PORT 7809


  81. ***********************************************************************
  82. ** Run Time Messages **
  83. ***********************************************************************


  86. 2014-09-03 16:14:10 INFO OGG-00983 Manager started (port 7809).


  89. 16、在源端連結oracle資料庫並配置需要同步的表
  90. GGSCI (source) 1> dblogin userid system, password oracle

  92. GGSCI (source) 3> add trandata ggs.tcustmer

  94. Successfully logged into database.

  96. Logging of supplemental redo data enabled for table GGS.TCUSTMER.

  98. GGSCI (source) 4> add trandata ggs.tcustord

  100. Logging of supplemental redo data enabled for table GGS.TCUSTORD.

  102. 17、檢視需要同步的表的資訊
  103. GGSCI (source) 6> info trandata ggs.*

  105. Logging of supplemental redo log data is enabled for table GGS.TCUSTMER

  107. Logging of supplemental redo log data is enabled for table GGS.TCUSTORD


  110. ####initLoad
五、配置ogg extract程式
  1. 18、源端配置extract抽取程式
  2. GGSCI (source) 2> add extract einikk, SOURCEISTABLE
  3. EXTRACT added.

  5. GGSCI (source) 10> info extract *,tasks ----檢視程式資訊

  7. EXTRACT EINIKK Initialized 2014-09-03 17:03 Status STOPPED
  8. Checkpoint Lag Not Available
  9. Log Read Checkpoint Not Available
  10.                      First Record Record 0
  11. Task SOURCEISTABLE

  13. GGSCI (source) 3> edit params einik
  14. --
  15. -- GoldenGate Initial Data Capture
  16. -- for TCUSTMER and TCUSTORD
  17. --
  18. EXTRACT EINIKK
  19. USERID system , PASSWORD “oracle”
  20. RMTHOST 192.168.7.21, MGRPORT 7809    ---遠端的地址和埠
    RMTTASK REPLICAT , GROUP RINIKK
    TABLE ggs.TCUSTMER;
    TABLE ggs.TCUSTORD;


    19、目標端配置
    GGSCI > add replicat rinikk,specialrun

    GGSCI (source) 6> info replicat *,tasks

    REPLICAT   RINIKK    Initialized   2014-09-03 23:21   Status STOPPED
    Checkpoint Lag       00:00:00 (updated 12:04:39 ago)
    Log Read Checkpoint  Not Available
    Task                 SPECIALRUN

    GGSCI 〉edit params rinikk        ---配置程式資訊
    -- This is replicate parameter file
    REPLICAT RINIKK
    ASSUMETARGETDEFS
    USERID system, PASSWORD oracle
    DISCARDFILE ./dirrpt/RINIKK.dsc, PURGE
    MAP ggs.*, TARGET ggs.*;



    20、檢視兩個節點的mgr是否啟動,並啟動源端的extract程式

    GGSCI (source) 18> info mgr

    Manager is running (IP port source.7809).


    GGSCI (source) 16> start extract einikk

    Sending START request to MANAGER ...
    EXTRACT EINIKK starting

    21、檢視源端extrace程式詳細資訊
    GGSCI (source) 38> view report einikk


    2014-09-04 14:06:13  INFO    OGG-01017  Wildcard resolution set to IMMEDIATE because SOURCEISTABLE is used.

    ***********************************************************************
                     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:06:13
    ***********************************************************************

    Operating System Version:
    Linux
    Version #1 SMP Fri Jan 27 17:17:51 EST 2012, Release 2.6.18-308.el5
    Node: source
    Machine: x86_64
                             soft limit   hard limit
    Address Space Size   :    unlimited    unlimited
    Heap Size            :    unlimited    unlimited
    File Size            :    unlimited    unlimited
    CPU Time             :    unlimited    unlimited

    Process id: 3803

    Description:

    ***********************************************************************
    **            Running with the following parameters                  **
    ***********************************************************************
    EXTRACT EINIKK
    USERID system , PASSWORD "******"
    RMTHOST 192.168.7.21 , MGRPORT 7809
    RMTTASK REPLICAT , GROUP RINIKK
    TABLE ggs.TCUSTMER;

    Using the following key columns for source table GGS.TCUSTMER: CUST_CODE.
    TABLE ggs.TCUSTORD;

    Using the following key columns for source table GGS.TCUSTORD: CUST_CODE, ORDER_DATE, PRODUCT_CODE, ORDER_ID.

    CACHEMGR virtual memory values (may have been adjusted)
    CACHEBUFFERSIZE:                         64K
    CACHESIZE:                                8G
    CACHEBUFFERSIZE (soft max):               4M
    CACHEPAGEOUTSIZE (normal):                4M
    PROCESS VM AVAIL FROM OS (min):          16G
    CACHESIZEMAX (strict force to disk):  13.99G

    Database Version:
    Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
    PL/SQL Release 11.2.0.4.0 - Production
    CORE    11.2.0.4.0      Production
    TNS for Linux: Version 11.2.0.4.0 - Production
    NLSRTL Version 11.2.0.4.0 - Production

    Database Language and Character Set:
    NLS_LANG environment variable specified has invalid format, default value will be used.
    NLS_LANG environment variable not set, using default value AMERICAN_AMERICA.US7ASCII.
    NLS_LANGUAGE     = "AMERICAN"
    NLS_TERRITORY    = "AMERICA"
    NLS_CHARACTERSET = "AL32UTF8"

    Warning: your NLS_LANG setting does not match database server language setting.
    Please refer to user manual for more information.

    Processing table GGS.TCUSTMER

    Processing table GGS.TCUSTORD

    ***********************************************************************
    *                   ** Run Time Statistics **                         *
    ***********************************************************************


    Report at 2014-09-04 14:06:21 (activity since 2014-09-04 14:06:13)

    Output to RINIKK:

    From Table GGS.TCUSTMER:
           #                   inserts:         2
           #                   updates:         0
           #                   deletes:         0
           #                  discards:         0
    From Table GGS.TCUSTORD:
           #                   inserts:         2
           #                   updates:         0
           #                   deletes:         0
           #                  discards:         0




    22、檢視目標端extrace資訊
    GGSCI (target) 6> view report rinikk


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


                        Starting at 2014-09-04 14:06:13
    ***********************************************************************

    Operating System Version:
    Linux
    Version #1 SMP Fri Jan 27 17:17:51 EST 2012, Release 2.6.18-308.el5
    Node: target
    Machine: x86_64
                             soft limit   hard limit
    Address Space Size   :    unlimited    unlimited
    Heap Size            :    unlimited    unlimited
    File Size            :    unlimited    unlimited
    CPU Time             :    unlimited    unlimited

    Process id: 3888

    Description:

    ***********************************************************************
    **            Running with the following parameters                  **
    ***********************************************************************
    -- This is replicate parameter file
    REPLICAT RINIKK
    ASSUMETARGETDEFS
    USERID system , PASSWORD ******
    DISCARDFILE ./dirrpm/RINIKK.dsc , PURGE
    MAP ggs.* , TARGET ggs.*;

    CACHEMGR virtual memory values (may have been adjusted)
    CACHEBUFFERSIZE:                         64K
    CACHESIZE:                              512M
    CACHEBUFFERSIZE (soft max):               4M
    CACHEPAGEOUTSIZE (normal):                4M
    PROCESS VM AVAIL FROM OS (min):           1G
    CACHESIZEMAX (strict force to disk):    881M

    Database Version:
    Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
    PL/SQL Release 11.2.0.4.0 - Production
    CORE    11.2.0.4.0      Production
    TNS for Linux: Version 11.2.0.4.0 - Production
    NLSRTL Version 11.2.0.4.0 - Production

    Database Language and Character Set:
    NLS_LANG environment variable specified has invalid format, default value will be used.
    NLS_LANG environment variable not set, using default value AMERICAN_AMERICA.US7ASCII.
    NLS_LANGUAGE     = "AMERICAN"
    NLS_TERRITORY    = "AMERICA"
    NLS_CHARACTERSET = "AL32UTF8"

    Warning: your NLS_LANG setting does not match database server language setting.
    Please refer to user manual for more information.

    ***********************************************************************
    **                     Run Time Messages                             **
    ***********************************************************************


    Wildcard MAP resolved (entry GGS.*):
      MAP GGS.TCUSTMER, TARGET ggs.TCUSTMER;
    Using following columns in default map by name:
      CUST_CODE, NAME, CITY, STATE

    Using the following key columns for target table GGS.TCUSTMER: CUST_CODE.


    Wildcard MAP resolved (entry GGS.*):
      MAP GGS.TCUSTORD, TARGET ggs.TCUSTORD;
    Using following columns in default map by name:
      CUST_CODE, ORDER_DATE, PRODUCT_CODE, ORDER_ID, PRODUCT_PRICE,
      PRODUCT_AMOUNT, TRANSACTION_ID

    Using the following key columns for target table GGS.TCUSTORD: CUST_CODE, ORDER_DATE, PRODUCT_CODE, ORDER_ID.


    ***********************************************************************
    *                   ** Run Time Statistics **                         *
    ***********************************************************************


    Report at 2014-09-04 14:06:26 (activity since 2014-09-04 14:06:19)

    From Table GGS.TCUSTMER to GGS.TCUSTMER:
           #                   inserts:         2
           #                   updates:         0
           #                   deletes:         0
           #                  discards:         0
    From Table GGS.TCUSTORD to GGS.TCUSTORD:
           #                   inserts:         2
           #                   updates:         0
           #                   deletes:         0
           #                  discards:         0


    CACHE OBJECT MANAGER statistics

    CACHE MANAGER VM USAGE
    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

六、驗證初始化是否成功

  1. 23、在目標端檢視錶資訊是否進來了,我們可以看到表資料已經傳輸過來了。
  2. SQL> select * from tcustmer;

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

  9. SQL> select * from tcustord;

  11. CUST ORDER_DAT PRODUCT_ ORDER_ID PRODUCT_PRICE PRODUCT_AMOUNT TRANSACTION_ID
  12. ---- --------- -------- ---------- ------------- -------------- --------------
  13. WILL 30-SEP-94 CAR 144 17520 3 100
  14. JANE 11-NOV-95 PLANE 256 133300 1 100
七、配置實時同步
  1. 24、在源端新增抓取程式
  2. GGSCI (source) 39> add extract eorakk, tranlog, begin now, threads 1
  3. EXTRACT added.


  6. GGSCI (source) 40> info extract * --檢視抓取程式資訊

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

  13. GGSCI (source) 41> edit params eorakk ---編輯抓取程式引數
  14. EXTRACT EORAKK
  15. USERID system, PASSWORD oracle
  16. RMTHOST 192.168.7.21, MGRPORT 7809
  17. RMTTRAIL ./dirdat/kk
  18. TABLE ggs.TCUSTMER;
  19. TABLE ggs.TCUSTORD;

  21. GGSCI (source) 42> ADD RMTTRAIL ./dirdat/kk, EXTRACT EORAKK, MEGABYTES 5 ---新增TRAIL
  22. RMTTRAIL added.

  24. GGSCI (source) 43> info rmttrail *

  26.        Extract Trail: ./dirdat/kk
  27.              Extract: EORAKK
  28.                Seqno: 0
  29.                  RBA: 0
  30.            File Size: 5M

  32. GGSCI (source) 44> start extract eorakk ---啟動TRAIL

  34. Sending START request to MANAGER ...
  35. EXTRACT EORAKK starting


  38. GGSCI (source) 45> info all

  40. Program Status Group Lag Time Since Chkpt

  42. MANAGER RUNNING
  43. EXTRACT RUNNING EORAKK 00:00:00 00:08:57


  46. GGSCI (source) 46> info extract eorakk, detail

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

  53.   Target Extract Trails:

  55.   Remote Trail Name Seqno RBA Max MB

  57.   ./dirdat/kk 0 921 5

  59.   Extract Source Begin End

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


  65. Current directory /DBSoft/ogg

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


  75. GGSCI (source) 47> view report eorakk


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


  86.                     Starting at 2014-09-04 14:35:44
  87. ***********************************************************************

  89. Operating System Version:
  90. Linux
  91. Version #1 SMP Fri Jan 27 17:17:51 EST 2012, Release 2.6.18-308.el5
  92. Node: source
  93. Machine: x86_64
  94.                          soft limit hard limit
  95. Address Space Size : unlimited unlimited
  96. Heap Size : unlimited unlimited
  97. File Size : unlimited unlimited
  98. CPU Time : unlimited unlimited

  100. Process id: 3961

  102. Description:

  104. ***********************************************************************
  105. ** Running with the following parameters **
  106. ***********************************************************************
  107. --
  108. -- Change Capture parameter file to capture
  109. -- TCUSTMER and TCUSTORD Changes
  110. --
  111. EXTRACT EORAKK
  112. USERID system, PASSWORD ******
  113. RMTHOST 192.168.7.21, MGRPORT 7809
  114. RMTTRAIL ./dirdat/kk
  115. TABLE ggs.TCUSTMER;
  116. TABLE ggs.TCUSTORD;

  118. 2014-09-04 14:35:44 INFO OGG-01635 BOUNDED RECOVERY: reset to initial or altered checkpoint.

  120. Bounded Recovery Parameter:
  121. Options = BRRESET
  122. BRINTERVAL = 4HOURS
  123. BRDIR = /DBSoft/ogg

  125. CACHEMGR virtual memory values (may have been adjusted)
  126. CACHEBUFFERSIZE: 64K
  127. CACHESIZE: 8G
  128. CACHEBUFFERSIZE (soft max): 4M
  129. CACHEPAGEOUTSIZE (normal): 4M
  130. PROCESS VM AVAIL FROM OS (min): 16G
  131. CACHESIZEMAX (strict force to disk): 13.99G

  133. Database Version:
  134. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
  135. PL/SQL Release 11.2.0.4.0 - Production
  136. CORE 11.2.0.4.0 Production
  137. TNS for Linux: Version 11.2.0.4.0 - Production
  138. NLSRTL Version 11.2.0.4.0 - Production

  140. Database Language and Character Set:
  141. NLS_LANG environment variable specified has invalid format, default value will be used.
  142. NLS_LANG environment variable not set, using default value AMERICAN_AMERICA.US7ASCII.
  143. NLS_LANGUAGE = \



來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8494287/viewspace-1355056/，如需轉載，請註明出處，否則將追究法律責任。

相關文章