OraclegRAC數(shù)據(jù)庫節(jié)點損壞恢復

Oracle11gR2Rac節(jié)點損壞恢復方正國際公共安全事業(yè)部技術文檔文檔屬性文檔屬性內(nèi)容文檔名稱Oracle11gR2Rac節(jié)點損壞恢復報告文檔版本號A1文檔狀態(tài)正式稿文檔編寫完成日期2016年9月14日作者文檔變更歷史清單文件版本號修正日期修正人備注本次修改變更說明序號變更內(nèi)容筒述1.2.3.4.5.第1章概述遼寧省廳警務綜合平臺項目中，錦州數(shù)據(jù)庫現(xiàn)場的用戶因為在未停止數(shù)據(jù)庫的情況下，擴展磁盤陣列，更換磁盤，導致1節(jié)點本地磁盤陣列掛不上，導致只能一個節(jié)點使用數(shù)據(jù)庫，需要重新配置oracle集群信息。第2章系統(tǒng)環(huán)境

項目名稱-----服務器名_RAC節(jié)點1RAC節(jié)點2操作系統(tǒng)RedHat6RedHat6集群軟件OracleGRIDOracleGRID服務器主機名his1his2IP地址(示例)系統(tǒng)用戶用戶名RootGridoracle系統(tǒng)組dbaasmdbaasmadminoinstallasmoperdbaasmdbaasmadminoinstallasmoper第3章數(shù)據(jù)庫環(huán)境項目名稱-一服務器名稱__RAC節(jié)點1RAC節(jié)點2公共IP地址虛擬IP地址心跳IP地址ScanIP地址OracleRACSIDorcl1orcl2數(shù)據(jù)庫名稱orcl數(shù)據(jù)文件路徑+DATA歸檔文件+ARCH數(shù)據(jù)庫版本OracleDatabase11gEnterpriseEditionRelease.0（64位）GRID_BASE目錄/u01/app/gridGRID_HOME目錄/u01/app/grid/目錄/u01/app/oracleORACLE_HOME目錄/u01/app/oracle/數(shù)據(jù)庫監(jiān)聽端口1521數(shù)據(jù)庫字符集ZHS16GBK數(shù)據(jù)庫用戶(sys,system)密碼oracle數(shù)據(jù)庫硬盤管理方式ASM第4章實施步驟4.1操作系統(tǒng)準備工作包括如下操作，主要和rac安裝文檔相同，如果需要重新安裝操作系統(tǒng)，請參考rac安裝文檔的操作，進行操作系統(tǒng)配置。下面只列出：4.1.1配置grid用戶及oracle用戶等效性Grid用戶（his2先刪除.shh目錄）在his1上：su-grid$mkdir~/.ssh$chmod700~/.ssh$ssh-keygen-trsa$ssh-keygen-tdsa$cat~/.ssh/>>~/.ssh/authorized_keys$cat~/.ssh/>>~/.ssh/authorized_keys在his2上：$mkdir~/.ssh$chmod700~/.ssh$ssh-keygen-trsa$ssh-keygen-tdsa在his1上：$sshjkkdb2cat~/.ssh/>>~/.ssh/authorized_keys$sshjkkdb2cat~/.ssh/>>~/.ssh/authorized_keys$scp~/.ssh/authorized_keysjkkdb2:~/.ssh/authorized_keys驗證$sshhis1date$sshhis1-privdate$sshhis2date$sshhis2-privdateOracle用戶（）在his1上：su-grid$mkdir~/.ssh$chmod700~/.ssh$ssh-keygen-trsa$ssh-keygen-tdsa$cat~/.ssh/>>~/.ssh/authorized_keys$cat~/.ssh/>>~/.ssh/authorized_keys在his2上：$mkdir~/.ssh$chmod700~/.ssh$ssh-keygen-trsa$ssh-keygen-tdsa在hisl上：$sshjkkdb2cat~/.ssh/>>~/.ssh/authorized_keys$sshjkkdb2cat~/.ssh/>>~/.ssh/authorized_keys$scp~/.ssh/authorized_keysjkkdb2:~/.ssh/authorized_keys驗證$sshhisldate$sshhisl-privdate$sshhis2date$sshhis2-privdate4.1.2設置raw,磁盤陣列聯(lián)系硬件廠家，擴展磁盤操作等等，兩個機器的磁盤信息相同，主要是掛的磁盤號要一致。4.1.3重啟hisl服務器4.2停止原來1節(jié)點vip$srvctldisablelistener-llistener_name-nhisl$srvctlstoplistener-llistener_name-nhisl4.3刪除原l節(jié)點數(shù)據(jù)庫實例信息oracle用戶執(zhí)行：$dbca-silent-deleteinstance-nodeListhisl-gdbNameorcl-instanceNameorcll-sysDBAUserNamesys-sysDBAPasswordoracle此時查看數(shù)據(jù)庫信息：$srvctlconfigdatabase-dorclDatabaseuniquename:orclDatabasename:Oraclehome:/oracle/product/user:oracleSpfile:Domain:Startoptions:openStopoptions:immediateDatabaserole:PRIMARYManagementpolicy:AUTOMATICServerpools:orclDatabaseinstances:his2原來是his1，his2DiskGroups:DATAMountpointpaths:Services:Type:RACDatabaseisadministratormanaged4.4清除rac信息清除grid/grid/gridhome/oui/bin/runInstaller-updateNodeListORACLE_HOME=/grid/gridhome"CLUSTER_NODES=(his2)"CRS=TRUE-silentStartingOracleUniversalInstaller...Checkingswapspace:mustbegreaterthan500MB.Actual20480MBPassedTheinventorypointerislocatedat/etc/Theinventoryislocatedat/grid/gridbase/oraInventory'UpdateNodeList'wassuccessful.清除oracle/oracle/product/-updateNodeListORACLE_HOME=/oracle/product/"CLUSTER_NODES=(his2)"StartingOracleUniversalInstaller...Checkingswapspace:mustbegreaterthan500MB.Actual20480MBPassedTheinventorypointerislocatedat/etc/Theinventoryislocatedat/oracle/oraInventory'UpdateNodeList'wassuccessful.查看/grid/gridhome/opmen/conf/文件usesharedinstall=trueallowgroup二truelocalport=6100#lineaddedbyAgentremoteport=6200#lineaddedbyAgentnodes=his2:6200#lineaddedbyAgent如果還有his1信息，手工刪除4.5清除1節(jié)點vip$srvctlremovevip-ihis1-vipPleaseconfirmthatyouintendtoremovetheVIPshis1-vip(y/[n])y4.6檢查當前集群信息$olsnodes-s-t$crs_stat-t$cluvfystage-postnodedel-nhis1-verbosePerformingpost-checksfornoderemovalCheckingCRSintegrity...ClusterwareversionconsistencypassedTheOracleClusterwareishealthyonnode〃his2〃CRSintegritycheckpassedResult:NoderemovalcheckpassedPost-checkfornoderemovalwassuccessful.4.7重新添加1節(jié)點到集群4.7.1添加grid軟件環(huán)境檢查$cluvfycomppeer-refnodehis2-nhis1-verbose$cluvfystage-prenodeadd-nhis1-verbose在/grid/gridhome/oui/bin下：$exportIGNORE_PREADDNODE_CHECKS=Y$./-silent〃CLUSTER_NEW_NODES={his1}〃〃CLUSTER_NEW_VIRTUAL_HOSTNAMES={hisl-vip}Performingpre-checksfornodeadditionCheckingnodereachability...Nodereachabilitycheckpassedfromnode〃his1〃Checkinguserequivalence...Userequivalencecheckpassedforuser"grid"Checkingnodeconnectivity...Checkinghostsconfigfile...Verificationofthehostsconfigfilesuccessful...略...(WARNING:Anewinventoryhasbeencreatedononeormorenodesinthissession.However,ithasnotyetbeenregisteredasthecentralinventoryofthissystem.Toregisterthenewinventorypleaserunthescriptat,/grid/gridbase/oraInventory/'withrootprivilegesonnodes'hisl'.Ifyoudonotregistertheinventory,youmaynotbeabletoupdateorpatchtheproductsyouinstalled.Thefollowingconfigurationscriptsneedtobeexecutedasthe"root"userineachnewclusternode.Eachscriptinthelistbelowisfollowedbyalistofnodes./grid/gridbase/oralnventory/#Onnodeshxbakl/grid/gridhome/#OnnodeshislToexecutetheconfigurationscripts:OpenaterminalwindowLoginas"root"RunthescriptsineachclusternodeTheClusterNodeAdditionof/grid/gridhomewassuccessful.Pleasecheck'/tmp/'formoredetails.在hisl以root用戶執(zhí)行和兩個腳本：腳本執(zhí)行過程略。到這，hisl上面grid已經(jīng)添加完成。Asm和監(jiān)聽vip等都啟動了。查看集群狀態(tài)rd.八?「zK[grid@his2~]$crs_stat-tHostNameTypeTargetStateora..,..ONLINEONLINEhislora.,...ONLINEONLINEhislora..,..ONLINEONLINEhislora....ora....ONLINEONLINEhisl

ora....ora....ONLINEONLINEhis2ONLINEONLINEOFFLINEONLINEONLINEOFFLINEhis1his2ora....applicationONLINEONLINEhis1ora....applicationONLINEONLINEhis1applicationOFFLINEOFFLINEapplicationONLINEONLINEhis1ora....ONLINEONLINEhis1ora....applicationONLINEONLINEhis2ora....applicationONLINEONLINEhis2applicationOFFLINEOFFLINEapplicationONLINEONLINEhis2ora....ONLINEONLINEhis2ora...workora....(ONLINE(ONLINEhis1ONLINE(ONLINE1his2ONLINEONLINEhis1ora....ONLINEONLINEhis2ora....ONLINEONLINEhis24.7.2添加oracle軟件在his2服務器/oracle/product/下執(zhí)行：$exportIGNORE_PREADDNODE_CHECKS=Y$.，/"CLUSTERNEWNODES={his1}"Savinginventoryonnodes.100%Done.SaveinventorycompleteWARNING:Thefollowingconfigurationscriptsneedtobeexecutedasthe"root"userineachnewclusternode.Eachscriptinthelistbelowisfollowedbyalistofnodes./oracle/product/#Onnodeshis1Toexecutetheconfigurationscripts:OpenaterminalwindowLoginas"root"RunthescriptsineachclusternodeTheClusterNodeAdditionof/oracle/product/wassuccessful.Pleasecheck'/tmp/'formoredetails.在his1節(jié)點上以root用戶執(zhí)行/oracle/product/腳本PerformingrootuseroperationforOracle11gThefollowingenvironmentvariablesaresetas:ORACLE_OWNER=oracle

ORACLE_HOME=/oracle/product/thefullpathnameofthelocalbindirectory:[/usr/local/bin]:Thecontentsof〃dbhome〃havenotchanged.Noneedtooverwrite.Thecontentsof〃oraenv〃havenotchanged.Noneedtooverwrite.Thecontentsof〃coraenv〃havenotchanged.Noneedtooverwrite.Entrieswillbeaddedtothe/etc/oratabfileasneededbyDatabaseConfigurationAssistantwhenadatabaseiscreatedFinishedrunninggenericpartofrootscript.Nowproduct-specificrootactionswillbeperformed.Finishedproduct-specificrootactions.查看his1服務器/grid/gridhome/opmn/conf/文件moreusesharedinstall=trueallowgroup=truelocalport=6100#lineaddedbyAgentremoteport=6200#lineaddedbyAgentnodes=his1:6200,his2:6200#lineaddedbyAgent如果his2服務的/grid/gridhome/opmn/conf/沒有添加his1:6200信息，手工給加上4.7.3添加數(shù)據(jù)庫實例在任意節(jié)點oracle用戶執(zhí)行dbcaIjJdDatabaseConfigurjtionAsssisLsnt;WeiDomeWelcometotheDaraioaseConfiguration/ssistamforOracleRealApplication匚lusters.TheDatabaseConfigurationAssistantenablesyoutocreate.confiQure.ordeleteaclusterdatabaseandmanagetemplates.ItaKDenablestoaddariddeieieinstancesofaclusterdatabase.Selectthedatabasetvpethalwuwouldliketocrearteoradminister:?OracleReal.ApplicationClusters(RAC)databaseLOracleRACOneMadedatabaseLOraclesingleinstancedatabaseCManageTemplatesInstanceManagement劇Dstabs^eConfigurationAssiEtant,Step1of7:CManageTemplatesInstanceManagement5eIe匚ttheopErarionthatyouwamtnpErformCCreateaDatabaseCConfigureDatabaseOplionsCDeletpaDatabase|廣57、MMconnguraiionoperaTion^musiheperTormedusingAutomailcStorageManagerriEntConfigurarianAssistant[ASMCi^fromOracleGridInfrastructurehome.DatabaseConfigurationAssistantStep2of7:IrirtanceManagementSelecttheinstancemanaaernemaperationthaiwuwanttoperform:「?AddaninstanceQDeleteaninslanceact餉actrmeracl:pradlrac2:prod2Llickne>itDaddanewinstance.ThelistbemwshowsihenameofdiscinginstancesfortheclusterdaUba^e"procf1注：實際當前環(huán)境只有1個實例orcl2:his2active添加orcll實例Fblgfllstablespace|UNDDTE53SiatuecionlineFReadonlyKPermanentCTemporarv廁§Dst^ba<seConfigurationj^^siEtanit:SummaryThefollowingaddinftanceoperationwillbsperrarmed.Addinsiancy'prod?"onnadA"rac?"Inntializ^tianParametersUmi^