.
OGG程序replicat进程部署文档
目录
一、准备工作 ..............................................................................................................................................2
1、检查ogg程序运行情况，停止replicat进程 ...................................................................2 2、检查ogg程序配置文件 ..........................................................................................................2 二、配置replicat进程 .............................................................................................................................2
1、配置replicat进程参数文件 ....................................................................................................2 2、重新添加replicat进程 .............................................................................................................6 三、初始化数据 ..........................................................................................................................................7
1、在数据库服务器上创建新的用户名存放数据 ..................................................................7 2、以oracle用户登录服务器，导入初始化数据 ..................................................................7 3、数据导入完成后，检查数据 ..................................................................................................7 四、开启replicat进程 .............................................................................................................................9 五、比对数据 ........................................................................................................................................... 10
Word 资料
.
一、准备工作
需求：现需要在oracle数据库服务器上重新配置新的ogg的replicat进程接收源端传输的数据文件。
1、检查ogg程序运行情况，停止replicat进程
停止所有replicat进程 stop RQF_WP*
mgr程序保持开启，源端传输数据文件过来能够接收文件。
2、检查ogg程序配置文件
检查ogg全局变量参数文件
view params ./GLOBAL GGSCHEMA ogg
CHECKPOINTTABLE ogg.ckpt 检查mgr配置文件 view params mgr port 7809
dynamicportlist 7815-8000
autorestart er *, retries 5, waitminutes 3
purgeoldextracts ./dirdat/*,usecheckpoints, minkeepdays 5 LAGREPORTHOURS 1 LAGINFOMINUTES 30 LAGCRITICALMINUTES 45
检查没有问题后配置replicat进程和初始化数据
二、配置replicat进程 1、配置replicat进程参数文件
由于这次同步的表比较多，所以总共部署了5个replicat进程 配置RQF_WP1进程： replicat RQF_WP1
SETENV (ORACLE_SID=\
SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8) USERID ogg ,
AACAAAAAAAAAAAOABHCDPGBEKGVDABKFLGLIRCUJZDMANIIG, ENCRYPTKEY DEFAULT
Word 资料
BLOWFISH,
PASSWORD .
REPORT AT 01:59
REPORTROLLOVER AT 02:00 CACHEMGR, CACHESIZE 256MB REPERROR DEFAULT,ABEND
DISCARDFILE ./dirrpt/RQF_WP1.dsc,APPEND,MEGABYTES 100 DISCARDROLLOVER AT 06:00 GETTRUNCATES NUMFILES 3000 EOFDELAYCSECS 30 ASSUMETARGETDEFS ALLOWNOOPUPDATES DYNAMICRESOLUTION GETUPDATEBEFORES NOCOMPRESSDELETES
map GS_CXTJ.DJ_ZRR,target oggsjjg.DJ_ZRR;
map HX_CS_ZDY.CS_ZS_SWJGGKDZB,target oggsjjg.CS_ZS_SWJGGKDZB; map HX_DJ.DJ_NSRCKZHZHXX,target oggsjjg.DJ_NSRCKZHZHXX;
map HX_DJ.DJ_NSRCKZHZHXX_YGZ,target oggsjjg.DJ_NSRCKZHZHXX_YGZ; map HX_DJ.DJ_NSRXX,target oggsjjg.DJ_NSRXX;
map HX_DJ.DJ_NSRXX_KZ,target oggsjjg.DJ_NSRXX_KZ;
map HX_DJ.DJ_NSRXX_KZ_LS,target oggsjjg.DJ_NSRXX_KZ_LS; map HX_DJ.DJ_NSRXX_KZ_YGZ,target oggsjjg.DJ_NSRXX_KZ_YGZ; map HX_DJ.DJ_NSRXX_YGZ,target oggsjjg.DJ_NSRXX_YGZ; map HX_DJ.DJ_PZJGXX,target oggsjjg.DJ_PZJGXX; 配置RQF_WP2进程： replicat RQF_WP2
SETENV (ORACLE_SID=\
SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8) USERID ogg , PASSWORD AACAAAAAAAAAAAOABHCDPGBEKGVDABKFLGLIRCUJZDMANIIG, BLOWFISH, ENCRYPTKEY DEFAULT
REPORT AT 01:59
REPORTROLLOVER AT 02:00 CACHEMGR, CACHESIZE 256MB REPERROR DEFAULT,ABEND
DISCARDFILE ./dirrpt/RQF_WP2.dsc,APPEND,MEGABYTES 100 DISCARDROLLOVER AT 06:00 GETTRUNCATES NUMFILES 3000 EOFDELAYCSECS 30 ASSUMETARGETDEFS ALLOWNOOPUPDATES DYNAMICRESOLUTION GETUPDATEBEFORES
Word 资料
.
NOCOMPRESSDELETES
map HX_DJ.DJ_WTXYS_BWTDZNSRXX,target oggsjjg.DJ_WTXYS_BWTDZNSRXX; map HX_DJ.DJ_WTXYSXX,target oggsjjg.DJ_WTXYSXX; map HX_DM_QG.DM_FP_FPLB,target oggsjjg.DM_FP_FPLB; map HX_DM_QG.DM_FP_FPZL,target oggsjjg.DM_FP_FPZL; map HX_DM_QG.DM_GY_HY,target oggsjjg.DM_GY_HY;
map HX_DM_QG.DM_GY_NSRZT,target oggsjjg.DM_GY_NSRZT; map HX_DM_QG.DM_GY_ZSPM,target oggsjjg.DM_GY_ZSPM; map HX_DM_ZDY.DM_FP_FP,target oggsjjg.DM_FP_FP;
map HX_DM_ZDY.DM_GY_SWJG,target oggsjjg.DM_GY_SWJG; map HX_DM_ZDY.DM_GY_SWRY,target oggsjjg.DM_GY_SWRY; 配置RQF_WP3进程： replicat RQF_WP3
SETENV (ORACLE_SID=\
SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8) USERID ogg , PASSWORD AACAAAAAAAAAAAOABHCDPGBEKGVDABKFLGLIRCUJZDMANIIG, BLOWFISH, ENCRYPTKEY DEFAULT
REPORT AT 01:59
REPORTROLLOVER AT 02:00 CACHEMGR, CACHESIZE 256MB REPERROR DEFAULT,ABEND
DISCARDFILE ./dirrpt/RQF_WP3.dsc,APPEND,MEGABYTES 100 DISCARDROLLOVER AT 06:00 GETTRUNCATES NUMFILES 3000 EOFDELAYCSECS 30 ASSUMETARGETDEFS ALLOWNOOPUPDATES DYNAMICRESOLUTION GETUPDATEBEFORES NOCOMPRESSDELETES
map HX_DM_ZDY.DM_GY_YHYYWD,target oggsjjg.DM_GY_YHYYWD; map HX_FP.FP_DBCKD_MX,target oggsjjg.FP_DBCKD_MX; map HX_FP.FP_DK_FPKJXX,target oggsjjg.FP_DK_FPKJXX; map HX_FP.FP_DK_SQ,target oggsjjg.FP_DK_SQ;
map HX_FP.FP_DK_TYJDFP,target oggsjjg.FP_DK_TYJDFP; map HX_FP.FP_DK_YSYSKMX,target oggsjjg.FP_DK_YSYSKMX; map HX_FP.FP_DK_ZZSFP,target oggsjjg.FP_DK_ZZSFP;
map HX_FP.FP_DK_ZZSFP_HLMX,target oggsjjg.FP_DK_ZZSFP_HLMX;
map HX_FP.FP_DK_ZZS_GHFNSRXX,target oggsjjg.FP_DK_ZZS_GHFNSRXX; map HX_FP.FP_FPKF,target oggsjjg.FP_FPKF; map HX_FP.FP_LY,target oggsjjg.FP_LY; 配置RQF_WP4进程：
Word 资料
.
replicat RQF_WP4
SETENV (ORACLE_SID=\
SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8) USERID ogg ,
AACAAAAAAAAAAAOABHCDPGBEKGVDABKFLGLIRCUJZDMANIIG, ENCRYPTKEY DEFAULT
REPORT AT 01:59
REPORTROLLOVER AT 02:00 CACHEMGR, CACHESIZE 256MB REPERROR DEFAULT,ABEND
DISCARDFILE ./dirrpt/RQF_WP4.dsc,APPEND,MEGABYTES 100 DISCARDROLLOVER AT 06:00 GETTRUNCATES NUMFILES 3000 EOFDELAYCSECS 30 ASSUMETARGETDEFS ALLOWNOOPUPDATES DYNAMICRESOLUTION GETUPDATEBEFORES NOCOMPRESSDELETES
map HX_FP.FP_LY_MX,target oggsjjg.FP_LY_MX; map HX_FP.FP_NSRFPJC,target oggsjjg.FP_NSRFPJC; map HX_FP.FP_PZHDXX,target oggsjjg.FP_PZHDXX;
map HX_FP.FP_PZHDXXZB,target oggsjjg.FP_PZHDXXZB; map HX_FP.FP_SWJGKFKC,target oggsjjg.FP_SWJGKFKC; map HX_FP.FP_TP,target oggsjjg.FP_TP;
map HX_FP.FP_TP_MX,target oggsjjg.FP_TP_MX;
map HX_FP.FP_WLFP_KJXX,target oggsjjg.FP_WLFP_KJXX;
map HX_FP.FP_WLFP_PZHDXX,target oggsjjg.FP_WLFP_PZHDXX; map HX_FP.FP_WLFP_SFZRDXXB,target oggsjjg.FP_WLFP_SFZRDXXB; 配置RQF_WP5进程： replicat RQF_WP5
SETENV (ORACLE_SID=\
SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8) USERID ogg ,
AACAAAAAAAAAAAOABHCDPGBEKGVDABKFLGLIRCUJZDMANIIG, ENCRYPTKEY DEFAULT
REPORT AT 01:59
REPORTROLLOVER AT 02:00 CACHEMGR, CACHESIZE 256MB REPERROR DEFAULT,ABEND
DISCARDFILE ./dirrpt/RQF_WP5.dsc,APPEND,MEGABYTES 100 DISCARDROLLOVER AT 06:00 GETTRUNCATES
Word 资料
PASSWORD BLOWFISH,
PASSWORD BLOWFISH,
ogg程序replicat进程部署文档
