本篇内容主要讲解“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恢复实例教程”有了更深的了解，不妨来实际操作一番吧！这里是亿速云网站，更多相关内容可以进入相关频道进行查询，关注我们，继续学习！