Oracle GoldenGate for Oracle 11g(Solaris 10 x86-64) to Oracle 10g(CentOS 4.8) configuration

最新推荐文章于 2021-04-13 05:39:13 发布

ZhongWeicheng

最新推荐文章于 2021-04-13 05:39:13 发布

阅读量3.2k

点赞数

本文链接：https://blog.csdn.net/staricqxyz/article/details/8363628

版权

Oracle 同时被 2 个专栏收录

165 篇文章 0 订阅

订阅专栏

Oracle GoldenGate

18 篇文章 0 订阅

订阅专栏

源端:
OS: Oracle Solaris 10 x86-64
DB: Oracle Database 11gR2(11.2.0.1)
IP: 192.168.106.164

同步表名: GGUSER.T_RSYNC

目标端:
OS: CentOS 4.8
DB: Oracle Database 10gR2(10.2.0.5)
IP: 192.168.106.161
同步表名 :GGTARGET.T_ISRSYNC

源端:安装goldengate
安装之前需要打开Oracle的supplemental log和force logging,将数据库设为Archive Mode

SQL> ALTER DATABASE force logging;

DATABASE altered.

SQL> ALTER DATABASE ADD supplemental log DATA;

DATABASE altered.

SQL> ALTER system switch logfile;

System altered.

SQL> archive log list
DATABASE log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log SEQUENCE     7
NEXT log SEQUENCE TO archive   9
CURRENT log SEQUENCE           9
SQL>

-bash-3.2$ unzip Oracle\ GoldenGate\ V11.1.1.1.2\ for\ Oracle\ 11g\ 64bit\ on\ Solaris\ 10\ on\ x86-64.zip 
Archive:  Oracle GoldenGate V11.1.1.1.2 for Oracle 11g 64bit on Solaris 10 on x86-64.zip
  inflating: ggs_Solaris_x86_64_ora11g_64bit.tar  
  inflating: OGG_WinUnix_Rel_Notes_11 1 1 1 2.pdf  
  inflating: Oracle GoldenGate 11 1 1 1 README.txt  
-bash-3.2$ tar -xvof ggs_Solaris_x86_64_ora11g_64bit.tar

-bash-3.2$ ggsci -v

Oracle GoldenGate Command Interpreter FOR Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100 
Solaris, x64, 64bit (optimized), Oracle 11g ON Oct  4 2011 23:54:06

Copyright (C) 1995, 2011, Oracle AND/OR its affiliates. ALL rights reserved.


-bash-3.2$

-bash-3.2$ ggsci 

Oracle GoldenGate Command Interpreter FOR Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100 
Solaris, x64, 64bit (optimized), Oracle 11g ON Oct  4 2011 23:54:06

Copyright (C) 1995, 2011, Oracle AND/OR its affiliates. ALL rights reserved.



GGSCI (testdb) 1> CREATE subdirs

Creating subdirectories UNDER CURRENT directory /u01/app/oracle/goldengate

Parameter files                /u01/app/oracle/goldengate/dirprm: created
Report files                   /u01/app/oracle/goldengate/dirrpt: created
Checkpoint files               /u01/app/oracle/goldengate/dirchk: created
Process STATUS files           /u01/app/oracle/goldengate/dirpcs: created
SQL script files               /u01/app/oracle/goldengate/dirsql: created
DATABASE definitions files     /u01/app/oracle/goldengate/dirdef: created
EXTRACT DATA files             /u01/app/oracle/goldengate/dirdat: created
TEMPORARY files                /u01/app/oracle/goldengate/dirtmp: created
Veridata files                 /u01/app/oracle/goldengate/dirver: created
Veridata LOCK files            /u01/app/oracle/goldengate/dirver/LOCK: created
Veridata Out-Of-Sync files     /u01/app/oracle/goldengate/dirver/oos: created
Veridata Out-Of-Sync XML files /u01/app/oracle/goldengate/dirver/oosxml: created
Veridata Parameter files       /u01/app/oracle/goldengate/dirver/params: created
Veridata Report files          /u01/app/oracle/goldengate/dirver/report: created
Veridata STATUS files          /u01/app/oracle/goldengate/dirver/STATUS: created
Veridata Trace files           /u01/app/oracle/goldengate/dirver/trace: created
Stdout files                   /u01/app/oracle/goldengate/dirout: created


GGSCI (testdb) 2> exit

编辑manager参数文件,PORT为7809

-bash-3.2$ ggsci 

Oracle GoldenGate Command Interpreter FOR Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100 
Solaris, x64, 64bit (optimized), Oracle 11g ON Oct  4 2011 23:54:06

Copyright (C) 1995, 2011, Oracle AND/OR its affiliates. ALL rights reserved.



GGSCI (testdb) 1> EDIT PARAMS MGR

启动MGR进程

GGSCI (testdb) 2> info ALL

Program     STATUS      GROUP       Lag           TIME Since Chkpt

MANAGER     STOPPED                                           


GGSCI (testdb) 3> info mgr

Manager IS DOWN!


GGSCI (testdb) 4> START MGR

Manager started.


GGSCI (testdb) 5> info ALL

Program     STATUS      GROUP       Lag           TIME Since Chkpt

MANAGER     RUNNING                                           


GGSCI (testdb) 6> info mgr

Manager IS running (IP port testdb.7809).

-bash-3.2$ ps -ef|grep mgr
  oracle  5865  5847   0 13:40:07 ?           0:00 ./mgr PARAMFILE /u01/app/oracle/goldengate/dirprm/mgr.prm REPORTFILE /u01/app/o

源端需要同步的表添加补充日志

GGSCI (testdb) 1> dblogin userid system, password oracle
Successfully logged INTO DATABASE.

GGSCI (testdb) 2> info trandata gguser.t_rsync

Logging OF supplemental redo log DATA IS disabled FOR TABLE GGUSER.T_RSYNC.

GGSCI (testdb) 3> ADD trandata gguser.t_rsync

Logging OF supplemental redo DATA enabled FOR TABLE GGUSER.T_RSYNC.

GGSCI (testdb) 4> info trandata gguser.t_rsync

Logging OF supplemental redo log DATA IS enabled FOR TABLE GGUSER.T_RSYNC

目标端ogg安装

[oracle@joy goldengate]$ unzip Oracle\ GoldenGate\ V10.4.0.x\ FOR\ Oracle\ 10g\ ON\ RedHat\ 4.0.zip 
Archive:  Oracle GoldenGate V10.4.0.x FOR Oracle 10g ON RedHat 4.0.zip
  inflating: ggs_redhatAS40_x86_ora10g_32bit_v10.4.0.19_002.tar  
[oracle@joy goldengate]$ tar -xvof ggs_redhatAS40_x86_ora10g_32bit_v10.4.0.19_002.tar

[oracle@joy goldengate]$ ggsci -v

Oracle GoldenGate Command Interpreter FOR Oracle
Version 10.4.0.19 Build 002
Linux, x86, 32bit (optimized), Oracle 10 ON Sep 17 2009 23:49:42

Copyright (C) 1995, 2009, Oracle AND/OR its affiliates.  ALL rights reserved.

[oracle@joy goldengate]$ ggsci

Oracle GoldenGate Command Interpreter FOR Oracle
Version 10.4.0.19 Build 002
Linux, x86, 32bit (optimized), Oracle 10 ON Sep 17 2009 23:49:42

Copyright (C) 1995, 2009, Oracle AND/OR its affiliates.  ALL rights reserved.



GGSCI (joy.localdomain) 1> CREATE subdirs

Creating subdirectories UNDER CURRENT directory /u01/app/oracle/goldengate

Parameter files                /u01/app/oracle/goldengate/dirprm: created
Report files                   /u01/app/oracle/goldengate/dirrpt: created
Checkpoint files               /u01/app/oracle/goldengate/dirchk: created
Process STATUS files           /u01/app/oracle/goldengate/dirpcs: created
SQL script files               /u01/app/oracle/goldengate/dirsql: created
DATABASE definitions files     /u01/app/oracle/goldengate/dirdef: created
EXTRACT DATA files             /u01/app/oracle/goldengate/dirdat: created
TEMPORARY files                /u01/app/oracle/goldengate/dirtmp: created
Veridata files                 /u01/app/oracle/goldengate/dirver: created
Veridata LOCK files            /u01/app/oracle/goldengate/dirver/LOCK: created
Veridata Out-Of-Sync files     /u01/app/oracle/goldengate/dirver/oos: created
Veridata Out-Of-Sync XML files /u01/app/oracle/goldengate/dirver/oosxml: created
Veridata Parameter files       /u01/app/oracle/goldengate/dirver/params: created
Veridata Report files          /u01/app/oracle/goldengate/dirver/report: created
Veridata STATUS files          /u01/app/oracle/goldengate/dirver/STATUS: created
Veridata Trace files           /u01/app/oracle/goldengate/dirver/trace: created
Stdout files                   /u01/app/oracle/goldengate/dirout: created

编辑manager参数文件,PORT为7809

GGSCI (joy.localdomain) 2> EDIT PARAMS MGR
PORT 7809

启动MGR进程

GGSCI (joy.localdomain) 3> info mgr

Manager IS DOWN!


GGSCI (joy.localdomain) 4> info ALL

Program     STATUS      GROUP       Lag           TIME Since Chkpt

MANAGER     STOPPED                                           


GGSCI (joy.localdomain) 5> START mgr

Manager started.


GGSCI (joy.localdomain) 6> info mgr

Manager IS running (IP port joy.localdomain.7809).


GGSCI (joy.localdomain) 7> info ALL

Program     STATUS      GROUP       Lag           TIME Since Chkpt

MANAGER     RUNNING

在源端配置Capture,添加一个extract组

GGSCI (testdb) 2> ADD EXTRACT EORAJJ, TRANLOG, BEGIN NOW
EXTRACT added.


GGSCI (testdb) 3> INFO EXTRACT EORAJJ

EXTRACT    EORAJJ    Initialized   2011-12-30 14:17   STATUS STOPPED
Checkpoint Lag       00:00:00 (updated 00:00:19 ago)
Log READ Checkpoint  Oracle Redo Logs
                     2011-12-30 14:17:17  Seqno 0, RBA 0


GGSCI (testdb) 4> INFO ALL

Program     STATUS      GROUP       Lag           TIME Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     STOPPED     EORAJJ      00:00:00      00:00:23

编辑extract参数文件

GGSCI (testdb) 5> EDIT PARAMS EORAJJ

GGSCI (testdb) 6> VIEW params eorajj

EXTRACT EORAJJ
USERID GGADMIN, PASSWORD ggadmin 
RMTHOST 192.168.106.161, MGRPORT 7809 
RMTTRAIL /u01/app/oracle/goldengate/dirdat/jj 
TABLE GGUSER.T_RSYNC;

在源端添加目标端的trail文件

GGSCI (testdb) 7> ADD RMTTRAIL /u01/app/oracle/goldengate/dirdat/jj, EXTRACT EORAJJ, MEGABYTES 5
RMTTRAIL added.


GGSCI (testdb) 8> INFO RMTTRAIL *

       EXTRACT Trail: /u01/app/oracle/goldengate/dirdat/jj
             EXTRACT: EORAJJ
               Seqno: 0
                 RBA: 0
           File SIZE: 5M

启动captrue进程

GGSCI (testdb) 10> START EXTRACT EORAJJ

Sending START request TO MANAGER ...
EXTRACT EORAJJ starting

GGSCI (testdb) 12> INFO EXTRACT EORAJJ, DETAIL

EXTRACT    EORAJJ    LAST Started 2011-12-30 14:28   STATUS RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:08 ago)
Log READ Checkpoint  Oracle Redo Logs
                     2011-12-30 14:28:51  Seqno 9, RBA 10195456

  Target EXTRACT Trails:

  Remote Trail Name                                Seqno        RBA     MAX MB

  /u01/app/oracle/goldengate/dirdat/jj                 0        970          5

  EXTRACT SOURCE                          BEGIN             END             

  /u01/app/oracle/oradata/parmary_joydb/redo03.log  2011-12-30 14:17  2011-12-30 14:28
  NOT Available                           * Initialized *   2011-12-30 14:17


CURRENT directory    /u01/app/oracle/goldengate

Report file          /u01/app/oracle/goldengate/dirrpt/EORAJJ.rpt
Parameter file       /u01/app/oracle/goldengate/dirprm/eorajj.prm
Checkpoint file      /u01/app/oracle/goldengate/dirchk/EORAJJ.cpe
Process file         /u01/app/oracle/goldengate/dirpcs/EORAJJ.pce
Stdout file          /u01/app/oracle/goldengate/dirout/EORAJJ.OUT
Error log            /u01/app/oracle/goldengate/ggserr.log


GGSCI (testdb) 13> INFO EXTRACT EORAJJ

EXTRACT    EORAJJ    LAST Started 2011-12-30 14:28   STATUS RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:05 ago)
Log READ Checkpoint  Oracle Redo Logs
                     2011-12-30 14:30:04  Seqno 9, RBA 10201600

GGSCI (testdb) 14> VIEW REPORT EORAJJ


***********************************************************************
                 Oracle GoldenGate Capture FOR Oracle
     Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100 
  Solaris, x64, 64bit (optimized), Oracle 11g ON Oct  5 2011 00:35:18
 
Copyright (C) 1995, 2011, Oracle AND/OR its affiliates. ALL rights reserved.


                    Starting at 2011-12-30 14:28:44
***********************************************************************

Operating System Version:
SunOS
Version Generic_147441-01, Release 5.10
Node: testdb
Machine: i86pc
                         soft LIMIT   hard LIMIT
Address SPACE SIZE   :    unlimited    unlimited
Heap SIZE            :    unlimited    unlimited
File SIZE            :    unlimited    unlimited
CPU TIME             :    unlimited    unlimited

Process id: 6111

Description: 

***********************************************************************
**            Running WITH the following parameters                  **
***********************************************************************
EXTRACT EORAJJ
USERID GGADMIN, PASSWORD *******
RMTHOST 192.168.106.161, MGRPORT 7809
RMTTRAIL /u01/app/oracle/goldengate/dirdat/jj
TABLE GGUSER.T_RSYNC;

2011-12-30 14:28:44  INFO    OGG-01635  BOUNDED RECOVERY: reset TO initial OR altered checkpoint.

Bounded Recovery Parameter:
Options    = BRRESET
BRINTERVAL = 4HOURS
BRDIR      = /u01/app/oracle/goldengate

CACHEMGR virtual memory VALUES (may have been adjusted)
CACHEBUFFERSIZE:                         64K
CACHESIZE:                                2G
CACHEBUFFERSIZE (soft MAX):               4M
CACHEPAGEOUTSIZE (normal):                4M
PROCESS VM AVAIL FROM OS (MIN):        3.53G
CACHESIZEMAX (strict force TO disk):   3.13G

DATABASE Version:
Oracle DATABASE 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS FOR Solaris: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

DATABASE LANGUAGE AND CHARACTER SET:
NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK" 
NLS_LANGUAGE     = "AMERICAN" 
NLS_TERRITORY    = "AMERICA" 
NLS_CHARACTERSET = "ZHS16GBK" 

2011-12-30 14:28:46  WARNING OGG-01423  No valid DEFAULT archive log destination directory found FOR thread 1.

2011-12-30 14:28:46  INFO    OGG-01515  Positioning TO BEGIN TIME DEC 30, 2011 2:17:17 PM.

2011-12-30 14:28:46  INFO    OGG-01516  Positioned TO SEQUENCE 9, RBA 9965072, DEC 30, 2011 2:17:17 PM.

2011-12-30 14:28:51  INFO    OGG-01226  Socket buffer SIZE SET TO 27985 (FLUSH SIZE 27985).

2011-12-30 14:28:51  INFO    OGG-01052  No recovery IS required FOR target file /u01/app/oracle/goldengate/dirdat/jj000000, at RBA 0 (file NOT opened).

2011-12-30 14:28:51  INFO    OGG-01478  Output file /u01/app/oracle/goldengate/dirdat/jj IS USING format RELEASE 10.4/11.1.

***********************************************************************
**                     Run TIME Messages                             **
***********************************************************************


2011-12-30 14:28:51  INFO    OGG-01517  POSITION OF FIRST record processed SEQUENCE 9, RBA 9965072, SCN 0.1025011, DEC 30, 2011 2:17:49 PM.

GGSCI (testdb) 15> INFO ALL

Program     STATUS      GROUP       Lag           TIME Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EORAJJ      00:00:00      00:00:09

在目标端配置Delivery进程,创建编辑GLOBALS参数,创建checkpointtable

GGSCI (joy.localdomain) 1> EDIT PARAMS ./GLOBALS

CHECKPOINTTABLE GGTARGET.ggckpttab

GGSCI (joy.localdomain) 1> dblogin userid system, password oracle
Successfully logged INTO DATABASE.

GGSCI (joy.localdomain) 2> info ALL

Program     STATUS      GROUP       Lag           TIME Since Chkpt

MANAGER     RUNNING                                           


GGSCI (joy.localdomain) 3> ADD CHECKPOINTTABLE

No checkpoint TABLE specified, USING GLOBALS specification (GGTARGET.ggckpttab)...

Successfully created checkpoint TABLE GGTARGET.GGCKPTTAB.

GGTARGET@joydb:~>SELECT tname FROM tab;

TNAME
------------------------------
T_ISRSYNC
GGCKPTTAB

GGTARGET@joydb:~>DESC ggckpttab
 Name                                      NULL?    TYPE
 ----------------------------------------- -------- ----------------------------
 GROUP_NAME                                NOT NULL VARCHAR2(8)
 GROUP_KEY                                 NOT NULL NUMBER(19)
 SEQNO                                              NUMBER(10)
 RBA                                       NOT NULL NUMBER(19)
 AUDIT_TS                                           VARCHAR2(29)
 CREATE_TS                                 NOT NULL DATE
 LAST_UPDATE_TS                            NOT NULL DATE
 CURRENT_DIR                               NOT NULL VARCHAR2(255)

配置Delivery,添加replicat组

GGSCI (joy.localdomain) 4> ADD REPLICAT RORAJJ, EXTTRAIL /u01/app/oracle/goldengate/dirdat/jj
REPLICAT added.

创建编辑replicat参数文件

GGSCI (joy.localdomain) 5> EDIT PARAMS RORAJJ

REPLICAT RORAJJ
USERID GGADMIN, PASSWORD ggadmin
HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE /u01/app/oracle/goldengate/dirrpt/RORAJJ.DSC, PURGE
MAP GGUSER.T_RSYNC, TARGET GGTARGET.T_ISRSYNC;

GGSCI (joy.localdomain) 7> info ALL

Program     STATUS      GROUP       Lag           TIME Since Chkpt

MANAGER     RUNNING                                           
REPLICAT    STOPPED     RORAJJ      00:00:00      00:04:55

启动replicat进程

GGSCI (joy.localdomain) 8> START REPLICAT RORAJJ

Sending START request TO MANAGER ...
REPLICAT RORAJJ starting


GGSCI (joy.localdomain) 9> INFO ALL

Program     STATUS      GROUP       Lag           TIME Since Chkpt

MANAGER     RUNNING                                           
REPLICAT    RUNNING     RORAJJ      00:00:00      00:00:05

验证数据同步

源端

-bash-3.2$ ggsci 

Oracle GoldenGate Command Interpreter FOR Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100 
Solaris, x64, 64bit (optimized), Oracle 11g ON Oct  4 2011 23:54:06

Copyright (C) 1995, 2011, Oracle AND/OR its affiliates. ALL rights reserved.



GGSCI (testdb) 1> info ALL

Program     STATUS      GROUP       Lag           TIME Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EORAJJ      00:00:00      00:00:10

-bash-3.2$ sqlplus gguser/gguser

SQL*Plus: Release 11.2.0.1.0 Production ON Fri DEC 30 15:00:05 2011

Copyright (c) 1982, 2009, Oracle.  ALL rights reserved.


Connected TO:
Oracle DATABASE 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
WITH the Partitioning, OLAP, DATA Mining AND REAL Application Testing options


SQL> INSERT INTO t_rsync
  2  VALUES(
  3  1,'Weicheng Zhong','Oracle Database 10g OCP,Oracle GoldenGate 10 Certified Implementation Specialist');

1 ROW created.

SQL> commit;

Commit complete.

目标端

[oracle@joy goldengate]$ ggsci 

Oracle GoldenGate Command Interpreter FOR Oracle
Version 10.4.0.19 Build 002
Linux, x86, 32bit (optimized), Oracle 10 ON Sep 17 2009 23:49:42

Copyright (C) 1995, 2009, Oracle AND/OR its affiliates.  ALL rights reserved.



GGSCI (joy.localdomain) 1> info ALL

Program     STATUS      GROUP       Lag           TIME Since Chkpt

MANAGER     RUNNING                                           
REPLICAT    RUNNING     RORAJJ      00:00:00      00:00:03

[oracle@joy goldengate]$ sqlplus ggtarget/ggtarget

SQL*Plus: Release 10.2.0.5.0 - Production ON Fri DEC 30 15:07:28 2011

Copyright (c) 1982, 2010, Oracle.  ALL Rights Reserved.


Connected TO:
Oracle DATABASE 10g Enterprise Edition Release 10.2.0.5.0 - Production
WITH the Partitioning, OLAP, DATA Mining AND REAL Application Testing options

GGTARGET@joydb:~>SET linesize 150
GGTARGET@joydb:~>col rname format a15
GGTARGET@joydb:~>col rdesc format a81
GGTARGET@joydb:~>SELECT * FROM t_isrsync;

       RID RNAME           RDESC
---------- --------------- ---------------------------------------------------------------------------------
         1 Weicheng Zhong  Oracle DATABASE 10g OCP,Oracle GoldenGate 10 Certified Implementation Specialist

同步成功

[oracle@joy goldengate]$ logdump 

Oracle GoldenGate Log File Dump Utility
Version 10.4.0.19 Build 002

Copyright (C) 1995, 2009, Oracle AND/OR its affiliates.  ALL rights reserved.


 
Logdump 1 >OPEN /u01/app/oracle/goldengate/dirdat/jj000000
CURRENT LogTrail IS /u01/app/oracle/goldengate/dirdat/jj000000 
Logdump 2 >ghdr ON
Logdump 3 >headertoken ON
Logdump 4 >usertoken ON
Logdump 5 >detail ON
Logdump 6 >detail DATA

Logdump 8 >n
TokenID x47 'G' Record Header    Info x01  LENGTH  235 
TokenID x48 'H' GHDR             Info x00  LENGTH   49 
TokenID x44 'D' DATA             Info x00  LENGTH  119 
TokenID x54 'T' GGS Tokens       Info x00  LENGTH   47 
TokenID x5a 'Z' Record Trailer   Info x01  LENGTH  235 
___________________________________________________________________ 
Hdr-Ind    :     E  (x45)     Partition  :     .  (x04)  
UndoFlag   :     .  (x00)     BeforeAfter:     A  (x41)  
RecLength  :   119  (x0077)   IO TIME    : 2011/12/30 15:03:39.368.781   
IOType     :     5  (x05)     OrigNode   :   255  (xff) 
TransInd   :     .  (x03)     FormatType :     R  (x52) 
SyskeyLen  :     0  (x00)     Incomplete :     .  (x00) 
AuditRBA   :          9       AuditPos   : 12447248 
Continued  :     N  (x00)     RecCount   :     1  (x01) 

2011/12/30 15:03:39.368.781 INSERT               Len   119 RBA 970 
Name: GGUSER.T_RSYNC 
After  Image:                                             Partition 4   G  s   
 0000 0005 0000 0001 3100 0100 1200 0000 0e57 6569 | ........1........Wei  
 6368 656e 6720 5a68 6f6e 6700 0200 5400 0000 504f | cheng Zhong...T...PO  
 7261 636c 6520 4461 7461 6261 7365 2031 3067 204f | racle DATABASE 10g O  
 4350 2c4f 7261 636c 6520 476f 6c64 656e 4761 7465 | CP,Oracle GoldenGate  
 2031 3020 4365 7274 6966 6965 6420 496d 706c 656d |  10 Certified Implem  
 656e 7461 7469 6f6e 2053 7065 6369 616c 6973 74   | entation Specialist  
COLUMN     0 (x0000), Len     5 (x0005)  
 0000 0001 31                                      | ....1  
COLUMN     1 (x0001), Len    18 (x0012)  
 0000 000e 5765 6963 6865 6e67 205a 686f 6e67      | ....Weicheng Zhong  
COLUMN     2 (x0002), Len    84 (x0054)  
 0000 0050 4f72 6163 6c65 2044 6174 6162 6173 6520 | ...POracle DATABASE   
 3130 6720 4f43 502c 4f72 6163 6c65 2047 6f6c 6465 | 10g OCP,Oracle Golde  
 6e47 6174 6520 3130 2043 6572 7469 6669 6564 2049 | nGate 10 Certified I  
 6d70 6c65 6d65 6e74 6174 696f 6e20 5370 6563 6961 | mplementation Specia  
 6c69 7374                                         | list  
   
Logdump 9 >n
Logdump 10 >n
Logdump 11 >

ZhongWeicheng

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Oracle GoldenGate for Oracle 11g(Solaris 10 x86-64) to Oracle 10g(CentOS 4.8) configuration

源端:OS: Oracle Solaris 10 x86-64DB: Oracle Database 11gR2(11.2.0.1)IP: 192.168.106.164同步表名: GGUSER.T_RSYNC目标端:OS: CentOS 4.8DB: Oracle Database 10gR2(10.2.0.5)
复制链接

扫一扫

专栏目录