ogg程序replicat进程部署文档教学提纲.docx
《ogg程序replicat进程部署文档教学提纲.docx》由会员分享，可在线阅读，更多相关《ogg程序replicat进程部署文档教学提纲.docx（11页珍藏版）》请在冰点文库上搜索。
ogg程序replicat进程部署文档教学提纲
ogg程序replicat进程部署文档
OGG程序replicat进程部署文档
一、准备工作
需求：
现需要在oracle数据库服务器上重新配置新的ogg的replicat进程接收源端传输的数据文件。
1、检查ogg程序运行情况，停止replicat进程
停止所有replicat进程stopRQF_WP*
mgr程序保持开启，源端传输数据文件过来能够接收文件。
2、检查ogg程序配置文件
检查ogg全局变量参数文件
viewparams./GLOBAL
GGSCHEMAogg
CHECKPOINTTABLEogg.ckpt
检查mgr配置文件
viewparamsmgr
port7809
dynamicportlist7815-8000
autorestarter*,retries5,waitminutes3
purgeoldextracts./dirdat/*,usecheckpoints,minkeepdays5
LAGREPORTHOURS1
LAGINFOMINUTES30
LAGCRITICALMINUTES45
检查没有问题后配置replicat进程和初始化数据
二、配置replicat进程
1、配置replicat进程参数文件
由于这次同步的表比较多，所以总共部署了5个replicat进程
配置RQF_WP1进程：
replicatRQF_WP1
SETENV（ORACLE_SID="wpracdb1"）
SETENV（NLS_LANG=AMERICAN_AMERICA.AL32UTF8）
USERIDogg,PASSWORDAACAAAAAAAAAAAOABHCDPGBEKGVDABKFLGLIRCUJZDMANIIG,BLOWFISH,ENCRYPTKEYDEFAULT
REPORTAT01:
59
REPORTROLLOVERAT02:
00
CACHEMGR,CACHESIZE256MB
REPERRORDEFAULT,ABEND
DISCARDFILE./dirrpt/RQF_WP1.dsc,APPEND,MEGABYTES100
DISCARDROLLOVERAT06:
00
GETTRUNCATES
NUMFILES3000
EOFDELAYCSECS30
ASSUMETARGETDEFS
ALLOWNOOPUPDATES
DYNAMICRESOLUTION
GETUPDATEBEFORES
NOCOMPRESSDELETES
mapGS_CXTJ.DJ_ZRR,targetoggsjjg.DJ_ZRR;
mapHX_CS_ZDY.CS_ZS_SWJGGKDZB,targetoggsjjg.CS_ZS_SWJGGKDZB;
mapHX_DJ.DJ_NSRCKZHZHXX,targetoggsjjg.DJ_NSRCKZHZHXX;
mapHX_DJ.DJ_NSRCKZHZHXX_YGZ,targetoggsjjg.DJ_NSRCKZHZHXX_YGZ;
mapHX_DJ.DJ_NSRXX,targetoggsjjg.DJ_NSRXX;
mapHX_DJ.DJ_NSRXX_KZ,targetoggsjjg.DJ_NSRXX_KZ;
mapHX_DJ.DJ_NSRXX_KZ_LS,targetoggsjjg.DJ_NSRXX_KZ_LS;
mapHX_DJ.DJ_NSRXX_KZ_YGZ,targetoggsjjg.DJ_NSRXX_KZ_YGZ;
mapHX_DJ.DJ_NSRXX_YGZ,targetoggsjjg.DJ_NSRXX_YGZ;
mapHX_DJ.DJ_PZJGXX,targetoggsjjg.DJ_PZJGXX;
配置RQF_WP2进程：
replicatRQF_WP2
SETENV（ORACLE_SID="wpracdb1"）
SETENV（NLS_LANG=AMERICAN_AMERICA.AL32UTF8）
USERIDogg,PASSWORDAACAAAAAAAAAAAOABHCDPGBEKGVDABKFLGLIRCUJZDMANIIG,BLOWFISH,ENCRYPTKEYDEFAULT
REPORTAT01:
59
REPORTROLLOVERAT02:
00
CACHEMGR,CACHESIZE256MB
REPERRORDEFAULT,ABEND
DISCARDFILE./dirrpt/RQF_WP2.dsc,APPEND,MEGABYTES100
DISCARDROLLOVERAT06:
00
GETTRUNCATES
NUMFILES3000
EOFDELAYCSECS30
ASSUMETARGETDEFS
ALLOWNOOPUPDATES
DYNAMICRESOLUTION
GETUPDATEBEFORES
NOCOMPRESSDELETES
mapHX_DJ.DJ_WTXYS_BWTDZNSRXX,targetoggsjjg.DJ_WTXYS_BWTDZNSRXX;
mapHX_DJ.DJ_WTXYSXX,targetoggsjjg.DJ_WTXYSXX;
mapHX_DM_QG.DM_FP_FPLB,targetoggsjjg.DM_FP_FPLB;
mapHX_DM_QG.DM_FP_FPZL,targetoggsjjg.DM_FP_FPZL;
mapHX_DM_QG.DM_GY_HY,targetoggsjjg.DM_GY_HY;
mapHX_DM_QG.DM_GY_NSRZT,targetoggsjjg.DM_GY_NSRZT;
mapHX_DM_QG.DM_GY_ZSPM,targetoggsjjg.DM_GY_ZSPM;
mapHX_DM_ZDY.DM_FP_FP,targetoggsjjg.DM_FP_FP;
mapHX_DM_ZDY.DM_GY_SWJG,targetoggsjjg.DM_GY_SWJG;
mapHX_DM_ZDY.DM_GY_SWRY,targetoggsjjg.DM_GY_SWRY;
配置RQF_WP3进程：
replicatRQF_WP3
SETENV（ORACLE_SID="wpracdb1"）
SETENV（NLS_LANG=AMERICAN_AMERICA.AL32UTF8）
USERIDogg,PASSWORDAACAAAAAAAAAAAOABHCDPGBEKGVDABKFLGLIRCUJZDMANIIG,BLOWFISH,ENCRYPTKEYDEFAULT
REPORTAT01:
59
REPORTROLLOVERAT02:
00
CACHEMGR,CACHESIZE256MB
REPERRORDEFAULT,ABEND
DISCARDFILE./dirrpt/RQF_WP3.dsc,APPEND,MEGABYTES100
DISCARDROLLOVERAT06:
00
GETTRUNCATES
NUMFILES3000
EOFDELAYCSECS30
ASSUMETARGETDEFS
ALLOWNOOPUPDATES
DYNAMICRESOLUTION
GETUPDATEBEFORES
NOCOMPRESSDELETES
mapHX_DM_ZDY.DM_GY_YHYYWD,targetoggsjjg.DM_GY_YHYYWD;
mapHX_FP.FP_DBCKD_MX,targetoggsjjg.FP_DBCKD_MX;
mapHX_FP.FP_DK_FPKJXX,targetoggsjjg.FP_DK_FPKJXX;
mapHX_FP.FP_DK_SQ,targetoggsjjg.FP_DK_SQ;
mapHX_FP.FP_DK_TYJDFP,targetoggsjjg.FP_DK_TYJDFP;
mapHX_FP.FP_DK_YSYSKMX,targetoggsjjg.FP_DK_YSYSKMX;
mapHX_FP.FP_DK_ZZSFP,targetoggsjjg.FP_DK_ZZSFP;
mapHX_FP.FP_DK_ZZSFP_HLMX,targetoggsjjg.FP_DK_ZZSFP_HLMX;
mapHX_FP.FP_DK_ZZS_GHFNSRXX,targetoggsjjg.FP_DK_ZZS_GHFNSRXX;
mapHX_FP.FP_FPKF,targetoggsjjg.FP_FPKF;
mapHX_FP.FP_LY,targetoggsjjg.FP_LY;
配置RQF_WP4进程：
replicatRQF_WP4
SETENV（ORACLE_SID="wpracdb1"）
SETENV（NLS_LANG=AMERICAN_AMERICA.AL32UTF8）
USERIDogg,PASSWORDAACAAAAAAAAAAAOABHCDPGBEKGVDABKFLGLIRCUJZDMANIIG,BLOWFISH,ENCRYPTKEYDEFAULT
REPORTAT01:
59
REPORTROLLOVERAT02:
00
CACHEMGR,CACHESIZE256MB
REPERRORDEFAULT,ABEND
DISCARDFILE./dirrpt/RQF_WP4.dsc,APPEND,MEGABYTES100
DISCARDROLLOVERAT06:
00
GETTRUNCATES
NUMFILES3000
EOFDELAYCSECS30
ASSUMETARGETDEFS
ALLOWNOOPUPDATES
DYNAMICRESOLUTION
GETUPDATEBEFORES
NOCOMPRESSDELETES
mapHX_FP.FP_LY_MX,targetoggsjjg.FP_LY_MX;
mapHX_FP.FP_NSRFPJC,targetoggsjjg.FP_NSRFPJC;
mapHX_FP.FP_PZHDXX,targetoggsjjg.FP_PZHDXX;
mapHX_FP.FP_PZHDXXZB,targetoggsjjg.FP_PZHDXXZB;
mapHX_FP.FP_SWJGKFKC,targetoggsjjg.FP_SWJGKFKC;
mapHX_FP.FP_TP,targetoggsjjg.FP_TP;
mapHX_FP.FP_TP_MX,targetoggsjjg.FP_TP_MX;
mapHX_FP.FP_WLFP_KJXX,targetoggsjjg.FP_WLFP_KJXX;
mapHX_FP.FP_WLFP_PZHDXX,targetoggsjjg.FP_WLFP_PZHDXX;
mapHX_FP.FP_WLFP_SFZRDXXB,targetoggsjjg.FP_WLFP_SFZRDXXB;
配置RQF_WP5进程：
replicatRQF_WP5
SETENV（ORACLE_SID="wpracdb1"）
SETENV（NLS_LANG=AMERICAN_AMERICA.AL32UTF8）
USERIDogg,PASSWORDAACAAAAAAAAAAAOABHCDPGBEKGVDABKFLGLIRCUJZDMANIIG,BLOWFISH,ENCRYPTKEYDEFAULT
REPORTAT01:
59
REPORTROLLOVERAT02:
00
CACHEMGR,CACHESIZE256MB
REPERRORDEFAULT,ABEND
DISCARDFILE./dirrpt/RQF_WP5.dsc,APPEND,MEGABYTES100
DISCARDROLLOVERAT06:
00
GETTRUNCATES
NUMFILES3000
EOFDELAYCSECS30
ASSUMETARGETDEFS
ALLOWNOOPUPDATES
DYNAMICRESOLUTION
GETUPDATEBEFORES
NOCOMPRESSDELETES
mapHX_FP.FP_YZJH,targetoggsjjg.FP_YZJH;
mapHX_FP.FP_YZJHFP,targetoggsjjg.FP_YZJHFP;
mapHX_FP.FP_YZJHFP_MX,targetoggsjjg.FP_YZJHFP_MX;
mapHX_FP.FP_YZRKXX,targetoggsjjg.FP_YZRKXX;
mapHX_FP.FP_YZYBDWMCFPBAXX,targetoggsjjg.FP_YZYBDWMCFPBAXX;
mapHX_QX.DM_QX_SWRYSF,targetoggsjjg.DM_QX_SWRYSF;
mapHX_RD.RD_NSRZGXX_JGB,targetoggsjjg.RD_NSRZGXX_JGB;
mapHX_RD.RD_NSRZGXX_JGB_YGZ,targetoggsjjg.RD_NSRZGXX_JGB_YGZ;
mapHX_RD.RD_SFZRDXXB,targetoggsjjg.RD_SFZRDXXB;
mapHX_RD.RD_SFZRDXXB_YGZ,targetoggsjjg.RD_SFZRDXXB_YGZ;
mapHX_SB.SB_SBXX,targetoggsjjg.SB_SBXX;
mapHX_ZS.ZS_HD_DQDEHD_JG,targetoggsjjg.ZS_HD_DQDEHD_JG;
mapHX_ZS.ZS_HD_DQDEHD_JG_YGZ,targetoggsjjg.ZS_HD_DQDEHD_JG_YGZ;
mapHX_ZS.ZS_YJSF,targetoggsjjg.ZS_YJSF;
注：
在配置replicat进程时ogg用户密码是加密了，加密的方法如下：
encryptpasswordAACAAAAAAAAAAA,encryptkeydefault
在ggsci上运行，其中AACAAAAAAAAAAA为ogg用户的密码
2、重新添加replicat进程
由于传送数据文件名的格式发生了变化，故需要删除以前进程，重新创建进程
登录数据库
dbloginuseridogg,passwordAACAAAAAAAAAAA
删除历史进程
deletereplicatRQF_WP1
deletereplicatRQF_WP2
deletereplicatRQF_WP3
deletereplicatRQF_WP4
添加新进程（新的数据文件名格式为zt开头）
addreplicatRQF_WP1,exttrail/app/ogg/dirdat/zt,checkpointtableogg.ckpt
addreplicatRQF_WP2,exttrail/app/ogg/dirdat/zt,checkpointtableogg.ckpt
addreplicatRQF_WP3,exttrail/app/ogg/dirdat/zt,checkpointtableogg.ckpt
addreplicatRQF_WP4,exttrail/app/ogg/dirdat/zt,checkpointtableogg.ckpt
历史进程只有4个，现部署了5个进程，所以还需添加一个进程
addreplicatRQF_WP5,exttrail/app/ogg/dirdat/zt,checkpointtableogg.ckpt
三、初始化数据
1、在数据库服务器上创建新的用户名存放数据
创建表空间文件，导入的数据量比较大，故需要多创建几个表空间文件
CreatetablespaceOGGSJJG_DATAdatafile‘+ORA_DATA/wpracdb/datafile/oggsjjg_data_01.dbf'size20G
autoextendonnext500Mmaxsize31G;
altertablespaceOGGSJJG_DATAadddatafile
‘+ORA_DATA/wpracdb/datafile/oggsjjg_data_02.dbf'size20G
autoextendonnext500Mmaxsize31G;
altertablespaceOGGSJJG_DATAadddatafile
‘+ORA_DATA/wpracdb/datafile/oggsjjg_data_03.dbf'size20G
autoextendonnext500Mmaxsize31G;
创建新用户
createuseroggsjjgidentifiedbyoggsjjgtablespaceOGGSJJG_DATA；
创建目录及授权
createdirectoryDP_DATAas'/app/ogg/dirdat/';
grantread,writeondirectoryDP_DATAtooggsjjg;
2、以oracle用户登录服务器，导入初始化数据
impdpoggsjjg/oggsjjgdirectory=DP_DATAdumpfile=yj1001.dmp
logfile=impdp_`date+%Y%m%d%H`.log
remap_schema=GS_CXTJ:
OGGSJJG,HX_CS_ZDY:
OGGSJJG,HX_DJ:
OGGSJJG,HX_DM_QG:
OGGSJJG,HX_DM_ZDY:
OGGSJJG,HX_FP:
OGGSJJG,HX_QX:
OGGSJJG,HX_RD:
OGGSJJG,HX_SB:
OGGSJJG,HX_ZS:
OGGSJJG
remap_tablespace=TS_GS_CXTJ_DATA:
OGGSJJG_DATA,TS_HX_DJ_DATA:
OGGSJJG_DATA,TS_HX_DM_DATA:
OGGSJJG_DATA,TS_HX_FPFX_DATA:
OGGSJJG_DATA,TS_HX_SB_DATA:
OGGSJJG_DATA,TS_HX_ZS_DATA:
OGGSJJG_DATA,TS_HX_DJ_IDX:
OGGSJJG_DATA,TS_HX_DM_IDX:
OGGSJJG_DATA,TS_HX_FPFX_IDX:
OGGSJJG_DATA,TS_HX_SB_IDX:
OGGSJJG_DATA,TS_HX_ZS_IDX:
OGGSJJG_DATA
table_exists_action=replacecluster=noparallel=16;
3、数据导入完成后，检查数据
统计oggsjjg用户下导入表的条数和源库中表的条数进行比对
统计源库的表名如下
HX_DJ.DJ_NSRCKZHZHXX
HX_DJ.DJ_NSRXX_KZ
HX_DJ.DJ_NSRXX_KZ_LS
HX_DJ.DJ_NSRXX
HX_DJ.DJ_PZJGXX
HX_DJ.DJ_WTXYSXX
HX_QX.DM_QX_SWRYSF
HX_FP.FP_DK_FPKJXX
HX_FP.FP_DK_YSYSKMX
HX_FP.FP_DK_SQ
HX_FP.FP_DK_ZZSFP
HX_FP.FP_FPKF
HX_FP.FP_LY
HX_FP.FP_LY_MX
HX_FP.FP_PZHDXXZB
HX_RD.RD_SFZRDXXB
HX_SB.SB_SBXX
HX_ZS.ZS_YJSF
HX_DM_ZDY.DM_FP_FP
HX_DM_QG.DM_FP_FPLB
HX_DM_QG.DM_FP_FPZL
HX_DM_QG.DM_GY_HY
HX_DM_QG.DM_GY_NSRZT
HX_DM_ZDY.DM_GY_SWJG
HX_DM_ZDY.DM_GY_SWRY
HX_DM_ZDY.DM_GY_YHYYWD
HX_DM_QG.DM_GY_ZSPM
HX_FP.FP_DK_TYJDFP
HX_FP.FP_DK_ZZS_GHFNSRXX
HX_FP.FP_DK_ZZSFP_HLMX
HX_FP.FP_NSRFPJC
HX_FP.FP_PZHDXX
HX_FP.FP_SWJGKFKC
HX_FP.FP_TP
HX_FP.FP_TP_MX
HX_RD.RD_NSRZGXX_JGB
HX_ZS.ZS_HD_DQDEHD_JG
HX_RD.RD_SFZRDXXB_YGZ
HX_RD.RD_NSRZGXX_JGB_YGZ
HX_DM_QG.DM_FP_FPZL
HX_DM_ZDY.DM_FP_FP
HX_FP.FP_WLFP_KJXX
HX_DJ.DJ_NSRCKZHZHXX_YGZ
HX_DJ.DJ_NSRXX_KZ_YGZ
HX_DJ.DJ_NSRXX_YGZ
HX_ZS.ZS_HD_DQDEHD_JG_YGZ
HX_FP.FP_DBCKD_MX
HX_FP.FP_SWJGKFKC
HX_FP.FP_YZJHFP
HX_FP.FP_YZJHFP_MX
HX_FP.FP_YZJH
HX_FP.FP_YZRKXX
HX_FP.FP_YZYBDWMCFPBAXX
HX_FP.FP_WLFP_PZHDXX
HX_FP.FP_WLFP_SFZRDXXB
HX_DJ.DJ_WTXYS_BWTDZNSRXX
HX_CS_ZDY.CS_ZS_SWJGGKDZB
四、开启replicat进程
因源端忘记修改目标端IP地址导致ogg数据文件传送到其他主机，故需要将文件手工复制到本机来：
scporacle@98.12.10.215:
/app/oracle/ogg/dirdat/zt00028*/app/ogg/dirdat
scporacle@98.12.10.215:
/app/oracle/ogg/dirdat/zt000290/app/ogg/dirdat
修改replicat进程复制的起始文件
alterreplicatRQF_WP1,extseqno000284,extrba0
alterreplicatRQF_WP2,extseqno000284,extrba0
alterreplicatRQF_WP3,extseqno000284,extrba0
alterreplicatRQF_WP4,extseqno000284,extrba0
alterreplicatRQF_WP5,extseqno000284,extrba0
开启replicat进程，注意需要加上scn号
startRQF_WP1,aftercs
升级会员 