Oracle Database 12c RAC损坏ocr和votedisk恢复实例教程
本篇内容主要讲解“Oracle Database 12c RAC损坏ocr和votedisk恢复实例教程”,感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷,实用性强。下面就让小编来带大家学习“Oracle Database 12c RAC损坏ocr和votedisk恢复实例教程”吧!
实验环境:2-NODES Oracle Database 12c RAC on Linux6(OEL 6.4)
查看表决磁盘和Ocr相关信息
[root@12crac1~]#cd/u01/app/12.1.0/grid/bin/[root@12crac1bin]#./crsctlquerycssvotedisk##STATEFileUniversalIdFileNameDiskgroup------------------------------------------1.ONLINEd883c23a7bfc4fdcbf418c9f631bd0af(/dev/asm-crs)[RACCRS]Located1votingdisk(s).[root@12crac1bin]#./ocrcheckStatusofOracleClusterRegistryisasfollows:Version:4Totalspace(kbytes):409568Usedspace(kbytes):1608Availablespace(kbytes):407960ID:1658916461Device/FileName:+RACCRSDevice/FileintegritychecksucceededDevice/FilenotconfiguredDevice/FilenotconfiguredDevice/FilenotconfiguredDevice/FilenotconfiguredClusterregistryintegritychecksucceeded
查看当前ocr备份情况
[root@12crac1bin]#./ocrconfig-showbackup12crac12013/07/0223:21:22/u01/app/12.1.0/grid/cdata/scan12c/backup00.ocr12crac12013/07/0219:21:21/u01/app/12.1.0/grid/cdata/scan12c/backup01.ocr12crac12013/07/0104:52:41/u01/app/12.1.0/grid/cdata/scan12c/backup02.ocr12crac12013/07/0104:52:41/u01/app/12.1.0/grid/cdata/scan12c/day.ocr12crac12013/07/0104:52:41/u01/app/12.1.0/grid/cdata/scan12c/week.ocr12crac12013/07/0100:48:56/u01/app/12.1.0/grid/cdata/scan12c/backup_20130701_004856.ocr12crac12013/07/0100:39:40/u01/app/12.1.0/grid/cdata/scan12c/backup_20130701_003940.ocr
可以如下方式进行手工备份
[root@12crac1bin]#./ocrconfig-local-manualbackup12crac12013/07/2117:55:10/u01/app/12.1.0/grid/cdata/12crac1/backup_20130721_175510.olr12crac12013/07/0100:39:39/u01/app/12.1.0/grid/cdata/12crac1/backup_20130701_003939.olr
查看RAC资源服务状态
[grid@12crac1~]$crsctlstatres-t--------------------------------------------------------------------------------NameTargetStateServerStatedetails--------------------------------------------------------------------------------LocalResources--------------------------------------------------------------------------------ora.LISTENER.lsnrONLINEONLINE12crac1STABLEONLINEONLINE12crac2STABLEora.RACCRS.dgONLINEONLINE12crac1STABLEONLINEONLINE12crac2STABLEora.RACDATA.dgONLINEONLINE12crac1STABLEONLINEONLINE12crac2STABLEora.RACFRA.dgONLINEONLINE12crac1STABLEONLINEONLINE12crac2STABLEora.asmONLINEONLINE12crac1Started,STABLEONLINEONLINE12crac2Started,STABLEora.net1.networkONLINEONLINE12crac1STABLEONLINEONLINE12crac2STABLEora.onsONLINEONLINE12crac1STABLEONLINEONLINE12crac2STABLE--------------------------------------------------------------------------------ClusterResources--------------------------------------------------------------------------------ora.12crac1.vip1ONLINEONLINE12crac1STABLEora.12crac2.vip1ONLINEONLINE12crac2STABLEora.LISTENER_SCAN1.lsnr1ONLINEONLINE12crac2STABLEora.LISTENER_SCAN2.lsnr1ONLINEONLINE12crac1STABLEora.LISTENER_SCAN3.lsnr1ONLINEONLINE12crac1STABLEora.MGMTLSNR1ONLINEONLINE12crac1169.254.88.173192.168.80.150,STABLEora.cvu1ONLINEONLINE12crac1STABLEora.luocs12c.db1ONLINEONLINE12crac2Open,STABLE2ONLINEONLINE12crac1Open,STABLEora.mgmtdb1ONLINEONLINE12crac1Open,STABLEora.oc4j1ONLINEONLINE12crac1STABLEora.scan1.vip1ONLINEONLINE12crac2STABLEora.scan2.vip1ONLINEONLINE12crac1STABLEora.scan3.vip1ONLINEONLINE12crac1STABLE--------------------------------------------------------------------------------
用ASMCMD的md_backup命令备份磁盘组,顺便查看该磁盘组里都存放什么。
[root@12crac2~]#su-grid[grid@12crac2~]$asmcmd-pASMCMD[+]>md_backup/home/grid/ocrvote.bak-GRACCRSDiskgroupmetadatatobebackedup:RACCRSCurrentaliasdirectorypath:scan12cCurrentaliasdirectorypath:ASMCurrentaliasdirectorypath:_MGMTDB/CONTROLFILECurrentaliasdirectorypath:_MGMTDB/TEMPFILECurrentaliasdirectorypath:ASM/PASSWORDCurrentaliasdirectorypath:_MGMTDB/ONLINELOGCurrentaliasdirectorypath:_MGMTDBCurrentaliasdirectorypath:scan12c/OCRFILECurrentaliasdirectorypath:_MGMTDB/DATAFILECurrentaliasdirectorypath:scan12c/ASMPARAMETERFILECurrentaliasdirectorypath:_MGMTDB/PARAMETERFILE--从这里可以看出,在Oracle12cRAC中,存放ocr的磁盘组里多了不少文件,有_MGMTDB相关文件以及ASM的PASSWORD。下面是11gRAC中存放OCR的磁盘组内容ASMCMD[+]>md_backup/home/grid/ocrvote.bak-Ghk_crsDiskgroupmetadatatobebackedup:HK_CRSCurrentaliasdirectorypath:racscan/OCRFILECurrentaliasdirectorypath:racscanCurrentaliasdirectorypath:racscan/ASMPARAMETERFILE
也可以导出ocr的内容
[root@12crac1bin]#./ocrconfig-export/home/grid/ocr.bak
以下方式都无法删除当前使用的ocr内容
ASMCMD[+]>rm-rf/raccrs/scan12c/ocrfileORA-29261:badargumentORA-15178:directory'ocrfile'isnotempty;cannotdropthisdirectoryORA-15028:ASMfile'+RACCRS.255.819592481'notdropped;currentlybeingaccessedORA-06512:atline4(DBDERROR:OCIStmtExecute)ASMCMD[+]>cd/raccrs/scan12c/ocrfileASMCMD[+raccrs/scan12c/ocrfile]>lsREGISTRY.255.819592481ASMCMD[+raccrs/scan12c/ocrfile]>rm-rfREGISTRY.255.819592481ORA-15032:notallalterationsperformedORA-15028:ASMfile'+raccrs/scan12c/ocrfile/REGISTRY.255.819592481'notdropped;currentlybeingaccessed(DBDERROR:OCIStmtExecute)
那我们可以破坏存放ocr的设备文件
[root@12crac1bin]#ddif=/dev/zeroof=/dev/sdgbs=1024kcount=11+0recordsin1+0recordsout1048576bytes(1.0MB)copied,0.00335689s,312MB/s
然后停止集群:
[root@12crac1bin]#./crsctlstophas[root@12crac2bin]#./crsctlstophas-f
或crsctl stop crs [-f]也可以
尝试启动clusterware,发现clusterware无法正常启动
[root@12crac1bin]#./crsctlstarthasCRS-4123:OracleHighAvailabilityServiceshasbeenstarted.[grid@12crac1~]$crsctlcheckcrsCRS-4638:OracleHighAvailabilityServicesisonlineCRS-4535:CannotcommunicatewithClusterReadyServicesCRS-4530:CommunicationsfailurecontactingClusterSynchronizationServicesdaemonCRS-4534:CannotcommunicatewithEventManager
查看集群日志:
2013-07-2023:46:01.413:[ohasd(18692)]CRS-0714:OracleClusterwareRelease12.1.0.1.0-ProductionCopyright1996,2010Oracle.Allrightsreserved.2013-07-2023:46:01.451:[ohasd(18692)]CRS-2112:TheOLRservicestartedonnode12crac1.2013-07-2023:46:01.494:[ohasd(18692)]CRS-1301:OracleHighAvailabilityServicestartedonnode12crac1.2013-07-2023:46:01.498:[ohasd(18692)]CRS-8017:location:/etc/oracle/lastgasphas2rebootadvisorylogfiles,0wereannouncedand0errorsoccurred2013-07-2023:46:10.768:[gpnpd(19041)]CRS-2328:GPNPDstartedonnode12crac1.2013-07-2023:46:42.712:[cssd(19212)]CRS-1713:CSSDdaemonisstartedinhubmode2013-07-2023:46:43.221:[cssd(19212)]CRS-1714:Unabletodiscoveranyvotingfiles,retryingdiscoveryin15seconds;Detailsat(:CSSNM00070:)in/u01/app/12.1.0/grid/log/12crac1/cssd/ocssd.log2013-07-2023:46:44.142:[ohasd(18692)]CRS-2767:Resourcestaterecoverynotattemptedfor'ora.diskmon'asitstargetstateisOFFLINE2013-07-2023:46:44.143:[ohasd(18692)]CRS-2769:Unabletofailoverresource'ora.diskmon'.2013-07-2023:46:58.280:[cssd(19212)]CRS-1714:Unabletodiscoveranyvotingfiles,retryingdiscoveryin15seconds;Detailsat(:CSSNM00070:)in/u01/app/12.1.0/grid/log/12crac1/cssd/ocssd.log
查看/u01/app/12.1.0/grid/log/12crac1/cssd/ocssd.log日志
2013-07-2023:48:13.450:[GPNP][1105622784]clsgpnp_profileCallUrlInt:[atclsgpnp.c:2207]get-profilecalltourl"ipc://GPNPD_12crac1"disco""[f=0claimed-host:cname:cguid:cli:gpnpp:19212role:seq:ep:auth:diag:[]]2013-07-2023:48:13.476:[GPNP][1105622784]clsgpnp_profileCallUrlInt:[atclsgpnp.c:2360]Result:(0)CLSGPNP_OK.Successfulget-profileCALLtoremote"ipc://GPNPD_12crac1"disco""2013-07-2023:48:13.477:[CSSD][1105622784]clssnmReadDiscoveryProfile:votingfilediscoverystring(/dev/asm*)2013-07-2023:48:13.478:[CSSD][1105622784]clssnmvDDiscThread:usingdiscoverystring/dev/asm*forinitialdiscovery2013-07-2023:48:13.478:[SKGFD][1105622784]Discoverywithstr:/dev/asm*:2013-07-2023:48:13.478:[SKGFD][1105622784]UFSdiscoverywith:/dev/asm*:2013-07-2023:48:13.491:[SKGFD][1105622784]FetchingUFSdisk:/dev/asm-data:2013-07-2023:48:13.491:[SKGFD][1105622784]FetchingUFSdisk:/dev/asm-fra:2013-07-2023:48:13.492:[SKGFD][1105622784]FetchingUFSdisk:/dev/asm-crs:2013-07-2023:48:13.492:[SKGFD][1105622784]FetchingUFSdisk:/dev/asm-extcrs:2013-07-2023:48:13.492:[SKGFD][1105622784]FetchingUFSdisk:/dev/asm:2013-07-2023:48:13.492:[SKGFD][1105622784]OSSdiscoverywith:/dev/asm*:2013-07-2023:48:13.495:[SKGFD][1105622784]Handle0x7f8c10170500fromlib:UFS::fordisk:/dev/asm-data:2013-07-2023:48:13.498:[SKGFD][1105622784]Handle0x7f8c1016e8a0fromlib:UFS::fordisk:/dev/asm-fra:2013-07-2023:48:13.500:[SKGFD][1105622784]Handle0x7f8c1016f0d0fromlib:UFS::fordisk:/dev/asm-crs:2013-07-2023:48:13.501:[SKGFD][1105622784]Handle0x7f8c1011c4e0fromlib:UFS::fordisk:/dev/asm-extcrs:2013-07-2023:48:13.501:[SKGFD][1105622784]Lib:UFS::closinghandle0x7f8c10170500fordisk:/dev/asm-data:2013-07-2023:48:13.501:[SKGFD][1105622784]Lib:UFS::closinghandle0x7f8c1016e8a0fordisk:/dev/asm-fra:2013-07-2023:48:13.501:[SKGFD][1105622784]Lib:UFS::closinghandle0x7f8c1016f0d0fordisk:/dev/asm-crs:2013-07-2023:48:13.502:[SKGFD][1105622784]Lib:UFS::closinghandle0x7f8c1011c4e0fordisk:/dev/asm-extcrs:2013-07-2023:48:13.503:[CSSD][1105622784]clssnmvDiskVerify:Successfuldiscoveryof0disks2013-07-2023:48:13.503:[CSSD][1105622784]clssnmCompleteInitVFDiscovery:Completinginitialvotingfilediscovery2013-07-2023:48:13.503:[CSSD][1105622784]clssnmvFindInitialConfigs:Novotingfilesfound2013-07-2023:48:13.503:[CSSD][1105622784](:CSSNM00070:)clssnmCompleteInitVFDiscovery:Votingfilenotfound.Retryingdiscoveryin15seconds
– 我们可以看出表决磁盘无法找到等报错信息。
下面将集群关闭,尝试恢复。
[root@12crac1bin]#./crsctlstophas-f
ocr和vote disk损坏恢复步骤大致如下:
1)停止所有节点clusterware
# crsctl stop crs
# crsctl stop crs -f
2)以root用户在其中一个节点度扎模式启动clusterware
# crsctl start crs -excl -nocrs
备注:如果发现crsd在运行,那么通过如下命令将之停止。
# crsctl stop resource ora.crsd -init
3)创建新的存放ocr和vote disk的磁盘组,磁盘组名和原有的一致(如果想改变位置,需修改/etc/oracle/ocr.loc文件)
备注:如发现无法创建等情况,可以采用如下删除磁盘组等排错思路
SQL> drop diskgroup disk_group_name force including contents;
4)还原ocr,并检查
# ocrconfig -restore file_name
# ocrcheck
5)恢复表决磁盘,并检查
# crsctl replace votedisk +asm_disk_group
# crsctl query css votedisk
6)停止独占模式运行的clusterware
# crsctl stop crs -f
7)所有节点正常启动clusterware
# crsctl start crs
8)CVU验证所有RAC节点OCR的完整性
$ cluvfy comp ocr -n all -verbose
下面开始演示操作,独占模式运行clusterware[root@12crac1bin]#./crsctlstartcrs-excl-nocrsCRS-4123:OracleHighAvailabilityServiceshasbeenstarted.CRS-2673:Attemptingtostop'ora.drivers.acfs'on'12crac2'CRS-2677:Stopof'ora.drivers.acfs'on'12crac2'succeededCRS-2672:Attemptingtostart'ora.evmd'on'12crac2'CRS-2672:Attemptingtostart'ora.mdnsd'on'12crac2'CRS-2676:Startof'ora.evmd'on'12crac2'succeededCRS-2676:Startof'ora.mdnsd'on'12crac2'succeededCRS-2672:Attemptingtostart'ora.gpnpd'on'12crac2'CRS-2676:Startof'ora.gpnpd'on'12crac2'succeededCRS-2672:Attemptingtostart'ora.cssdmonitor'on'12crac2'CRS-2672:Attemptingtostart'ora.gipcd'on'12crac2'CRS-2676:Startof'ora.cssdmonitor'on'12crac2'succeededCRS-2676:Startof'ora.gipcd'on'12crac2'succeededCRS-2672:Attemptingtostart'ora.cssd'on'12crac2'CRS-2672:Attemptingtostart'ora.diskmon'on'12crac2'CRS-2676:Startof'ora.diskmon'on'12crac2'succeededCRS-2676:Startof'ora.cssd'on'12crac2'succeededCRS-2672:Attemptingtostart'ora.drivers.acfs'on'12crac2'CRS-2672:Attemptingtostart'ora.cluster_interconnect.haip'on'12crac2'CRS-2672:Attemptingtostart'ora.ctssd'on'12crac2'CRS-2676:Startof'ora.drivers.acfs'on'12crac2'succeededCRS-2676:Startof'ora.ctssd'on'12crac2'succeededCRS-2676:Startof'ora.cluster_interconnect.haip'on'12crac2'succeededCRS-2672:Attemptingtostart'ora.asm'on'12crac2'CRS-2676:Startof'ora.asm'on'12crac2'succeeded通过grid用户登录sqlplus创建ASM磁盘组[grid@12crac2~]$sqlplus/assysasmSQL*Plus:Release12.1.0.1.0ProductiononSunJul2100:11:462013Copyright(c)1982,2013,Oracle.Allrightsreserved.Connectedto:OracleDatabase12cEnterpriseEditionRelease12.1.0.1.0-64bitProductionWiththeRealApplicationClustersandAutomaticStorageManagementoptionsSQL>creatediskgroupraccrsexternalredundancydisk'/dev/asm-extcrs'attribute'compatible.asm'='12.1.0.0.0';Diskgroupcreated.通过ocrconfig还原Ocr[root@12crac1bin]#./ocrconfig-import/home/grid/ocr.bak或者[root@12crac1bin]#./ocrconfig-restore/u01/app/12.1.0/grid/cdata/scan12c/backup00.ocr查看表决磁盘信息,当前无法找到[root@12crac1bin]#./crsctlquerycssvotediskLocated0votingdisk(s).恢复表决磁盘,可能会遇到如下问题[root@12crac1bin]#./crsctlreplacevotedisk+RACCRSCRS-4602:Failed27toaddvotingfile3782393479bf4f07bf313dc5a8f4c58a.Failedtoreplacevotingdiskgroupwith+RACCRS.CRS-4000:CommandReplacefailed,orcompletedwitherrors.此问题需要重新配置一下ASM的参数并重启ASM来解决。[grid@12crac1~]$sqlplus/assysasmSQL*Plus:Release12.1.0.1.0ProductiononSunJul2100:40:012013Copyright(c)1982,2013,Oracle.Allrightsreserved.Connectedto:OracleDatabase12cEnterpriseEditionRelease12.1.0.1.0-64bitProductionWiththeRealApplicationClustersandAutomaticStorageManagementoptionsSQL>altersystemsetasm_diskstring='/dev/asm*';Systemaltered.SQL>createspfilefrommemory;Filecreated.SQL>startupforcemount;ORA-32004:obsoleteordeprecatedparameter(s)specifiedforASMinstanceASMinstancestartedTotalSystemGlobalArea1135747072bytesFixedSize2297344bytesVariableSize1108283904bytesASMCache25165824bytesASMdiskgroupsmountedASMdiskgroupsvolumeenabled重新恢复表决磁盘[root@12crac1bin]#./crsctlreplacevotedisk+RACCRSSuccessfuladditionofvotingdisk1499cddff03a4f86bf01599718febcb1.Successfullyreplacedvotingdiskgroupwith+RACCRS.CRS-4266:Votingfile(s)successfullyreplaced[root@12crac1bin]#./crsctlquerycssvotedisk##STATEFileUniversalIdFileNameDiskgroup------------------------------------------1.ONLINE1499cddff03a4f86bf01599718febcb1(/dev/asm-extcrs)[RACCRS]Located1votingdisk(s).退出独占模式:[root@12crac1bin]#./crsctlstopcrs-fCRS-2791:StartingshutdownofOracleHighAvailabilityServices-managedresourceson'12crac1'CRS-2673:Attemptingtostop'ora.ctssd'on'12crac1'CRS-2673:Attemptingtostop'ora.mdnsd'on'12crac1'CRS-2673:Attemptingtostop'ora.drivers.acfs'on'12crac1'CRS-2673:Attemptingtostop'ora.gpnpd'on'12crac1'CRS-2677:Stopof'ora.drivers.acfs'on'12crac1'succeededCRS-2677:Stopof'ora.mdnsd'on'12crac1'succeededCRS-2677:Stopof'ora.gpnpd'on'12crac1'succeededCRS-2677:Stopof'ora.ctssd'on'12crac1'succeededCRS-2673:Attemptingtostop'ora.evmd'on'12crac1'CRS-2673:Attemptingtostop'ora.asm'on'12crac1'CRS-2677:Stopof'ora.evmd'on'12crac1'succeededCRS-2677:Stopof'ora.asm'on'12crac1'succeededCRS-2673:Attemptingtostop'ora.cluster_interconnect.haip'on'12crac1'CRS-2677:Stopof'ora.cluster_interconnect.haip'on'12crac1'succeededCRS-2673:Attemptingtostop'ora.cssd'on'12crac1'CRS-2677:Stopof'ora.cssd'on'12crac1'succeededCRS-2673:Attemptingtostop'ora.gipcd'on'12crac1'CRS-2677:Stopof'ora.gipcd'on'12crac1'succeededCRS-2793:ShutdownofOracleHighAvailabilityServices-managedresourceson'12crac1'hascompletedCRS-4133:OracleHighAvailabilityServiceshasbeenstopped.所有节点都正常启动:[root@12crac1bin]#./crsctlstarthasCRS-4123:OracleHighAvailabilityServiceshasbeenstarted.[root@12crac2bin]#./crsctlstarthasCRS-4123:OracleHighAvailabilityServiceshasbeenstarted.查看clusterware运行状态[grid@12crac1~]$crsctlcheckcrsCRS-4638:OracleHighAvailabilityServicesisonlineCRS-4537:ClusterReadyServicesisonlineCRS-4529:ClusterSynchronizationServicesisonlineCRS-4533:EventManagerisonline[grid@12crac2~]$crsctlcheckcrsCRS-4638:OracleHighAvailabilityServicesisonlineCRS-4537:ClusterReadyServicesisonlineCRS-4529:ClusterSynchronizationServicesisonlineCRS-4533:EventManagerisonline查看所有资源状态[grid@12crac1~]$crsctlstatres-t--------------------------------------------------------------------------------NameTargetStateServerStatedetails--------------------------------------------------------------------------------LocalResources--------------------------------------------------------------------------------ora.LISTENER.lsnrONLINEONLINE12crac1STABLEONLINEONLINE12crac2STABLEora.RACCRS.dgONLINEONLINE12crac1STABLEONLINEONLINE12crac2STABLEora.RACDATA.dgONLINEONLINE12crac1STABLEONLINEONLINE12crac2STABLEora.RACFRA.dgONLINEONLINE12crac1STABLEONLINEONLINE12crac2STABLEora.asmONLINEONLINE12crac1Started,STABLEONLINEONLINE12crac2Started,STABLEora.net1.networkONLINEONLINE12crac1STABLEONLINEONLINE12crac2STABLEora.onsONLINEONLINE12crac1STABLEONLINEONLINE12crac2STABLE--------------------------------------------------------------------------------ClusterResources--------------------------------------------------------------------------------ora.12crac1.vip1ONLINEONLINE12crac1STABLEora.12crac2.vip1ONLINEONLINE12crac2STABLEora.LISTENER_SCAN1.lsnr1ONLINEONLINE12crac2STABLEora.LISTENER_SCAN2.lsnr1ONLINEONLINE12crac1STABLEora.LISTENER_SCAN3.lsnr1ONLINEONLINE12crac1STABLEora.MGMTLSNR1ONLINEONLINE12crac2169.254.171.71192.168.80.154,STABLEora.cvu1ONLINEONLINE12crac1STABLEora.luocs12c.db1ONLINEONLINE12crac2Open,STABLE2ONLINEONLINE12crac1Open,STABLEora.mgmtdb1ONLINEOFFLINEInstanceShutdown,STABLEora.oc4j1ONLINEONLINE12crac1STABLEora.scan1.vip1ONLINEONLINE12crac2STABLEora.scan2.vip1ONLINEONLINE12crac1STABLEora.scan3.vip1ONLINEONLINE12crac1STABLE--------------------------------------------------------------------------------
在这里我们会发现mgmtdb没有正常启动,手动尝试启动,会遇到问题。
[grid@12crac1~]$srvctlstartmgmtdbPRCR-1079:Failedtostartresourceora.mgmtdbCRS-5017:Theresourceaction"ora.mgmtdbstart"encounteredthefollowingerror:ORA-01078:failureinprocessingsystemparametersLRM-00109:couldnotopenparameterfile'/u01/app/12.1.0/grid/dbs/init-MGMTDB.ora'.Fordetailsreferto"(:CLSN00107:)"in"/u01/app/12.1.0/grid/log/12crac2/agent/crsd/oraagent_grid/oraagent_grid.log".CRS-2674:Startof'ora.mgmtdb'on'12crac2'failedCRS-5017:Theresourceaction"ora.mgmtdbstart"encounteredthefollowingerror:ORA-01078:failureinprocessingsystemparametersORA-01565:errorinidentifyingfile'+RACCRS/_mgmtdb/spfile-MGMTDB.ora'ORA-17503:ksfdopn:2Failedtoopenfile+RACCRS/_mgmtdb/spfile-MGMTDB.oraORA-15056:additionalerrormessageORA-17503:ksfdopn:2Failedtoopenfile+RACCRS/_mgmtdb/spfile-mgmtdb.oraORA-15173:entry'_mgmtdb'doesnotexistindirectory'/'ORA-06512:atline4.Fordetailsreferto"(:CLSN00107:)"in"/u01/app/12.1.0/grid/log/12crac1/agent/crsd/oraagent_grid/oraagent_grid.log".CRS-2674:Startof'ora.mgmtdb'on'12crac1'failedCRS-2632:Therearenomoreserverstotrytoplaceresource'ora.mgmtdb'onthatwouldsatisfyitsplacementpolicy
– 此问题造成原因是,我们dd了存放ocr的ASM磁盘组之后,里面的_MGMTDB相关文件也都将损坏丢失。从报错信息可见无法找到参数文件。
查看mgmtdb配置信息
[grid@12crac1~]$srvctlconfigmgmtdb-all-verboseDatabaseuniquename:_mgmtdbDatabasename:Oraclehome:/u01/app/12.1.0/gridOracleuser:gridSpfile:+RACCRS/_mgmtdb/spfile-MGMTDB.oraPasswordfile:Domain:Startoptions:openStopoptions:immediateDatabaserole:PRIMARYManagementpolicy:AUTOMATICDatabaseinstance:-MGMTDBType:ManagementDatabaseisenabled
目前还不知如何修复mgmtdb的方法,因此我remove了下
[grid@12crac1~]$srvctlremovemgmtdbRemovethedatabase_mgmtdb?(y/[n])y[grid@12crac1~]$crsctlstatres-t--------------------------------------------------------------------------------NameTargetStateServerStatedetails--------------------------------------------------------------------------------LocalResources--------------------------------------------------------------------------------ora.LISTENER.lsnrONLINEONLINE12crac1STABLEONLINEONLINE12crac2STABLEora.RACCRS.dgONLINEONLINE12crac1STABLEONLINEONLINE12crac2STABLEora.RACDATA.dgONLINEONLINE12crac1STABLEONLINEONLINE12crac2STABLEora.RACFRA.dgONLINEONLINE12crac1STABLEONLINEONLINE12crac2STABLEora.asmONLINEONLINE12crac1Started,STABLEONLINEONLINE12crac2Started,STABLEora.net1.networkONLINEONLINE12crac1STABLEONLINEONLINE12crac2STABLEora.onsONLINEONLINE12crac1STABLEONLINEONLINE12crac2STABLE--------------------------------------------------------------------------------ClusterResources--------------------------------------------------------------------------------ora.12crac1.vip1ONLINEONLINE12crac1STABLEora.12crac2.vip1ONLINEONLINE12crac2STABLEora.LISTENER_SCAN1.lsnr1ONLINEONLINE12crac2STABLEora.LISTENER_SCAN2.lsnr1ONLINEONLINE12crac2STABLEora.LISTENER_SCAN3.lsnr1ONLINEONLINE12crac2STABLEora.MGMTLSNR1ONLINEONLINE12crac2169.254.171.71192.168.80.154,STABLEora.cvu1ONLINEONLINE12crac1STABLEora.luocs12c.db1ONLINEONLINE12crac2Open,STABLE2ONLINEONLINE12crac1Open,STABLEora.oc4j1ONLINEONLINE12crac1STABLEora.scan1.vip1ONLINEONLINE12crac2STABLEora.scan2.vip1ONLINEONLINE12crac2STABLEora.scan3.vip1ONLINEONLINE12crac2STABLE--------------------------------------------------------------------------------
到此,相信大家对“Oracle Database 12c RAC损坏ocr和votedisk恢复实例教程”有了更深的了解,不妨来实际操作一番吧!这里是亿速云网站,更多相关内容可以进入相关频道进行查询,关注我们,继续学习!
声明:本站所有文章资源内容,如无特殊说明或标注,均为采集网络资源。如若本站内容侵犯了原著者的合法权益,可联系本站删除。