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

2、6RedHat6集群軟件OracleGRIDOracleGRID服務器主機名hislhis2IP地址（示例）172.31.1.50172.31.1.51系統用戶用戶名RootGridoracle系統組dbaasmdbaasmadminoinstallasmoperdbaasmdbaasmadminoinstallasmoper第3章數據庫環境項目互鏟、服務器名稱RAC節點1RAC節點2公共IP地址172.31.1.50172.31.1.51虛擬IP地址172.31.1.52172.31.1.53心跳IP地址192.168.0.1192.168.0.2ScanIP地址172.31.1.54Ora

3、cleRACSIDorcl1orcl2數據庫名稱orcl數據文件路徑+DATA歸檔文件+ARCH數據庫版本OracleDatabase11gEnterpriseEditionRelease11.2.0.4.0（64位）GRID_BASE目錄/u01/app/gridGRID_HOME目錄/u01/app/grid/11.2.0ORACLE_BASE目錄/u01/app/oracleORACLE_HOME目錄/u01/app/oracle/11.2.0數據庫監聽端口1521數據庫字符集ZHS16GBK數據庫用戶(sys,systemj)密碼oracle數據庫硬盤管理方式ASM第4章實施步驟4.1

4、操作系統準備工作包括如下操作，主要和rac安裝文檔相同，如果需要重新安裝操作系統，請參考rac安裝文檔的操作，進行操作系統配置。下面只列出：4.1.1 配置grid用戶及oracle用戶等效性Grid用戶（his2先刪除.shh目錄）在hisl上：su-grid$mkdir-/.ssh$chmod700/.ssh$ssh-keygen-trsa$ssh-keygen-tdsa$cat/.ssh/id_rsa.pub>>/.ssh/authorized_keys$cat/.ssh/id_dsa.pub>>/.ssh/authorized_keys在his2上：$mkdir

5、-/.ssh$chmod700/.ssh$ssh-keygen-trsa$ssh-keygen-tdsa在his1上：$sshjkkdb2cat/.ssh/id_rsa.pub>>/.ssh/authorized_keys$sshjkkdb2cat/.ssh/id_dsa.pub>>/.ssh/authorized_keys$scp/.ssh/authorized_keysjkkdb2:/.ssh/authorized_keys驗證$sshhis1date$sshhisl-privdate$sshhis2date$sshhis2-privdateOracle用戶（）在h

6、isl上：su-grid$mkdir-/.ssh$chmod700/.ssh$ssh-keygen-trsa$ssh-keygen-tdsa$cat/.ssh/id_rsa.pub>>/.ssh/authorized_keys$cat/.ssh/id_dsa.pub>>/.ssh/authorized_keys在his2上：$mkdir-/.ssh$chmod700/.ssh$ssh-keygen-trsa$ssh-keygen-tdsa在his1上：$ sshjkkdb2cat/.ssh/id_rsa.pub>>/.ssh/authorized_keys$

7、 sshjkkdb2cat/.ssh/id_dsa.pub>>/.ssh/authorized_keys$ scp/.ssh/authorized_keysjkkdb2:/.ssh/authorized_keys驗證$ sshhis1date$ sshhis1-privdate$ sshhis2date$ sshhis2-privdate1.1.2 設置raw,磁盤陣列聯系硬件廠家，擴展磁盤操作等等，兩個機器的磁盤信息相同，主要是掛的磁盤號要一致。1.1.3 重啟hisl服務器4.2 停止原來1節點vip$srvctldisablelistener-llistener_name-n

8、hisl$srvctlstoplistener-llistener_name-nhis14.3 刪除原1節點數據庫實例信息oracle用戶執行：$dbca-silent-deleteInstance-nodeListhis1-gdbNameorcl-instanceNameorcl1-sysDBAUserNamesys-sysDBAPasswordoracle此時查看數據庫信息：$srvctlconfigdatabase-dorclDatabaseuniquename:orclDatabasename:Oraclehome:/oracle/product/11.2.0/db_1Oracleus

9、er:oracleSpfile:Domain:Startoptions:openStopoptions:immediateDatabaserole:PRIMARYManagementpolicy:AUTOMATICServerpools:orclDatabaseinstances:his2原來是his1,his2DiskGroups:DATAMountpointpaths:Services:Type:RACDatabaseisadministratormanaged4.4 清除rac信息消除grid/grid/gridhome/oui/bin/runInstaller-updateNodeLi

10、stORACLE_HOME=/grid/gridhome"CLUSTER_NODES=his2"CRS=TRUE-silentStartingOracleUniversalInstaller.Checkingswapspace:mustbegreaterthan500MB.Actual20480MBPassedTheinventorypointerislocatedat/etc/oraInst.locTheinventoryislocatedat/grid/gridbase/oraInventory'UpdateNodeList'wassuccessful.

11、消除oracle/oracle/product/11.2.0/db_1/oui/bin>runInstaller-updateNodeListORACLE_HOME=/oracle/product/11.2.0/db_1"CLUSTER_NODES=his2”StartingOracleUniversalInstaller.Checkingswapspace:mustbegreaterthan500MB.Actual20480MBPassedTheinventorypointerislocatedat/etc/oraInst.locTheinventoryislocatedat

12、/oracle/oraInventory'UpdateNodeList'wassuccessful.查看/grid/gridhome/opmen/conf/ons.config文件usesharedinstall=trueallowgroup=truelocalport=6100#lineaddedbyAgentremoteport=6200#lineaddedbyAgentnodes=his2:6200#lineaddedbyAgent如果還有his1信息，手工刪除4.5 清除1節點vip$srvctlremovevip-ihis1-vipPleaseconfirmthaty

13、ouintendtoremovetheVIPshis1-vip(y/n)y4.6 檢查當前集群信息$olsnodes-s寸$crs_stat4$cluvfystage-postnodedel-nhisl-verbosePerformingpost-checksfornoderemovalCheckingCRSintegrity.ClusterwareversionconsistencypassedTheOracleClusterwareishealthyonnode"his2"CRSintegritycheckpassedResult:Noderemovalcheckpas

14、sedPost-checkfornoderemovalwassuccessful.4.7 重新添加1節點到集群4.7.1 添加grid軟件環境檢查$cluvfycomppeer-refnodehis2-nhis1-verbose$cluvfystage-prenodeadd-nhis1verbose在/grid/gridhome/oui/bin下：$exportIGNORE_PREADDNODE_CHECKS=Y$./addNode.sh-silent"CLUSTER_NEW_NODES=his1""CLUSTER_NEWVIRTUAL_HOSTNAMES=his

15、1-vip”Performingpre-checksfornodeadditionCheckingnodereachability.Nodereachabilitycheckpassedfromnode"his1"Checkinguserequivalence.Userequivalencecheckpassedforuser"grid"Checkingnodeconnectivity.Checkinghostsconfigfile.Verificationofthehostsconfigfilesuccessful(WARNING:Anewinvent

16、oryhasbeencreatedononeormorenodesinthissession.However,ithasnotyetbeenregisteredasthecentralinventoryofthissystem.Toregisterthenewinventorypleaserunthescriptat'/grid/gridbase/oraInventory/orainstRoot.sh'withrootprivilegesonnodes'his1'.Ifyoudonotregistertheinventory,youmaynotbeabletou

17、pdateorpatchtheproductsyouinstalled.Thefollowingconfigurationscriptsneedtobeexecutedasthe"root"userineachnewclusternode.Eachscriptinthelistbelowisfollowedbyalistofnodes./grid/gridbase/oraInventory/orainstRoot.sh#Onnodeshxbak1/grid/gridhome/root.sh#Onnodeshis1Toexecutetheconfigurationscript

18、s:1. Openaterminalwindow2. Loginas"root"3. RunthescriptsineachclusternodeTheClusterNodeAdditionof/grid/gridhomewassuccessful.Pleasecheck'/tmp/silentInstall.log'formoredetails.在his1以root用戶執行orainstRoot.sh和root.sh兩個腳本：腳本執行過程略。到這，his1上面grid已經添加完成。Asm和監聽vip等都啟動了。查看集群狀態gridhis2$crs_stat

19、-tNameTypeTargetStateHostora.ARCHDG.dgora.up.typeONLINEONLINEhis1ora.CRSDG.dgora.up.typeONLINEONLINEhis1ora.DATADG.dgora.up.typeONLINEONLINEhis1ora.ER.lsnrora.er.typeONLINEONLINEhis1ora.N1.lsnrora.er.typeONLINEONLINEhis2ora.asmora.asm.typeONLINEONLINEhis1ora.cvuora.cvu.typeONLINEONLINEhis2ora.gsdora

20、.gsd.typeOFFLINEOFFLINEora.SM1.asmapplicationONLINEONLINEhis1ora.S1.lsnrapplicationONLINEONLINEhis1ora.his1.gsdapplicationOFFLINEOFFLINEora.his1.onsapplicationONLINEONLINEhis1ora.his1.vipora.t1.typeONLINEONLINEhis1ora.SM2.asmapplicationONLINEONLINEhis2ora.S2.lsnrapplicationONLINEONLINEhis2ora.his2.g

21、sdapplicationOFFLINEOFFLINEora.his2.onsapplicationONLINEONLINEhis2ora.his2.vipora.t1.typeONLINEONLINEhis2workora.rk.typeONLINEONLINEhis1ora.oc4jora.oc4j.typeONLINEONLINEhis2ora.onsora.ons.typejONLINEONLINEhis1ora.orcl.dbora.se.typeONLINEONLINEhis2ora.scan1.vipora.ip.typeONLINEONLINEhis24.7.2 添加oracl

22、e軟件在his2服務器/oracle/product/11.2.0/db_1/oui/bin不執行：$exportIGNORE_PREADDNODE_CHECKS=Y$./addNode.sh"CLUSTER_NEW_NODES=his1”Savinginventoryonnodes100%Done.SaveinventorycompleteWARNING:Thefollowingconfigurationscriptsneedtobeexecutedasthe"root"userineachnewclusternode.Eachscriptinthelistbe

23、lowisfollowedbyalistofnodes./oracle/product/11.2.0/db1/root.sh#Onnodeshis1Toexecutetheconfigurationscripts:1. Openaterminalwindow2. Loginas"root"3. RunthescriptsineachclusternodeTheClusterNodeAdditionof/oracle/product/11.2.0/db_1wassuccessful.Pleasecheck'/tmp/silentInstall.log'form

24、oredetails.在his1節點上以root用戶執行/oracle/product/11.2.0/db1/root.shW本PerformingrootuseroperationforOracle11gThefollowingenvironmentvariablesaresetas:ORACLE_OWNER=oracleORACLE_HOME=/oracle/product/11.2.0/db_1Enterthefullpathnameofthelocalbindirectory:/usr/local/bin:Thecontentsof"dbhome"havenotch

25、anged.Noneedtooverwrite.Thecontentsof"oraenv"havenotchanged.Noneedtooverwrite.Thecontentsof"coraenv"havenotchanged.Noneedtooverwrite.Entrieswillbeaddedtothe/etc/oratabfileasneededbyDatabaseConfigurationAssistantwhenadatabaseiscreatedFinishedrunninggenericpartofrootscript.Nowprodu

26、ct-specificrootactionswillbeperformed.Finishedproduct-specificrootactions.查看his1月艮務器/grid/gridhome/opmn/conf/ons.conf文件moreons.configusesharedinstall=trueallowgroup=truelocalport=6100#lineaddedbyAgentremoteport=6200#lineaddedbyAgentnodes=his1:6200,his2:6200#lineaddedbyAgent如果his2服務的/grid/gridhome/op

27、mn/conf/ons.conf沒有添加his1:6200信息，手工給加上4.7.3 添加數據庫實例在任意節點oracle用戶執行dbca|jDatabaseConfiguratnonAsi?tant:WelcomeWelcoinetotheDatatiaseConfigurationAssisiamtforOracleRealApplicationClustersTheDatabaseConfigurationAssistantenables>oulacreafSjccnfigure,ardeleteaclutQrdatabaseandrnanagedatabaseiemulates.

28、Iialsoenablesiqaddanddeletemsianceofaclusterdaiatjase.Selectthedatabaseiypethatyouwouldliketocreateoractmlnisfer*OracleRealMmlcaticinClusters(RAC)datataierOracleRACOneNodedatabase廠OraclesingleinslaricedalabaseCsricelHelpGackyext3)CreateaDatabaseDeleteaDatabaseSelecttheoperationtJiatv°uwanttoper

29、fonm:rConfigureDatableOplionsManageTemplatesinstancaManagmntASMcohfigiuraiionQiperationsmustbeperTormedlusingAutomaticStorage,4/ManagementConfiguratiianAssistant密MCfromOracleGridInfrastructurehomeDatabaseNam自StatusCancelactiveSelectanactiveclusterdatabasetoaddanhsianceConfigurationTvpeLocallirisiani

30、cgStatusAdmin*ManagedRunning疆Eazk.兇2啦注：實際當前環境只有1個實例orcl2:his2active也同DatabaseC/nfiqurati口口口日式3*gap$of7:Instancenamningandnode5ele<ticnThedefauKinslancnameis"procl3n.EdilIheinstancenamEifneedleclj,delectIhienodeonwhichtoaddihein兌3n匚曳anddkkNext.rac5BackNexl*j添加orcll實例JADatabaseCrpi科quritiDqAsh

31、tan，$抬巨6uf6：InstanceStorageStorage-Tablespaces-9Datafiles_JRedoLogCroupsDatabaseStorageFromtheDaLtibaiseStoragepage,youcanspecilvstorageparametersfordatabasecreation.Thispagedisplaysairesliningand?ummaryview（mullI-columnlistsioenableyoutochangeandviewthefollowingobjects:«Controlfiles/Tablespace

32、s Datafiles RdDlbarkSegments RedoLogGro叩£FromanyobjecttwefolderclickCreateiocreateanewobject.TodeieieanobjectselectthespecificobjectfromwithinthsobjeciivDefolderanddirkDeleteImportanttfyouselectadalaba&etemplaleincludingdatafiles,tlhenyouwillnotbeabletoaddorremovedatafiles>tablespacss.or

33、rollbacksegments.Selectimgthistypeofiemplateenablesyoutotliangethefollowing: Destinationofihedaiaflles Controlfilesorleggroups.Formoreinformation,refertotheOrarJeDatabaseAdmintratosGuid&.CreateDeleteIFileLocationvariables.iCancelIHelp&g恥K|yexi-（而資）(y|DatabaseConfiguratianA.ssistamt：SummaryThiefollowingaddinstanceoperatiionwillbgperformed.Aridinstancsaprod3"onniadE!*&匚AddinstanceT,prod31TonnodeTrrac31f.Init