ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > Oracle > GoldentGate Oracle to Oracle 初始化详解

GoldentGate Oracle to Oracle 初始化详解

原创 Oracle 作者：wuweilong 时间：2014-09-09 22:17:49 1 删除 编辑
一、安装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博客 ” ，链接：https://blog.itpub.net/20674423/viewspace-1266660/ ，如需转载，请注明出处，否则将追究法律责任。

0
0
上一篇： expdp 导出多路径
下一篇： Oracle 11gR2 用exp无法导出空表解决方法
请登录后发表评论 登录
全部评论
wuweilong
专家姓名：吴伟龙
Oracle ACE Associate； 12cOCM；11gOCM；MySQL OCP；PGCA；PGCE；KCA; KCP; 本人拥有十年以上运营商，广电传媒，能源，制造等行业DBA从业经验; 有着丰富的管理及运维经验，经历过国家级重点项目，省级标杆项目，新型试点项目

注册时间：2010-01-08

  • 博文量
    779
  • 访问量
    4931699

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593