ogg程序replicat进程部署文档教学提纲Word文档格式.docx
- 文档编号:18567650
- 上传时间:2022-12-28
- 格式:DOCX
- 页数:11
- 大小:18.08KB
ogg程序replicat进程部署文档教学提纲Word文档格式.docx
《ogg程序replicat进程部署文档教学提纲Word文档格式.docx》由会员分享,可在线阅读,更多相关《ogg程序replicat进程部署文档教学提纲Word文档格式.docx(11页珍藏版)》请在冰豆网上搜索。
二、配置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:
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
DISCARDFILE./dirrpt/RQF_WP2.dsc,APPEND,MEGABYTES100
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
DISCARDFILE./dirrpt/RQF_WP3.dsc,APPEND,MEGABYTES100
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
DISCARDFILE./dirrpt/RQF_WP4.dsc,APPEND,MEGABYTES100
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
DISCARDFILE./dirrpt/RQF_WP5.dsc,APPEND,MEGABYTES100
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'
‘+ORA_DATA/wpracdb/datafile/oggsjjg_data_03.dbf'
创建新用户
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_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_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
/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
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- ogg 程序 replicat 进程 部署 文档 教学 提纲