golendgate(28)---使用standby database 创建goldengate extract抽取数据中心
该文档在standby database配置ALO模式,即挖掘归档日志,上一篇是挖掘联机重做日志文件,即standby redo log.
配置如下:
源端extract 配置如下:
EXTRACT s_ex_mid
-- SETENV (NLS_LANG = CHINESE_CHINA.ZHS16GBK)
SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/dbhome_1")
SETENV (ORACLE_SID = "dbking")
USERID ggs@dbking, PASSWORD ggs
TRANLOGOPTIONS ARCHIVEDLOGONLY
-- TRANLOGOPTIONS ASMUSERsys@asm, ASMPASSWORD grid sysdba
TRANLOGOPTIONS DBLOGREADER
TRANLOGOPTIONS DBLOGREADERBUFSIZE 1048576
TRANLOGOPTIONS ALTARCHIVELOGDEST INSTANCE dbking /arch/archivelog
EXTTRAIL /u01/app/oracle/ggs/dirdat/trail/cc
TABLE gis_test.*;
-- SETENV (NLS_LANG = CHINESE_CHINA.ZHS16GBK)
SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/dbhome_1")
SETENV (ORACLE_SID = "dbking")
USERID ggs@dbking, PASSWORD ggs
TRANLOGOPTIONS ARCHIVEDLOGONLY
-- TRANLOGOPTIONS ASMUSERsys@asm, ASMPASSWORD grid sysdba
TRANLOGOPTIONS DBLOGREADER
TRANLOGOPTIONS DBLOGREADERBUFSIZE 1048576
TRANLOGOPTIONS ALTARCHIVELOGDEST INSTANCE dbking /arch/archivelog
EXTTRAIL /u01/app/oracle/ggs/dirdat/trail/cc
TABLE gis_test.*;
源端pump配置如下:
EXTRACT pump_mid
USERID ggs@dbking, PASSWORD ggs
RMTHOST 10.23.5.155, MGRPORT 1500
RMTTRAIL C:\app\oracle\ggs\dirdat\mid\mm
PASSTHRU
TABLE gis_test.*;
USERID ggs@dbking, PASSWORD ggs
RMTHOST 10.23.5.155, MGRPORT 1500
RMTTRAIL C:\app\oracle\ggs\dirdat\mid\mm
PASSTHRU
TABLE gis_test.*;
目标端replicat配置如下:
REPLICAT rep_mid
ASSUMETARGETDEFS
DISCARDFILE c:\app\oracle\ggs\dirrpt\discard\rep.dsc, APPEND
USERID ggs, PASSWORD ggs
MAP gis_test.*, TARGET gis_test.*;
ASSUMETARGETDEFS
DISCARDFILE c:\app\oracle\ggs\dirrpt\discard\rep.dsc, APPEND
USERID ggs, PASSWORD ggs
MAP gis_test.*, TARGET gis_test.*;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21266384/viewspace-757601/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/21266384/viewspace-757601/