gg安装文档1.docx
- 文档编号:11116947
- 上传时间:2023-05-29
- 格式:DOCX
- 页数:11
- 大小:64.69KB
gg安装文档1.docx
《gg安装文档1.docx》由会员分享,可在线阅读,更多相关《gg安装文档1.docx(11页珍藏版)》请在冰点文库上搜索。
gg安装文档1
1.1营销/95598数据库复制
1.1.1实施步骤简述
生产端
◆开启归档;
◆开启强制日志、数据库级最小补充日志;
◆创建goldengate表空间及goldengate用户,授权dba
◆安装GG,基本配置;
◆添加表级补充日志;
◆创建MGR、抽取进程、投递进程、本地队列和远程队列;
◆启动MGR、抽取进程
◆RMAN备份,记录listbackup中最新归档的first_scn;
容灾端
◆RMAN恢复至listbackup中最新归档的first_scn;
◆创建MGR、复制进程、checkpointtable
◆启动MGR
◆启动生产端投递进程、复制进程aftercsnfirst_scn;
1.1.2生产端实施步骤
1.1.2.1开启归档
SQL>shutdownimmediate
SQL>startupmount;
SQL>alterdatabasearchivelog;
SQL>archivelogstart;
SQL>altersystemsetlog_archive_dest_1='location=/arch1';
SQL>altersystemsetlog_archive_dest_2='location=/arch2';
SQL>alterdatabaseopen;
SQL>archiveloglist;
SQL>altersystemarchivelogcurrent;
1.1.2.2开启强制日志、数据库级最小补充日志
SQL>alterdatabaseforcelgoldengateing;
SQL>selectsupplemental_log_data_minfromv$database;
SQL>alterdatabaseaddsupplementallogdata;
SQL>altersystemarchivelogcurrent;
1.1.2.3创建goldengate表空间及goldengate用户,授权dba
SQL>CREATEUSERgoldengateIDENTIFIEDBYgoldengatedefaulttablespaceuserstemporarytablespacetempquotaunlimitedonusers;
SQL>grantdbatogoldengate;
1.1.2.4安装goldengate,基本配置
解压goldengate压缩包到/goldengate
tar–xvfgoldengate.tar
cd/goldengate
ggsci
1.1.2.5添加表级补充日志
ggsci>dbloginuseridgoldengate,passwordgoldengate
ggsci>ADDTRANDATAEPM_HIS_MD.*
ggsci>ADDTRANDATAFLOW_MD.*
ggsci>ADDTRANDATAEPM_BANK_MD.*
ggsci>ADDTRANDATAEPM_DE_MD.*
ggsci>ADDTRANDATAEPM_RPT_MD.*
ggsci>ADDTRANDATAXEPMA_MD.*
ggsci>ADDTRANDATAEPM_ERP_MD.*
ggsci>ADDTRANDATAEPM_MD.*
ggsci>ADDTRANDATAEPM_SEC.*
ggsci>ADDTRANDATAEPC_MD.*
ggsci>ADDTRANDATAEPM_LOADC_MD.*
ggsci>ADDTRANDATAEPSA_MD.*
ggsci>ADDTRANDATASYSODM.*
ggsci>ADDTRANDATAEPM_CP.*
ggsci>ADDTRANDATAEPM_IC_MD.*
查看是否还有表没有添加补充日志
SQL>selecttable_namefromall_tableswhereownerin('EPM_RPT_MD','EPM_LOADC_MD','XEPMA_MD','EPM_DE_MD','EPM_ERP_MD','EPSA_MD','EPM_BANK_MD','SYSODM','EPC_MD','FLOW_MD','EPM_HIS_MD','EPM_CP','EPM_MD','EPM_IC_MD','EPM_SEC')andtable_namenotin(selectdistincttable_namefromdba_log_group_columnswhereownerin('EPM_RPT_MD','EPM_LOADC_MD','XEPMA_MD','EPM_DE_MD','EPM_ERP_MD','EPSA_MD','EPM_BANK_MD','SYSODM','EPC_MD','FLOW_MD','EPM_HIS_MD','EPM_CP','EPM_MD','EPM_IC_MD','EPM_SEC'));
再次执行添加
ggsci>addtrandataschema.table_name
1.1.2.6创建MGR进程及配置文件
ggsci>editparamsmgr
1.1.2.7创建抽取进程,配置抽取数据源和本地队列
GGSCI>ADDEXTRACTextya,TRANLOG,BEGINNOW
GGSCI>ADDEXTTRAIL./dirdat/ya,EXTRACTextya,megabytes200
GGSCI>editextya
GGSCI>ADDEXTRACTextyb,TRANLOG,BEGINNOW
GGSCI>ADDEXTTRAIL./dirdat/yb,EXTRACTextyb,megabytes200
GGSCI>editextyb
GGSCI>ADDEXTRACTextyc,TRANLOG,BEGINNOW
GGSCI>ADDEXTTRAIL./dirdat/yc,EXTRACTextyc,megabytes200
GGSCI>editextyc
GGSCI>ADDEXTRACTextyd,TRANLOG,BEGINNOW
GGSCI>ADDEXTTRAIL./dirdat/yd,EXTRACTextyd,megabytes200
GGSCI>editextyd
GGSCI>ADDEXTRACTextye,TRANLOG,BEGINNOW
GGSCI>ADDEXTTRAIL./dirdat/ye,EXTRACTextye,megabytes200
GGSCI>editextye
GGSCI>ADDEXTRACTextyf,TRANLOG,BEGINNOW
GGSCI>ADDEXTTRAIL./dirdat/yf,EXTRACTextyf,megabytes200
GGSCI>editextyf
1.1.2.8创建投递进程,配置投递进程数据源和远程队列
ggsci>addextractdpeya,exttrailsource./dirdat/ya
ggsci>addrmttrail./dirdat/ya,extractdpeya,megabytes200
ggsci>editparamsdpeya
ggsci>addextractdpeyb,exttrailsource./dirdat/yb
ggsci>addrmttrail./dirdat/yb,extractdpeyb,megabytes200
ggsci>editparamsdpeyb
ggsci>addextractdpeyc,exttrailsource./dirdat/yc
ggsci>addrmttrail./dirdat/yc,extractdpeyc,megabytes200
ggsci>editparamsdpeyc
ggsci>addextractdpeyd,exttrailsource./dirdat/yd
ggsci>addrmttrail./dirdat/yd,extractdpeyd,megabytes200
ggsci>editparamsdpeyd
ggsci>addextractdpeye,exttrailsource./dirdat/ye
ggsci>addrmttrail./dirdat/ye,extractdpeye,megabytes200
ggsci>editparamsdpeye
ggsci>addextractdpeyf,exttrailsource./dirdat/yf
ggsci>addrmttrail./dirdat/yf,extractdpeyf,megabytes200
ggsci>editparamsdpeyf
1.1.2.9开启MGR和抽取进程
ggsci>startmgr
ggsci>startexty*
1.1.2.10RMAN全备
RMAN>run{
allocatechannelch00devicetypediskmaxpiecesize=10240mformat'/goldengate/backup/bk_%d_%T_%U';
backupdatabase;
sql'altersystemarchivelogcurrent';
releasechannelch00;
backupspfileformat'/goldengate/backup/spfile.bak';
#backupallarchivelogs
allocatechannelch01devicetypedisk;
backuparchivelogallformat'/goldengate/backup/al_%d_%T_%U';
RELEASECHANNELch01;
#backupcontrolfile
allocatechannelch00devicetypedisk;
backupcurrentcontrolfileformat'/goldengate/backup/ctl_%d_%T_%U';
releasechannelch00;
}
记录备份完成的时间xxxx-xx-xxhh:
mm,定位容灾中心恢复的指定SCN:
selectCHECKPOINT_CHANGE#,CHECKPOINT_TIMEfromv$datafile_header;
生产端实施完毕。
复制备份文件到容灾端。
1.1.3容灾端实施步骤
1
1.1
1.1.1
1.1.2
1.1.3
1.1.3.1使用oradim创建服务,创建密码文件,配置监听
$oradim–new–sidpmmdpdb
$setORACLE_SID=pmmdpdb
$orapwdfile=***password=****
$netca配置监听
1.1.3.2使用dummy实例恢复spfile
$>RMANTARGET/
RMAN>startupnomount;
RMAN>restorespfilefrom‘path:
bakfilename’;
RMAN>shutdownimmediate
1.1.3.3创建(修改)spfilestat.ora中dump,archivelog,controlfile等路径,并启动stat实例到mount,并修改数据库为非归档模式
$RMANTARGET/
RMAN>startupnomount;
RMAN>restorecontrolfilefrom‘path:
ctlfilename’;
RMAN>sql‘alterdatabasemount’
1.1.3.4创建数据文件存放路径,恢复数据文件并执行介质恢复
RMAN>restoredatabase;
RMAN>recoverdatabaseuntilscnfirst_scn;
SQL>alterdatabasenoarchivelog;
SQL>archivelogstop;
查看控制文件头和数据文件头SCN是否以恢复至first_scn值
SQL>selectcheckpoint_change#fromv$datafile;
SQL>selectcheckpoint_change#fromv$datafile_header;
SQL>alterdatabaseopenresetlogs;
1.1.3.5添加临时表空间数据文件
altertablespacetemptempfile‘/oracle/oradata/stat\temp01.dbf’size50m;
1.1.3.6禁用触发器和外键
禁用触发器
declare
v_sqlvarchar2(2000);
CURSORc_triggerISSELECT'altertrigger'||owner||'.'||trigger_name||'disable'fromdba_triggerswhereownerin('EPM_RPT_MD','EPM_LOADC_MD','XEPMA_MD','EPM_DE_MD','EPM_ERP_MD','EPSA_MD','EPM_BANK_MD','SYSODM','EPC_MD','FLOW_MD','EPM_HIS_MD','EPM_CP','EPM_MD','EPM_IC_MD','EPM_SEC');
BEGIN
OPENc_trigger;
LOOP
FETCHc_triggerINTOv_sql;
EXITWHENc_trigger%NOTFOUND;
executeimmediatev_sql;
endloop;
closec_trigger;
end;
/
禁用外键
declare
v_sqlvarchar2(2000);
CURSORc_triggerISSELECT'altertable'||owner||'.'||table_name||'disableconstraint'||constraint_namefromdba_constraintswhereconstraint_type='R'andownerin('EPM_RPT_MD','EPM_LOADC_MD','XEPMA_MD','EPM_DE_MD','EPM_ERP_MD','EPSA_MD','EPM_BANK_MD','SYSODM','EPC_MD','FLOW_MD','EPM_HIS_MD','EPM_CP','EPM_MD','EPM_IC_MD','EPM_SEC');
BEGIN
OPENc_trigger;
LOOP
FETCHc_triggerINTOv_sql;
EXITWHENc_trigger%NOTFOUND;
executeimmediatev_sql;
endloop;
closec_trigger;
end;
/
1.1.3.7安装goldengate,基本配置
解压goldengate压缩包到/goldengate
tar–xvfgoldengate.tar
cd/goldengate
ggsci
1.1.3.8创建MGR
ggsci>editparamsmgr
1.1.3.9创建复制进程
ggsci>EDITPARAMS./GLOBALS
CHECKPOINTTABLEgoldengate.ggschkpt
ggsci>dbloginuseridgoldengate,passwordgoldengate
ggsci>addcheckpointtablegoldengate.ggschkpt
ggsci>addreplicatrepya,exttrail./dirdat/ya
ggsci>editparamsrepay
ggsci>addreplicatrepyb,exttrail./dirdat/yb
ggsci>editparamsrepyb
ggsci>addreplicatrepyc,exttrail./dirdat/yc
ggsci>editparamsrepyc
ggsci>addreplicatrepyd,exttrail./dirdat/yd
ggsci>editparamsrepyd
ggsci>addreplicatrepye,exttrail./dirdat/ye
ggsci>editparamsrepye
ggsci>addreplicatrepyf,exttrail./dirdat/yf
ggsci>editparamsrepyf
1.1.3.10开始投递进程,复制进程,进行同步
容灾端:
ggsci>startmgr
生产端:
ggsci>startdpey*
容灾端:
ggsci>startrepy*aftercsnfirst_scn;
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- gg 安装 文档
![提示](https://static.bingdoc.com/images/bang_tan.gif)