Oracle 11g 安装配置GoldenGateWord文件下载.docx
- 文档编号:20017529
- 上传时间:2023-01-15
- 格式:DOCX
- 页数:14
- 大小:19.49KB
Oracle 11g 安装配置GoldenGateWord文件下载.docx
《Oracle 11g 安装配置GoldenGateWord文件下载.docx》由会员分享,可在线阅读,更多相关《Oracle 11g 安装配置GoldenGateWord文件下载.docx(14页珍藏版)》请在冰豆网上搜索。
GGSCHEMAggs
NOTE:
'
ggs'
istheexampleOGGuserandwillbeusedintherestofthisdocument.
EDITPARAMSmgr
AddthefollowinglinestoManagerparameterfile:
PORT7809
AUTOSTARTER*
AUTORESTARTER*
STARTmgr
5)在目标端重复上面的步骤1-4,注意目录名的使用,我们在目标端使用/mycloudfs/goldengate以示区分。
第三阶段:
源和目标RAC数据库准备步骤
1)CreateOGGuser'
onboththesourceandtargetdatabase,connecttodatabaseusingSQL*PlusasSYSDBA:
SQL>
CREATEUSERggsIDENTIFIEDBYggs;
GRANTCONNECT,RESOURCE,DBATOggs;
2)(optional,addOraclesequencereplicationsupport)Onbothsourceandtargetdatabase,gotoOGGdirectoryandrunthisSQL,enterOGGuser'
asprompted:
@sequence.sql
3)EnablesupplementalloggingonsourceODAdatabase:
ALTERDATABASEADDSUPPLEMENTALLOGDATA;
ALTERDATABASEADDSUPPLEMENTALLOGDATA(PRIMARYKEY)COLUMNS;
ALTERDATABASEADDSUPPLEMENTALLOGDATA(UNIQUE)COLUMNS;
ALTERDATABASEADDSUPPLEMENTALLOGDATA(FOREIGNKEY)COLUMNS;
ALTERSYSTEMSWITCHLOGFILE;
(Optional)AddOracleDDLreplicationsupport
4)Onthesourcesystem,gotoOGGdirectory,connecttodatabaseusingSQL*PlusasSYSDBA.
GRANTEXECUTEONutl_fileTOggs;
5Onthesourcesystem,runthefollowingscript,provideOGGuser'
asprompted.
@marker_setup.sql
@ddl_setup.sql
enter'
INITIALSETUP'
whenpromptedforthemodeofinstallation.
@role_setup.sql
@ddl_enable.sql
@ddl_pinggs
hereistheOGGuser.
第四阶段:
配置源端的extractgroup
1)Issuethefollowingcommandtologontothedatabase.
DBLOGINUSERIDggs,PASSWORDggs
2)CreateaprimaryExtractgroup'
myext'
:
ADDEXTRACTmyext,TRANLOG,BEGINNOW,THREADS2
THREADSvalueisthenumberofyourRACinstances.
3)Createalocaltrail.TheprimaryExtractwritestothistrail,andthedata-pumpExtractreadsit.
ADDEXTTRAIL/cloudfs/goldengate/dirdat/et,EXTRACTmyext
et'
istheexampletrailidentifierforExtract'
.
4)CreateandedittheparameterfileforExtract'
EDITPARAMSmyext
Addfollowinglinestothisparameterfile:
EXTRACTmyext
SETENV(ORACLE_HOME="
/u01/app/oracle/product/11.2.0/dbhome_1"
)
USERIDggs@ggdb,PASSWORDggs
TRANLOGOPTIONSDBLOGREADER
THREADOPTIONSMAXCOMMITPROPAGATIONDELAY20000
EXTTRAIL/cloudfs/goldengate/dirdat/et
DYNAMICRESOLUTION
DDLINCLUDEALL
TABLEhr.*;
NOTE1:
makesuretheSQL*Netconnectionstring'
ggdb'
works.
NOTE2:
hr'
istheexampleschemawhichwillbesynchronizedtothetargetsystem.
第五阶段:
在源端配置datapumpextractgroup
1)Createadatapumpgroup'
mypump'
ADDEXTRACTmypump,EXTTRAILSOURCE/cloudfs/goldengate/dirdat/et,BEGINnow
2)Specifyaremotetrailthatwillbecreatedonthetargetsystem.
ADDRMTTRAIL/mycloudfs/goldengate/dirdat/rt,EXTRACTmypump
rt'
andusethetargetOGGdirectory'
/mycloudfs/goldengate'
here.
3)CreateandedittheparameterfileforExtract'
EDITPARAMSmypump
EXTRACTmypump
RMTHOSTrac12box-scan,MGRPORT7809
RMTTRAIL/mycloudfs/goldengate/dirdat/rt
PASSTHRU
RMTHOSTisthetargethost.IfyoualsoprefertosetupHAonthetargetsystem,specifytheVIPforyourtargetsystemasRMTHOST,
otherwisejustusetheIPaddress/hostnameofyourtargetsystem.
4)StartExtract'
and'
STARTmyext
STARTmypump
5)CheckthestatusofOGGprocesses:
infoall
第六阶段:
在目标端配置Replicatgroup
1)CreateaReplicatgroup'
rept'
whichreadstrailsfromExtract'
ADDREPLICATrept,EXTTRAIL/mycloudfs/goldengate/dirdat/rt,nodbcheckpoint
2)CreateandedittheparameterfileforReplicat'
EDITPARAMSrept
Addfollowinglinestothisparameterfile,assumethesameORACLE_HOMEandtargetdatabase'
asinsourceODAenvironment:
REPLICATrept
USERIDggs@ggdb,PASSWORDggs
ASSUMETARGETDEFS
HANDLECOLLISIONS
REPERROR(DEFAULT,DISCARD)
DDLERRORDEFAULTDISCARD
DDLOPTIONSREPORT
DISCARDFILE/mycloudfs/goldengate/repsz.dsc,append,megabytes100
MAPhr.*,TARGEThr.*;
3)StartReplicat'
STARTrept
4)CheckthestatusofOGGprocesses:
第七阶段:
验证Goldengate功能
1)Logontosourcedatabaseasuser'
dosomesimpleDDLandDMLoperations.
2)CheckthedatachangehasbeencapturedbyExtractonsourcesystem:
STATSmyext
STATSmypump
3)Logontotargetsystemasoracleuser,checkthestatusofReplicat'
STATSrept
4)Comparetheoutputandmakesuredatachangeissynchronized.
5)(optional,forfurtherHAsetup)StopOGGonsourcesystem:
STOPmyext
STOPmypump
STOPmgr
6)(optional,forfurtherHAsetup)StopOGGontargetsystem:
STOPrept
上回书说到在11gR2上配置GoldenGate,今天应要求继续贴出下篇,下面的步骤是针对GoldenGate的HA配置
第一步AddVIPresourceforOGG
1.CreatenewVIPresource,useIPaddress10.245.48.47asexample,loginasrootandrun:
#/u01/app/11.2.0/grid/bin/appvipcfgcreate-network=1-ip=10.245.48.47-vipname=ggatevip-user=root
/u01/app/11.2.0/grid'
isthedefaultOracleGRIDinfrastructuresoftwaredirectory.
TheexampleVIPresourcenameis'
ggatevip'
andwillbeusedintherestofthisdocument.
NOTE3:
-networkreferstothenetworknumber,defaultvalueis'
1'
.
Andyoucanfindthenetworknumberusingthiscommand:
#/u01/app/11.2.0/grid/bin/crsctlstatres-p|grep-ie.network-ie
subnet|grep-iename-iesubnet
NAME=work
USR_ORA_SUBNET=10.245.48.0
net1indicatesthisisnetwork1,andthesecondlineindicatesthesubnetonwhichtheVIPwillbecreated.
2.AlloworacleusertostarttheVIP,runthiscommandasroot:
#/u01/app/11.2.0/grid/bin/crsctlsetpermresourceggatevip-uuser:
oracle:
r-x
3.Logonasoracleuser,starttheVIPresource:
$/u01/app/11.2.0/grid/bin/crsctlstartresourceggatevip
4.ValidateVIPisrunning:
$/u01/app/11.2.0/grid/bin/crsctlstatusresourceggatevip
NAME=ggatevip
TYPE=app.appvip.type
TARGET=ONLINE
STATE=ONLINEonnode452
TheTARGETandSTATEshouldbothbeONLINE.
5.PingtheVIP'
sIPaddress(10.245.48.47)andmakesureit'
sreachable.
IfyoualsoprefertosetupHAontargetsystem,followthesamesteps,andmakenecessarychangestodirectory,VIPresourcename,IPaddress,etc.
第二步Developanagentscript
1.Savethescriptinafile11gr2_gg_action.scrandcopyittoOGGdirectory.
MakenecessarychangestoGGS_HOME(OGGdirectory)andORACLE_HOME.
2.Makesurethescriptisexecutable:
$chmod+x11gr2_gg_action.scr
IfyoualsoprefertosetupHAontargetsystem,followthesamesteps,andmakenecessarychangestoGGS_HOME,ORACLE_HOMEinthisfile.
第三步RegisterOGGresourceinOracleClusterware
1.RegisterOGGasaresourceinOracleClusterware:
$/u01/app/11.2.0/grid/bin/crsctladdresourceggateapp-typecluster_resource-attr"
ACTION_SCRIPT=/cloudfs/goldengate/11gr2_gg_action.scr,\
CHECK_INTERVAL=30,START_DEPENDENCIES='
hard(ggatevip,ora.ggdb.db)\
pullup(ggatevip)'
STOP_DEPENDENCIES='
hard(ggatevip)'
"
ggateapp'
istheexampleOGGresourcenameandwillbeusedintherestofthisdocument.
ora.ggdb.db'
istheresourcenamefordatabase'
2.ChecktheggateappresourceisavailableasOracleClusterwareresource:
$/u01/app/11.2.0/grid/bin/crsctlstatusresourceggateapp
NAME=ggateapp
TYPE=cluster_resource
TARGET=OFFLINE
STATE=OFFLINE
IfyoualsoprefertosetupHAontargetsystem,followthesamesteps,andmakenecessarychangestodirectory,VIPanddatabaseresource
name,etc.
第四步StarttheOGGresource
1.Starttheresource,fromnowonyoushouldalwaysuseOracleClusterwaretostartOGG:
$/u01/app/11.2.0/grid/bin/crsctlstartresourceggateapp
2.CheckthestatusofOGGresource:
TARGETandSTATEshouldbothbeONLINE.
3.CheckstatusofOGGprocesses:
ProgramStatusGroupLag
TimeSinceChkpt
MANAGERRUNNING
EXTRACTRUNNINGMYEXT00:
00:
07
04
EXTRACTRUNNINGMYPUMP00:
000
0:
05
IfyoualsoprefertosetupHAontargetsystem,followthesamesteps.
第五步.TestOGGresourcefailover
1.Logontonodesourcenodeasoracleuser:
$/u01/app/11.2.0/grid/bin/crsctlrelocateresourceggateapp-f
CRS-2673:
Attemptingtostop'
on'
node452'
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Oracle 11g 安装配置GoldenGate 11 安装 配置 GoldenGate