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博客 ” ，链接：https://blog.itpub.net/21266384/viewspace-756964/ ，如需转载，请注明出处，否则将追究法律责任。
