goldengate（22）

goldengate（22）---ALO（ARCHIVE LOG ONLY）模式进行数据复制

extract抽取进程配置：

GGSCI (dbhouse) 44> 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
TRANLOGOPTIONS ARCHIVEDLOGONLY
TRANLOGOPTIONS ALTARCHIVELOGDEST instance dbking /archivelog
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.*, corebase.*"  ###error configration
DDL INCLUDE MAPPED OBJNAME "gis_test.*"
TABLE gis_test.*;
TABLE hr.t1;
TABLE hr.t200;
TABLE corebase.*;
--TABLE gis_test.t4, COLSEXCEPT (NAME);

黑体字表示设定为ALO模式，默认是读取online log.

源端操作：
insert into corebase.c1 values (9,'iiiii');
commit;

切换日志:

alter system switch logfile;

目的端：

查看目的库看到数据了.

 

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21266384/viewspace-756964/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21266384/viewspace-756964/