在11.2或者12.1的RAC中,ocr和votedisk可以放到asm中,而很多人安装系统把ocr和votedisk放到一个单独的asm 磁盘组里面,但是如果这个磁盘组坏了,而数据所在的磁盘组是好的,这个时候该怎么恢复呢？这里的恢复分两种情况，一种是有ocr备份的恢复,另外一种是无ocr备份的恢复。但是在一般情况下ocr是每4个小时自动备份一份，因此大部分的系统中都会有ocr的备份。本blog主要对于Oracle 12c rac在有ocr备份，存储ocr,votedisk的asm磁盘组异常恢复
确定ocr,votedisk,asm spfile存在一个独立asm diskgroup中Linux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm在CentOS 6.4下安装Oracle 11gR2（x64） http://www.linuxidc.com/Linux/2014-02/97374.htmOracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htmDebian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm
[grid@linuxidc ~]$ ocrcheckStatus of Oracle Cluster Registry is as follows :Version : 4Total space （kbytes） : 409568Used space （kbytes） : 1360Available space （kbytes） : 408208ID : 2132096904Device/FileName : +DG_SYSDevice/Fileintegrity check succeeded Device/Filenot configured Device/Filenot configured Device/Filenot configured Device/Filenot configured Cluster registry integrity check succeeded Logical corruption check bypassed due to non-privileged user SQL> show parameter spfile; NAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile string +DG_SYS/xff-cluster/ASMPARAMETERFILE/registry.253.825628977 [grid@linuxidc ~]$ crsctl query css votedisk-- ----- ----------------- --------- ---------1. ONLINE 3e20d13ae98a4fcfbffa489ab4df68a3 （/dev/sdc2） [DG_SYS]Located 1 voting disk（s）. ASMCMD> lsdsk -t -G dg_sysCreate_Date Mount_Date Repair_Timer Path08-SEP-13 08-SEP-13 0 /dev/sdc2 |
查看当前rac状态[grid@linuxidc ~]$ crsctl status res -t--------------------------------------------------------------------------------Name Target State Server State details --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.ASMNET1LSNR_ASM.lsnrONLINE ONLINE linuxidc STABLEora.DATA.dgONLINE ONLINE linuxidc STABLEora.LISTENER.lsnrONLINE ONLINE linuxidc STABLEora.net1.networkONLINE ONLINE linuxidc STABLEora.onsONLINE ONLINE linuxidc STABLEora.proxy_advmONLINE OFFLINE linuxidc STABLE--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr1 ONLINE ONLINE linuxidc STABLEora.MGMTLSNR1 ONLINE ONLINE linuxidc 169.254.196.108 10.10.30.22,STABLEora.asm1 ONLINE ONLINE linuxidc Started,STABLE2 OFFLINE OFFLINE STABLE3 OFFLINE OFFLINE STABLEora.cdb.db1 ONLINE ONLINE linuxidc Open,STABLEora.cvu1 ONLINE ONLINE linuxidc STABLEora.oc4j1 ONLINE ONLINE linuxidc STABLEora.scan1.vip1 ONLINE ONLINE linuxidc STABLEora.linuxidc.vip1 ONLINE ONLINE linuxidc STABLE-------------------------------------------------------------------------------- |
kfed查看磁盘头[grid@linuxidc ~]$ kfedread /dev/sdc2kfbh.endian: 1 ; 0x000: 0x01kfbh.hard: 130 ; 0x001: 0x82kfbh.type: 1 ; 0x002: KFBTYP_DISKHEADkfbh.datfmt: 1 ; 0x003: 0x01kfbh.block.blk: 0 ; 0x004: blk=0kfbh.block.obj: 2147483648 ; 0x008: disk=0kfbh.check: 2879801080 ; 0x00c: 0xaba646f8kfbh.fcn.base: 0 ; 0x010: 0x00000000kfbh.fcn.wrap: 0 ; 0x014: 0x00000000kfbh.spare1: 0 ; 0x018: 0x00000000kfbh.spare2: 0 ; 0x01c: 0x00000000kfdhdb.driver.provstr: ORCLDISK ; 0x000: length=8kfdhdb.driver.reserved[0]: 0 ; 0x008: 0x00000000kfdhdb.driver.reserved[1]: 0 ; 0x00c: 0x00000000kfdhdb.driver.reserved[2]: 0 ; 0x010: 0x00000000kfdhdb.driver.reserved[3]: 0 ; 0x014: 0x00000000kfdhdb.driver.reserved[4]: 0 ; 0x018: 0x00000000kfdhdb.driver.reserved[5]: 0 ; 0x01c: 0x00000000kfdhdb.compat: 202375168 ; 0x020: 0x0c100000kfdhdb.dsknum: 0 ; 0x024: 0x0000kfdhdb.grptyp: 1 ; 0x026: KFDGTP_EXTERNALkfdhdb.hdrsts: 3 ; 0x027: KFDHDR_MEMBERkfdhdb.dskname: DG_SYS_0000 ; 0x028: length=11kfdhdb.grpname: DG_SYS ; 0x048: length=6kfdhdb.fgname: DG_SYS_0000 ; 0x068: length=11kfdhdb.capname: ; 0x088: length=0kfdhdb.crestmp.hi: 32990483 ; 0x0a8: HOUR=0x13 DAYS=0x8 MNTH=0x9 YEAR=0x7ddkfdhdb.crestmp.lo: 303455232 ; 0x0ac: USEC=0x0 MSEC=0x197 SECS=0x21 MINS=0x4kfdhdb.mntstmp.hi: 32990485 ; 0x0b0: HOUR=0x15 DAYS=0x8 MNTH=0x9 YEAR=0x7ddkfdhdb.mntstmp.lo: 1776845824 ; 0x0b4: USEC=0x0 MSEC=0x221 SECS=0x1e MINS=0x1akfdhdb.secsize: 512 ; 0x0b8: 0x0200kfdhdb.blksize: 4096 ; 0x0ba: 0x1000kfdhdb.ausize: 1048576 ; 0x0bc: 0x00100000kfdhdb.mfact: 113792 ; 0x0c0: 0x0001bc80kfdhdb.dsksize: 5451 ; 0x0c4: 0x0000154bkfdhdb.pmcnt: 3 ; 0x0c8: 0x00000003kfdhdb.fstlocn: 1 ; 0x0cc: 0x00000001kfdhdb.altlocn: 2 ; 0x0d0: 0x00000002kfdhdb.f1b1locn: 10 ; 0x0d4: 0x0000000akfdhdb.redomirrors[0]: 0 ; 0x0d8: 0x0000kfdhdb.redomirrors[1]: 0 ; 0x0da: 0x0000kfdhdb.redomirrors[2]: 0 ; 0x0dc: 0x0000kfdhdb.redomirrors[3]: 0 ; 0x0de: 0x0000kfdhdb.dbcompat: 168820736 ; 0x0e0: 0x0a100000kfdhdb.grpstmp.hi: 32990483 ; 0x0e4: HOUR=0x13 DAYS=0x8 MNTH=0x9 YEAR=0x7ddkfdhdb.grpstmp.lo: 301063168 ; 0x0e8: USEC=0x0 MSEC=0x77 SECS=0x1f MINS=0x4kfdhdb.vfstart: 224 ; 0x0ec: 0x000000e0kfdhdb.vfend: 256 ; 0x0f0: 0x00000100kfdhdb.spfile: 219 ; 0x0f4: 0x000000db ----asm spfile的起点kfdhdb.spfflg: 1 ; 0x0f8: 0x00000001kfdhdb.flags: 1 ; 0x0fc: 0x00000001 |
备份ocr[root@linuxidc xff-cluster] linuxidc 2013/09/0823:48:57 /u01/app/12.1/grid/product/cdata/xff-cluster/backup_20130908_234857.ocr [root@linuxidc xff-cluster] linuxidc 2013/08/0821:11:00 /u01/app/12.1/grid/product/cdata/xifenfe-cluster/backup00.ocr linuxidc 2013/08/0817:10:56 /u01/app/12.1/grid/product/cdata/xifenfe-cluster/backup01.ocr linuxidc 2013/07/0820:23:18 /u01/app/12.1/grid/product/cdata/xifenfe-cluster/backup02.ocr linuxidc 2013/08/0817:10:56 /u01/app/12.1/grid/product/cdata/xifenfe-cluster/day.ocr linuxidc 2013/08/0817:10:56 /u01/app/12.1/grid/product/cdata/xifenfe-cluster/week.ocr linuxidc 2013/09/0823:48:57 /u01/app/12.1/grid/product/cdata/xff-cluster/backup_20130908_234857.ocr linuxidc 2013/06/2822:55:02 /u01/app/12.1/grid/product/cdata/xifenfe-cluster/backup_20130628_225502.ocr |
破坏asm disk[grid@linuxidc ~]$dd if=/dev/zeroof=/dev/sdc2 bs=4096 count=11+0 records in1+0 records out4096 bytes （4.1 kB） copied, 6.6061e-05 seconds, 62.0 MB/s |
关闭crs[root@linuxidc xff-cluster] |
启动crs[root@linuxidc xff-cluster]CRS-4123: Oracle High Availability Services has been started. [grid@linuxidc admin]$ crsctl status res -t -init--------------------------------------------------------------------------------Name Target State Server State details --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.asm1 ONLINE OFFLINE Instance Shutdown,STABLEora.cluster_interconnect.haip1 ONLINE OFFLINE STABLEora.crf1 ONLINE OFFLINE STABLEora.crsd1 ONLINE OFFLINE STABLEora.cssd1 ONLINE OFFLINE linuxidc STARTINGora.cssdmonitor1 ONLINE ONLINE linuxidc STABLEora.ctssd1 ONLINE OFFLINE STABLEora.diskmon1 OFFLINE OFFLINE STABLEora.drivers.acfs1 ONLINE ONLINE linuxidc STABLEora.evmd1 ONLINE INTERMEDIATE linuxidc STABLEora.gipcd1 ONLINE ONLINE linuxidc STABLEora.gpnpd1 ONLINE ONLINE linuxidc STABLEora.mdnsd1 ONLINE ONLINE linuxidc STABLEora.storage1 ONLINE OFFLINE STABLE-------------------------------------------------------------------------------- |
GI相关日志--alert日志2013-09-08 23:53:37.662:[gpnpd（1507）]CRS-2328:GPNPD started on node linuxidc.2013-09-08 23:54:10.244:[cssd（1584）]CRS-1713:CSSD daemon is startedin hub mode2013-09-08 23:54:10.915:[cssd（1584）]CRS-1714:Unable to discover any voting files, retrying discoveryin 15 seconds; Details at （:CSSNM00070:）in /u01/app/12.1/grid/product/log/linuxidc/cssd/ocssd.log2013-09-08 23:54:11.183:[ohasd（1367）]CRS-2767:Resource state recovery not attemptedfor "ora.diskmon"as its target state is OFFLINE2013-09-08 23:54:11.183:[ohasd（1367）]CRS-2769:Unable to failover resource"ora.diskmon".2013-09-08 23:54:26.044:[cssd（1584）]CRS-1714:Unable to discover any voting files, retrying discoveryin 15 seconds; Details at （:CSSNM00070:）in /u01/app/12.1/grid/product/log/linuxidc/cssd/ocssd.log2013-09-08 23:54:41.146:[cssd（1584）]CRS-1714:Unable to discover any voting files, retrying discoveryin 15 seconds; Details at （:CSSNM00070:）in /u01/app/12.1/grid/product/log/linuxidc/cssd/ocssd.log2013-09-08 23:54:56.195:[cssd（1584）]CRS-1714:Unable to discover any voting files, retrying discoveryin 15 seconds; Details at （:CSSNM00070:）in /u01/app/12.1/grid/product/log/linuxidc/cssd/ocssd.log --ocssd日志2013-09-08 23:54:25.976: [ GPNP][1090226496]clsgpnp_profileCallUrlInt: [at clsgpnp.c:2360] Result: （0） CLSGPNP_OK. Successful get-profile CALL to remote"ipc://GPNPD_linuxidc" disco ""2013-09-08 23:54:25.976: [ CSSD][1090226496]clssnmReadDiscoveryProfile: votingfile discovery string（/dev/sd*）2013-09-08 23:54:25.976: [ CSSD][1090226496]clssnmvDDiscThread: using discovery string/dev/sd* forinitial discovery2013-09-08 23:54:25.976: [ SKGFD][1090226496]Discovery with str:/dev/sd*: 2013-09-08 23:54:25.976: [ SKGFD][1090226496]UFS discovery with :/dev/sd*: 2013-09-08 23:54:26.032: [ SKGFD][1090226496]Fetching UFS disk :/dev/sdc: 2013-09-08 23:54:26.037: [ SKGFD][1090226496]Fetching UFS disk :/dev/sdc1: 2013-09-08 23:54:26.037: [ SKGFD][1090226496]Fetching UFS disk :/dev/sdb: 2013-09-08 23:54:26.037: [ SKGFD][1090226496]Fetching UFS disk :/dev/sdc2: 2013-09-08 23:54:26.037: [ SKGFD][1090226496]Fetching UFS disk :/dev/sdd: 2013-09-08 23:54:26.037: [ SKGFD][1090226496]Fetching UFS disk :/dev/sdd1: 2013-09-08 23:54:26.037: [ SKGFD][1090226496]Fetching UFS disk :/dev/sda: 2013-09-08 23:54:26.037: [ SKGFD][1090226496]Fetching UFS disk :/dev/sda1: 2013-09-08 23:54:26.037: [ SKGFD][1090226496]Fetching UFS disk :/dev/sda2: 2013-09-08 23:54:26.037: [ SKGFD][1090226496]OSS discovery with :/dev/sd*: 2013-09-08 23:54:26.042: [ SKGFD][1090226496]Handle 0x1d65c10 from lib :UFS::for disk :/dev/sdb: 2013-09-08 23:54:26.043: [ SKGFD][1090226496]Handle 0x20c95a0 from lib :UFS::for disk :/dev/sdc2: 2013-09-08 23:54:26.043: [ SKGFD][1090226496]Handle 0x20c9dd0 from lib :UFS::for disk :/dev/sdd: 2013-09-08 23:54:26.044: [ SKGFD][1090226496]Lib :UFS:: closing handle 0x1d65c10for disk :/dev/sdb: 2013-09-08 23:54:26.044: [ SKGFD][1090226496]Lib :UFS:: closing handle 0x20c95a0for disk :/dev/sdc2: 2013-09-08 23:54:26.044: [ SKGFD][1090226496]Lib :UFS:: closing handle 0x20c9dd0for disk :/dev/sdd: 2013-09-08 23:54:26.044: [ CSSD][1090226496]clssnmvDiskVerify: Successful discovery of 0 disks2013-09-08 23:54:26.044: [ CSSD][1090226496]clssnmCompleteInitVFDiscovery: Completing initial votingfile discovery2013-09-08 23:54:26.044: [ CSSD][1090226496]clssnmvFindInitialConfigs: No voting files found2013-09-08 23:54:26.044: [ CSSD][1090226496]（:CSSNM00070:）clssnmCompleteInitVFDiscovery: Votingfile not found. Retrying discoveryin 15 seconds |
在我们破坏了ocr所在的asm disk的磁盘后,启动crs明显提示无法找到votedisk信息
强制关闭crs[root@linuxidc xff-cluster]CRS-2791: Startingshutdown of Oracle High Availability Services-managed resources on"linuxidc"CRS-2673: Attempting to stop"ora.mdnsd" on "linuxidc"CRS-2673: Attempting to stop"ora.drivers.acfs" on "linuxidc"CRS-2677: Stop of "ora.drivers.acfs" on "linuxidc" succeededCRS-2677: Stop of "ora.mdnsd" on "linuxidc"succeededCRS-2673: Attempting to stop"ora.gpnpd" on "linuxidc"CRS-2673: Attempting to stop"ora.gipcd" on "linuxidc"CRS-2673: Attempting to stop"ora.evmd" on "linuxidc"CRS-2677: Stop of"ora.gpnpd" on "linuxidc" succeededCRS-2677: Stop of"ora.gipcd" on "linuxidc" succeededCRS-2677: Stop of"ora.evmd" on "linuxidc" succeededCRS-2793: Shutdown of Oracle High Availability Services-managed resources on"linuxidc" has completedCRS-4133: Oracle High Availability Services has been stopped. |
exclusive模式启动crs[root@linuxidc xff-cluster]CRS-4123: Oracle High Availability Services has been started.CRS-2673: Attempting to stop"ora.drivers.acfs" on "linuxidc"CRS-2677: Stop of "ora.drivers.acfs" on "linuxidc" succeededCRS-2672: Attempting to start"ora.evmd" on "linuxidc"CRS-2672: Attempting to start"ora.mdnsd" on "linuxidc"CRS-2676: Start of"ora.evmd" on "linuxidc" succeededCRS-2676: Start of"ora.mdnsd" on "linuxidc" succeededCRS-2672: Attempting to start"ora.gpnpd" on "linuxidc"CRS-2676: Start of"ora.gpnpd" on "linuxidc" succeededCRS-2672: Attempting to start"ora.cssdmonitor" on "linuxidc"CRS-2672: Attempting to start"ora.gipcd" on "linuxidc"CRS-2676: Start of"ora.cssdmonitor" on "linuxidc" succeededCRS-2676: Start of"ora.gipcd" on "linuxidc" succeededCRS-2672: Attempting to start"ora.cssd" on "linuxidc"CRS-2672: Attempting to start"ora.diskmon" on"linuxidc"CRS-2676: Start of"ora.diskmon" on"linuxidc" succeededCRS-2676: Start of"ora.cssd" on "linuxidc" succeededCRS-2672: Attempting to start"ora.drivers.acfs" on "linuxidc"CRS-2672: Attempting to start"ora.cluster_interconnect.haip" on "linuxidc"CRS-2672: Attempting to start"ora.ctssd" on "linuxidc"CRS-2676: Start of"ora.ctssd" on "linuxidc" succeededCRS-2676: Start of"ora.cluster_interconnect.haip" on "linuxidc" succeededCRS-2676: Start of"ora.drivers.acfs" on "linuxidc" succeededCRS-2672: Attempting to start"ora.asm" on "linuxidc"CRS-2676: Start of"ora.asm" on "linuxidc" succeeded [grid@linuxidc linuxidc]$ crsctl stat res -t -init--------------------------------------------------------------------------------Name Target State Server State details --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.asm1 ONLINE INTERMEDIATE linuxidc OCR not started,STABLEora.cluster_interconnect.haip1 ONLINE ONLINE linuxidc STABLEora.crf1 OFFLINE OFFLINE STABLEora.crsd1 OFFLINE OFFLINE STABLEora.cssd1 ONLINE ONLINE linuxidc STABLEora.cssdmonitor1 ONLINE ONLINE linuxidc STABLEora.ctssd1 ONLINE ONLINE linuxidc ACTIVE:0,STABLEora.diskmon1 OFFLINE OFFLINE STABLEora.drivers.acfs1 ONLINE ONLINE linuxidc STABLEora.evmd1 ONLINE INTERMEDIATE linuxidc STABLEora.gipcd1 ONLINE ONLINE linuxidc STABLEora.gpnpd1 ONLINE ONLINE linuxidc STABLEora.mdnsd1 ONLINE ONLINE linuxidc STABLEora.storage1 OFFLINE OFFLINE STABLE |
创建磁盘组[grid@linuxidc linuxidc]$ sqlplus /as sysasm SQL*Plus: Release 12.1.0.1.0 Productionon Mon Sep 9 00:23:40 2013 Copyright （c） 1982, 2013, Oracle. All rights reserved. Connected to:Oracle Database12c Enterprise Edition Release 12.1.0.1.0 - 64bit ProductionWith the Real Application Clustersand Automatic Storage Management options SQL> creatediskgroup DG_OCR external redundancy disk "/dev/sdc2"attribute "COMPATIBLE.ASM"= "12.1.0"; Diskgroup created. [root@linuxidc xff-cluster]# ls -ltotal 1472-rw-r[root@linuxidc xff-cluster]# ocrconfig -restore backup_20130908_234857.ocrPROT-35: The configured OCR locations arenot accessible SQL> conn / as sysasmConnected.SQL> dropdiskgroup DG_OCR forceincluding contents; Diskgroup dropped. SQL> creatediskgroup DG_SYS external redundancy disk "/dev/sdc2"attribute "COMPATIBLE.ASM"= "12.1.0"; Diskgroup created. |
为了操作方便,建议创建磁盘组和以前ocr所在异常的磁盘组一致
还原ocr[root@linuxidc xff-cluster] --ALERT 日志2013-09-09 00:26:50.584:[client（3015）]CRS-1002:The OCR was restored fromfile backup_20130908_234857.ocr. |
处理votedisk[root@linuxidc xff-cluster]Successful addition of voting disk 60a037da30714f6bbfe5d90206ff27a7.Successfully replaced voting disk group with +DG_SYS.CRS-4266: Voting file（s） successfully replaced |
创建asm spfile[grid@linuxidc dbs]$vi /tmp/asm.txtinstance_type="asm"large_pool_size=12Mremote_login_passwordfile="EXCLUSIVE"asm_diskstring ="/dev/sd*"asm_power_limit = 1 [grid@linuxidc dbs]$ sqlplus"/ as sysasm" SQL*Plus: Release 12.1.0.1.0 Production on Mon Sep 9 00:34:18 2013 Copyright （c） 1982, 2013, Oracle. All rights reserved. Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit ProductionWith the Real Application Clusters and Automatic Storage Management options SQL> create spfile="+DG_SYS"FROM pfile="/tmp/asm.txt"; File created. |
重启crs[root@linuxidc xff-cluster] [root@linuxidc xff-cluster]CRS-4123: Oracle High Availability Services has been started. [grid@linuxidc dbs]$ crsctl status res -t--------------------------------------------------------------------------------Name Target State Server State details --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.ASMNET1LSNR_ASM.lsnrONLINE ONLINE linuxidc STABLEora.DATA.dgONLINE ONLINE linuxidc STABLEora.LISTENER.lsnrONLINE ONLINE linuxidc STABLEora.net1.networkONLINE ONLINE linuxidc STABLEora.onsONLINE ONLINE linuxidc STABLEora.proxy_advmONLINE OFFLINE linuxidc STABLE--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr1 ONLINE ONLINE linuxidc STABLEora.MGMTLSNR1 ONLINE ONLINE linuxidc 169.254.196.108 10.10.30.22,STABLEora.asm1 ONLINE ONLINE linuxidc Started,STABLE2 OFFLINE OFFLINE STABLE3 OFFLINE OFFLINE STABLEora.cdb.db1 ONLINE ONLINE linuxidc Open,STABLEora.cvu1 ONLINE ONLINE linuxidc STABLEora.oc4j1 ONLINE ONLINE linuxidc STABLEora.scan1.vip1 ONLINE ONLINE linuxidc STABLEora.linuxidc.vip1 ONLINE ONLINE linuxidc STABLE-------------------------------------------------------------------------------- |
这里crs已经恢复正常，进一步检查ocr,votedisk,asm spfile情况
[grid@linuxidc ~]$ ocrcheckStatus of Oracle Cluster Registry is as follows :Version : 4Total space （kbytes） : 409568Used space （kbytes） : 1380Available space （kbytes） : 408188ID : 2132096904Device/FileName : +DG_SYSDevice/Fileintegrity check succeeded Device/Filenot configured Device/Filenot configured Device/Filenot configured Device/Filenot configured Cluster registry integrity check succeeded Logical corruption check bypassed due to non-privileged user [grid@linuxidc ~]$ sqlplus / as sysasm SQL*Plus: Release 12.1.0.1.0 Production on Mon Sep 9 16:12:21 2013 Copyright （c） 1982, 2013, Oracle. All rights reserved. Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit ProductionWith the Real Application Clusters and Automatic Storage Management options SQL> show parameter spfile; NAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile string +DG_SYS/xff-cluster/ASMPARAMETERFILE/registry.253.825640465SQL> exitDisconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit ProductionWith the Real Application Clusters and Automatic Storage Management options[grid@linuxidc ~]$ crsctl query css votedisk-- ----- ----------------- --------- ---------1. ONLINE 60a037da30714f6bbfe5d90206ff27a7 （/dev/sdc2） [DG_SYS]Located 1 voting disk（s）. |
至此在ocr 磁盘组异常,而有ocr备份的情况下故障恢复完毕，对于没有ocr备份的故障，只能通过重建ocr来完成，大概步骤为
--deconfigure（root）remote node lastnode --配置信息重建ocr等（grid） |
更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12
本文永久更新链接地址 
易网时代-编程资源站