goldengate（21）--goldengate支持异构平台数据库复制（仅配置DML）

示例：

环境: 

源端：

linux redhat 5.4  oracle 11.2.0.3    goldengate 11.1.1 for oracle11g

目标端：

windows 2003 sp2   oracle 11.2.0.3   goldengate 11.2.0 for oracle11g

本案例测试的目的：

异构平台数据库之间实现数据复制

步骤：

源端配置：

GGSCI (dbhouse) 11> view params mgr

PORT 7809
DYNAMICPORTLIST 7810-7820, 7830
AUTOSTART EXTRACT *
AUTORESTART EXTRACT *, RETRIES 4, WAITMINUTES 4
STARTUPVALIDATIONDELAY 5
PURGEOLDEXTRACTS /u01/app/oracle/ggs/dirdat/trail/hr/tt*, USECHECKPOINTS, MINKEEPHOURS 10

GGSCI (dbhouse) 12> view params ./GLOBALS

GGSCHEMA ggs

dblogin userid ggs, password ggs sysdba
add EXTRACT s_ex_hr, tranlog, begin now
add exttrail /u01/app/oracle/ggs/dirdat/trail/hr/tt, extract s_ex_hr

GGSCI (dbhouse) 13> VIEW PARAMS S_EX_HR

EXTRACT s_ex_hr
--SETENV (NLS_LANG = "CHINESE_CHINA.ZHS16GBK")
SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/dbhome_1")
SETENV (ORACLE_SID = "dbking")
DBOPTIONS ALLOWUNUSEDCOLUMN
USERID ggs, PASSWORD ggs
TRANLOGOPTIONS ASMUSER sys@asm, ASMPASSWORD grid
EXTTRAIL /u01/app/oracle/ggs/dirdat/trail/hr/tt
--TABLEEXCLUDE test.MV_123, test.mlog$_xy101
SEQUENCE gis_test.*;
GETTRUNCATES
WARNLONGTRANS 1m, CHECKINTERVAL 5s
DDL INCLUDE MAPPED OBJNAME "gis_test.*"
TABLE gis_test.*;
TABLE hr.t1;
TABLE hr.t200;
TABLE corebase.c1;
--TABLE gis_test.t4, COLSEXCEPT (NAME);

GGSCI (dbhouse) 19> dblogin userid ggs, password ggs
Successfully logged into database.

ADD EXTRACT pump_win, EXTTRAILSOURCE /u01/app/oracle/ggs/dirdat/trail/hr/tt, BEGIN NOW
GGSCI (dbhouse) 20>
EXTRACT added.

GGSCI (dbhouse) 22> ADD RMTTRAIL C:\app\oracle\ggs\dirdat\win\ww, EXTRACT pump_win
RMTTRAIL added.

EXTRACT pump_win
USERID ggs, PASSWORD ggs
RMTHOST 10.23.5.155, MGRPORT 7809
RMTTRAIL c:\app\oracle\ggs\dirdat\win\ww
PASSTHRU
TABLE corebase.c1;

start mgr   start er *

GGSCI (dbhouse) 54> info er *

EXTRACT    PUMP_HR   Last Started 2013-03-22 12:03   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:08 ago)
Log Read Checkpoint  File /u01/app/oracle/ggs/dirdat/trail/hr/tt000060
                     2013-03-22 12:03:51.557569  RBA 1045

EXTRACT    PUMP_WIN  Last Started 2013-03-22 12:11   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:50:14 ago)
Log Read Checkpoint  File /u01/app/oracle/ggs/dirdat/trail/hr/tt000060
                     2013-03-22 11:21:18.000000  RBA 983

EXTRACT    S_EX_HR   Last Started 2013-03-22 12:03   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:06 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2013-03-22 12:11:20  Seqno 244, RBA 38345728

目的端配置：

alter database add supplemental log data;
alter system switch logfile;

create tablespace ggs datafile 'C:\APP\ORACLE\ORADATA\WINTEST\GGS01.DBF'
size 100M
autoextend on
maxsize 1024M
extent management local
uniform. size 128k
segment space management auto;
create user ggs identified by ggs default tablespace ggs

grant create session,alter session to ggs;
grant resource to ggs;
grant connect to ggs;
grant select any dictionary to ggs;
grant select any table to ggs;
grant insert any table to ggs;
grant update any table to ggs;
grant delete any table to ggs;
grant create table to ggs;
grant dba to ggs;

trail 文件目录

c:\app\oracle\ggs\dirdat\win\