OraclegRAC數(shù)據(jù)庫(kù)節(jié)點(diǎn)損壞恢復(fù)

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

項(xiàng)目名稱-----服務(wù)器名_RAC節(jié)點(diǎn)1RAC節(jié)點(diǎn)2操作系統(tǒng)RedHat6RedHat6集群軟件OracleGRIDOracleGRID服務(wù)器主機(jī)名his1his2IP地址(示例)系統(tǒng)用戶用戶名RootGridoracle系統(tǒng)組dbaasmdbaasmadminoinstallasmoperdbaasmdbaasmadminoinstallasmoper第3章數(shù)據(jù)庫(kù)環(huán)境項(xiàng)目名稱-一服務(wù)器名稱__RAC節(jié)點(diǎn)1RAC節(jié)點(diǎn)2公共IP地址虛擬IP地址心跳IP地址ScanIP地址OracleRACSIDorcl1orcl2數(shù)據(jù)庫(kù)名稱orcl數(shù)據(jù)文件路徑+DATA歸檔文件+ARCH數(shù)據(jù)庫(kù)版本OracleDatabase11gEnterpriseEditionRelease.0（64位）GRID_BASE目錄/u01/app/gridGRID_HOME目錄/u01/app/grid/目錄/u01/app/oracleORACLE_HOME目錄/u01/app/oracle/數(shù)據(jù)庫(kù)監(jiān)聽端口1521數(shù)據(jù)庫(kù)字符集ZHS16GBK數(shù)據(jù)庫(kù)用戶(sys,system)密碼oracle數(shù)據(jù)庫(kù)硬盤管理方式ASM第4章實(shí)施步驟4.1操作系統(tǒng)準(zhǔn)備工作包括如下操作，主要和rac安裝文檔相同，如果需要重新安裝操作系統(tǒng)，請(qǐng)參考rac安裝文檔的操作，進(jìn)行操作系統(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驗(yàn)證$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驗(yàn)證$sshhisldate$sshhisl-privdate$sshhis2date$sshhis2-privdate4.1.2設(shè)置raw,磁盤陣列聯(lián)系硬件廠家，擴(kuò)展磁盤操作等等，兩個(gè)機(jī)器的磁盤信息相同，主要是掛的磁盤號(hào)要一致。4.1.3重啟hisl服務(wù)器4.2停止原來1節(jié)點(diǎn)vip$srvctldisablelistener-llistener_name-nhisl$srvctlstoplistener-llistener_name-nhisl4.3刪除原l節(jié)點(diǎn)數(shù)據(jù)庫(kù)實(shí)例信息oracle用戶執(zhí)行：$dbca-silent-deleteinstance-nodeListhisl-gdbNameorcl-instanceNameorcll-sysDBAUserNamesys-sysDBAPasswordoracle此時(shí)查看數(shù)據(jù)庫(kù)信息：$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é)點(diǎn)vip$srvctlremovevip-ihis1-vipPleaseconfirmthatyouintendtoremovetheVIPshis1-vip(y/[n])y4.6檢查當(dāng)前集群信息$olsnodes-s-t$crs_stat-t$cluvfystage-postnodedel-nhis1-verbosePerformingpost-checksfornoderemovalCheckingCRSintegrity...ClusterwareversionconsistencypassedTheOracleClusterwareishealthyonnode〃his2〃CRSintegritycheckpassedResult:NoderemovalcheckpassedPost-checkfornoderemovalwassuccessful.4.7重新添加1節(jié)點(diǎn)到集群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í)行和兩個(gè)腳本：腳本執(zhí)行過程略。到這，hisl上面grid已經(jīng)添加完成。Asm和監(jiān)聽vip等都啟動(dòng)了。查看集群狀態(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服務(wù)器/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é)點(diǎn)上以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服務(wù)器/grid/gridhome/opmn/conf/文件moreusesharedinstall=trueallowgroup=truelocalport=6100#lineaddedbyAgentremoteport=6200#lineaddedbyAgentnodes=his1:6200,his2:6200#lineaddedbyAgent如果his2服務(wù)的/grid/gridhome/opmn/conf/沒有添加his1:6200信息，手工給加上4.7.3添加數(shù)據(jù)庫(kù)實(shí)例在任意節(jié)點(diǎn)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注：實(shí)際當(dāng)前環(huán)境只有1個(gè)實(shí)例orcl2:his2active添加orcll實(shí)例Fblgfllstablespace|UNDDTE53SiatuecionlineFReadonlyKPermanentCTemporarv廁§Dst^ba<seConfigurationj^^siEtanit:SummaryThefollowingaddinftanceoperationwillbsperrarmed.Addinsiancy'prod?"onnadA"rac?"Inntializ^tianParametersUmi^