goldengate单向复制出错小结

baiying1213

GoldenGate (DML、DDL)单向复制
一、源数据库端配置（192.168.0.3）
1.安装软件包
$unzip fbo_ggs_Linux_x64_ora10g_64bit.zip
$mkdir ogg
$mv fbo_ggs_Linux_x64_ora10g_64bit.tar ogg/
$tar zxf fbo_ggs_Linux_x64_ora10g_64bit.tar -C /oracle/goldengate
$vim .bash_profile
        export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
        export GGATE=/oracle/goldengate
2.初始化源端数据库
alter system set log_archive_dest_1='location=/u01/oracle/oradata/orcl/arch' scope=both;
shutdown immediate
startup mount
alter database archivelog
alter database open
alter database add supplemental log data
alter database force logging
alter system set recyclebin=off scope=both;
create tablespace tbs_gguser datafile '/u01/app/oracle/oradata/orcl/gguser.dbf' size 1000M autoextend on;
create user ogg identified by ufsoft default tablespace tbs_gguser temporary tablespace TEMP quota unlimited on tbs_gguser;
grant connect,resource to ogg;
grant create session,alter session to ogg;
grant select any dictionary,select any table to ogg;
grant alter any table to ogg;
grant flashback any table to ogg;
grant execute on dbms_flashback to ogg;
3.支持DDL语句
SQL>@marker_setup
SQL>@ddl_setup
SQL>@role_setup
SQL>grant GGS_GGSUSER_ROLE to ogg;
SQL>@ddl_enable
4.配置goldengate(extract)
   $cd /oracle/goldengate
   $./ggsci
> CREATE SUBDIRS
       > exit
   ./ggsci
        >dblogin userid ogg,password ufsoft
        >edit params mgr
        PORT 7809
        >start mgr
       >edit params GLOBALS
        GGSCHEMA ogg
       >add extract eini_1,tranlog,begin now
       >add rmttrail /oracle/goldengate/dirdat/ma,megabytes 100,extract eini_1
        >edit params eini_1
         EXTRACT EINI_1
         dynamicresolution
         SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
         USERID ogg PASSWORD ufsoft
         RMTHOST 192.168.0.4,MGRPORT 7809
         TRANLOGOPTIONS EXCLUDEUSER ogg
         RMTTRAIL /oracle/goldengate/dirdat/ma
         DDL INCLUDE ALL
         table scott.*;
二、目标数据库配置（192.168.0.4）
1、2、3步骤同第一步
但是第2步中要添加
grant insert any table to ogg;
grant delete any table to ogg;
grant update any table to ogg;
4.配置goldengate(replicat)
$cd /oracle/goldengate
   $./ggsci
> CREATE SUBDIRS
       > exit
   ./ggsci
        >dblogin userid ogg,password ufsoft
        >edit params mgr
        PORT 7809
         PURGEOLDEXTRACTS /dirdat,USECHECKPOINTS
        >start  mgr
        >edit params GLOBALS
        GGSCHEMA ogg
        >add checkpointtable ogg.checkpoint
        >add replicat rini_1,exttrail /oracle/goldengate/dirdat/ma,begin now,checkpointtable ogg.checkpoint
        >edit params rini_1
         REPLICAT RINI_1
         SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
         ASSUMETARGETDEFS
         USERID ogg PASSWORD ufsoft
         DISCARDFILE /oracle/goldengate/dirrpt/RINIaa.dsc,PURGE
         DDL INCLUDE ALL
         DDLERROR DEFAULT IGNORE RETRYOP MAXRETRIES 3 RETRYDELAY 5
         DDLERROR DEFAULT DISCARD
         DDLERROR DEFAULT IGNORE RETRYOP
         MAP scott.* , TARGET scott.*;
        >start replicat rini_1


目标端日志，目标端开启复制进程后在源端进行建表和删除表的操作
2011-08-08 08:44:09  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, rini_1.prm:  REPLICAT RINI_1 starting.
2011-08-08 08:44:09  INFO    OGG-01014  Oracle GoldenGate Delivery for Oracle, rini_1.prm:  Positioning with begin time: Aug 8, 2011 8:44:04 AM, starting record time: Aug 7, 2011 10:48:14 PM at extseqno 6, extrba 504490.
2011-08-08 08:44:09  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, rini_1.prm:  REPLICAT RINI_1 started.
2011-08-08 08:46:41  INFO    OGG-01407  Oracle GoldenGate Delivery for Oracle, rini_1.prm:  Setting current schema for DDL operation to [FINANCE04].
2011-08-08 08:46:41  INFO    OGG-01408  Oracle GoldenGate Delivery for Oracle, rini_1.prm:  Restoring current schema for DDL operation to [OGG].
2011-08-08 08:47:16  WARNING OGG-00869  Oracle GoldenGate Delivery for Oracle, rini_1.prm:  No unique key is defined for table TEST. All viable columns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to define the key.
2011-08-08 08:47:36  INFO    OGG-01407  Oracle GoldenGate Delivery for Oracle, rini_1.prm:  Setting current schema for DDL operation to [FINANCE04].
2011-08-08 08:47:36  INFO    OGG-01408  Oracle GoldenGate Delivery for Oracle, rini_1.prm:  Restoring current schema for DDL operation to [OGG].

delete replicat rini_1,exttrail /u01/goldengate/dirdat/ma,begin now,checkpointtable ogg.checkpoint
add replicat rini_1,exttrail /u01/goldengate/dirdat/ma,begin now,checkpointtable ogg.checkpoint

renxiao2003

帮顶了。学习。