Oracle RAC OCR 磁盘组异常恢复
来源：互联网 发布：编程语言难度排名 编辑：程序博客网 时间：2024/05/22 08:12
在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中
[grid@xifenfei ~]$ ocrcheckStatus of Oracle Cluster Registry is as follows : Version : 4 Total space (kbytes) : 409568 Used space (kbytes) : 1360 Available space (kbytes) : 408208 ID : 2132096904 Device/FileName : +DG_SYS Device/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 userSQL> show parameter spfile;NAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile string +DG_SYS/xff-cluster/ASMPARAMET ERFILE/registry.253.825628977[grid@xifenfei ~]$ crsctl query css votedisk## STATE File Universal Id File Name Disk group-- ----- ----------------- --------- ---------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@xifenfei ~]$ crsctl status res -t--------------------------------------------------------------------------------Name Target State Server State details --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.ASMNET1LSNR_ASM.lsnr ONLINE ONLINE xifenfei STABLEora.DATA.dg ONLINE ONLINE xifenfei STABLEora.LISTENER.lsnr ONLINE ONLINE xifenfei STABLEora.net1.network ONLINE ONLINE xifenfei STABLEora.ons ONLINE ONLINE xifenfei STABLEora.proxy_advm ONLINE OFFLINE xifenfei STABLE--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE xifenfei STABLEora.MGMTLSNR 1 ONLINE ONLINE xifenfei 169.254.196.108 10.1 0.30.22,STABLEora.asm 1 ONLINE ONLINE xifenfei Started,STABLE 2 OFFLINE OFFLINE STABLE 3 OFFLINE OFFLINE STABLEora.cdb.db 1 ONLINE ONLINE xifenfei Open,STABLEora.cvu 1 ONLINE ONLINE xifenfei STABLEora.oc4j 1 ONLINE ONLINE xifenfei STABLEora.scan1.vip 1 ONLINE ONLINE xifenfei STABLEora.xifenfei.vip 1 ONLINE ONLINE xifenfei STABLE--------------------------------------------------------------------------------kfed查看磁盘头
[grid@xifenfei ~]$ 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@xifenfei xff-cluster]# ocrconfig -manualbackupxifenfei 2013/09/0823:48:57 /u01/app/12.1/grid/product/cdata/xff-cluster/backup_20130908_234857.ocr[root@xifenfei xff-cluster]# ocrconfig -showbackupxifenfei 2013/08/0821:11:00 /u01/app/12.1/grid/product/cdata/xifenfe-cluster/backup00.ocrxifenfei 2013/08/0817:10:56 /u01/app/12.1/grid/product/cdata/xifenfe-cluster/backup01.ocrxifenfei 2013/07/0820:23:18 /u01/app/12.1/grid/product/cdata/xifenfe-cluster/backup02.ocrxifenfei 2013/08/0817:10:56 /u01/app/12.1/grid/product/cdata/xifenfe-cluster/day.ocrxifenfei 2013/08/0817:10:56 /u01/app/12.1/grid/product/cdata/xifenfe-cluster/week.ocrxifenfei 2013/09/0823:48:57 /u01/app/12.1/grid/product/cdata/xff-cluster/backup_20130908_234857.ocrxifenfei 2013/06/2822:55:02 /u01/app/12.1/grid/product/cdata/xifenfe-cluster/backup_20130628_225502.ocr破坏asm disk
[grid@xifenfei ~]$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@xifenfei xff-cluster]# crsctl stop crs启动crs
[root@xifenfei xff-cluster]# crsctl start crsCRS-4123: Oracle High Availability Services has been started.[grid@xifenfei admin]$ crsctl status res -t -init--------------------------------------------------------------------------------Name Target State Server State details --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.asm 1 ONLINE OFFLINE Instance Shutdown,ST ABLEora.cluster_interconnect.haip 1 ONLINE OFFLINE STABLEora.crf 1 ONLINE OFFLINE STABLEora.crsd 1 ONLINE OFFLINE STABLEora.cssd 1 ONLINE OFFLINE xifenfei STARTINGora.cssdmonitor 1 ONLINE ONLINE xifenfei STABLEora.ctssd 1 ONLINE OFFLINE STABLEora.diskmon 1 OFFLINE OFFLINE STABLEora.drivers.acfs 1 ONLINE ONLINE xifenfei STABLEora.evmd 1 ONLINE INTERMEDIATE xifenfei STABLEora.gipcd 1 ONLINE ONLINE xifenfei STABLEora.gpnpd 1 ONLINE ONLINE xifenfei STABLEora.mdnsd 1 ONLINE ONLINE xifenfei STABLEora.storage 1 ONLINE OFFLINE STABLE--------------------------------------------------------------------------------GI相关日志
--alert日志2013-09-08 23:53:37.662:[gpnpd(1507)]CRS-2328:GPNPD started on node xifenfei.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/xifenfei/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/xifenfei/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/xifenfei/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/xifenfei/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_xifenfei" 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@xifenfei xff-cluster]# crsctl stop crs -fCRS-2791: Startingshutdown of Oracle High Availability Services-managed resources on'xifenfei'CRS-2673: Attempting to stop'ora.mdnsd' on 'xifenfei'CRS-2673: Attempting to stop'ora.drivers.acfs' on 'xifenfei'CRS-2677: Stop of 'ora.drivers.acfs' on 'xifenfei' succeededCRS-2677: Stop of 'ora.mdnsd' on 'xifenfei'succeededCRS-2673: Attempting to stop'ora.gpnpd' on 'xifenfei'CRS-2673: Attempting to stop'ora.gipcd' on 'xifenfei'CRS-2673: Attempting to stop'ora.evmd' on 'xifenfei'CRS-2677: Stop of'ora.gpnpd' on 'xifenfei' succeededCRS-2677: Stop of'ora.gipcd' on 'xifenfei' succeededCRS-2677: Stop of'ora.evmd' on 'xifenfei' succeededCRS-2793: Shutdown of Oracle High Availability Services-managed resources on'xifenfei' has completedCRS-4133: Oracle High Availability Services has been stopped.exclusive模式启动crs
[root@xifenfei xff-cluster]# crsctl start crs -excl -nocrsCRS-4123: Oracle High Availability Services has been started.CRS-2673: Attempting to stop'ora.drivers.acfs' on 'xifenfei'CRS-2677: Stop of 'ora.drivers.acfs' on 'xifenfei' succeededCRS-2672: Attempting to start'ora.evmd' on 'xifenfei'CRS-2672: Attempting to start'ora.mdnsd' on 'xifenfei'CRS-2676: Start of'ora.evmd' on 'xifenfei' succeededCRS-2676: Start of'ora.mdnsd' on 'xifenfei' succeededCRS-2672: Attempting to start'ora.gpnpd' on 'xifenfei'CRS-2676: Start of'ora.gpnpd' on 'xifenfei' succeededCRS-2672: Attempting to start'ora.cssdmonitor' on 'xifenfei'CRS-2672: Attempting to start'ora.gipcd' on 'xifenfei'CRS-2676: Start of'ora.cssdmonitor' on 'xifenfei' succeededCRS-2676: Start of'ora.gipcd' on 'xifenfei' succeededCRS-2672: Attempting to start'ora.cssd' on 'xifenfei'CRS-2672: Attempting to start'ora.diskmon' on'xifenfei'CRS-2676: Start of'ora.diskmon' on'xifenfei' succeededCRS-2676: Start of'ora.cssd' on 'xifenfei' succeededCRS-2672: Attempting to start'ora.drivers.acfs' on 'xifenfei'CRS-2672: Attempting to start'ora.cluster_interconnect.haip' on 'xifenfei'CRS-2672: Attempting to start'ora.ctssd' on 'xifenfei'CRS-2676: Start of'ora.ctssd' on 'xifenfei' succeededCRS-2676: Start of'ora.cluster_interconnect.haip' on 'xifenfei' succeededCRS-2676: Start of'ora.drivers.acfs' on 'xifenfei' succeededCRS-2672: Attempting to start'ora.asm' on 'xifenfei'CRS-2676: Start of'ora.asm' on 'xifenfei' succeeded[grid@xifenfei xifenfei]$ crsctl stat res -t -init--------------------------------------------------------------------------------Name Target State Server State details --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.asm 1 ONLINE INTERMEDIATE xifenfei OCR not started,STAB LEora.cluster_interconnect.haip 1 ONLINE ONLINE xifenfei STABLEora.crf 1 OFFLINE OFFLINE STABLEora.crsd 1 OFFLINE OFFLINE STABLEora.cssd 1 ONLINE ONLINE xifenfei STABLEora.cssdmonitor 1 ONLINE ONLINE xifenfei STABLEora.ctssd 1 ONLINE ONLINE xifenfei ACTIVE:0,STABLEora.diskmon 1 OFFLINE OFFLINE STABLEora.drivers.acfs 1 ONLINE ONLINE xifenfei STABLEora.evmd 1 ONLINE INTERMEDIATE xifenfei STABLEora.gipcd 1 ONLINE ONLINE xifenfei STABLEora.gpnpd 1 ONLINE ONLINE xifenfei STABLEora.mdnsd 1 ONLINE ONLINE xifenfei STABLEora.storage 1 OFFLINE OFFLINE STABLE创建磁盘组
[grid@xifenfei xifenfei]$ sqlplus /as sysasmSQL*Plus: Release 12.1.0.1.0 Productionon Mon Sep 9 00:23:40 2013Copyright (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 optionsSQL> creatediskgroup DG_OCR external redundancy disk '/dev/sdc2'attribute 'COMPATIBLE.ASM'= '12.1.0';Diskgroup created.[root@xifenfei xff-cluster]# ls -ltotal 1472-rw-r--r-- 1 root root 1503232 Sep 8 23:48 backup_20130908_234857.ocr[root@xifenfei xff-cluster]# ocrconfig -restore backup_20130908_234857.ocrPROT-35: The configured OCR locations arenot accessibleSQL> 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@xifenfei xff-cluster]# ocrconfig -restore backup_20130908_234857.ocr--ALERT 日志2013-09-09 00:26:50.584:[client(3015)]CRS-1002:The OCR was restored fromfile backup_20130908_234857.ocr.处理votedisk
[root@xifenfei xff-cluster]# crsctl replace votedisk +DG_SYSSuccessful addition of voting disk 60a037da30714f6bbfe5d90206ff27a7.Successfully replaced voting disk group with +DG_SYS.CRS-4266: Voting file(s) successfully replaced创建asm spfile
[grid@xifenfei dbs]$vi /tmp/asm.txtinstance_type='asm'large_pool_size=12Mremote_login_passwordfile="EXCLUSIVE"asm_diskstring ="/dev/sd*"asm_power_limit = 1[grid@xifenfei dbs]$ sqlplus'/ as sysasm'SQL*Plus: Release 12.1.0.1.0 Production on Mon Sep 9 00:34:18 2013Copyright (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 optionsSQL> create spfile='+DG_SYS'FROM pfile='/tmp/asm.txt';File created.重启crs
[root@xifenfei xff-cluster]# crsctl stop crs -f[root@xifenfei xff-cluster]# crsctl start crsCRS-4123: Oracle High Availability Services has been started.[grid@xifenfei dbs]$ crsctl status res -t--------------------------------------------------------------------------------Name Target State Server State details --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.ASMNET1LSNR_ASM.lsnr ONLINE ONLINE xifenfei STABLEora.DATA.dg ONLINE ONLINE xifenfei STABLEora.LISTENER.lsnr ONLINE ONLINE xifenfei STABLEora.net1.network ONLINE ONLINE xifenfei STABLEora.ons ONLINE ONLINE xifenfei STABLEora.proxy_advm ONLINE OFFLINE xifenfei STABLE--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE xifenfei STABLEora.MGMTLSNR 1 ONLINE ONLINE xifenfei 169.254.196.108 10.1 0.30.22,STABLEora.asm 1 ONLINE ONLINE xifenfei Started,STABLE 2 OFFLINE OFFLINE STABLE 3 OFFLINE OFFLINE STABLEora.cdb.db 1 ONLINE ONLINE xifenfei Open,STABLEora.cvu 1 ONLINE ONLINE xifenfei STABLEora.oc4j 1 ONLINE ONLINE xifenfei STABLEora.scan1.vip 1 ONLINE ONLINE xifenfei STABLEora.xifenfei.vip 1 ONLINE ONLINE xifenfei STABLE--------------------------------------------------------------------------------这里crs已经恢复正常，进一步检查ocr,votedisk,asm spfile情况
[grid@xifenfei ~]$ ocrcheckStatus of Oracle Cluster Registry is as follows : Version : 4 Total space (kbytes) : 409568 Used space (kbytes) : 1380 Available space (kbytes) : 408188 ID : 2132096904 Device/FileName : +DG_SYS Device/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@xifenfei ~]$ sqlplus / as sysasmSQL*Plus: Release 12.1.0.1.0 Production on Mon Sep 9 16:12:21 2013Copyright (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 optionsSQL> show parameter spfile;NAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile string +DG_SYS/xff-cluster/ASMPARAMET ERFILE/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@xifenfei ~]$ crsctl query css votedisk## STATE File Universal Id File Name Disk group-- ----- ----------------- --------- ---------1. ONLINE 60a037da30714f6bbfe5d90206ff27a7 (/dev/sdc2) [DG_SYS]Located 1 voting disk(s).至此在ocr 磁盘组异常,而有ocr备份的情况下故障恢复完毕，对于没有ocr备份的故障，只能通过重建ocr来完成，大概步骤为
--deconfigure(root)remote node# <$GRID_HOME>/crs/install/rootcrs.pl -deconfig -force -verboselastnode# <$GRID_HOME>/crs/install/rootcrs.pl -deconfig -force -verbose -lastnode--配置信息重建ocr等(grid)# $GRID_HOME/crs/config/config.sh 0 0
- Oracle RAC OCR 磁盘组异常恢复
- Oracle 12c RAC 替换 OCR 磁盘组操作步骤
- Oracle RAC OCR 的备份与恢复
- oracle 10g RAC [恢复OCR]
- ORACLE 12C RAC修改ocr/votedisk/asm spfile所在磁盘组名称
- Oracle RAC 备份和恢复OCR（10g）
- oracle RAC无备份情况恢复ocr和olr
- Oracle 11gR2 RAC恢复OCR和VOTE DISK
- 【ORACLE RAC】oracle 10g rac更换共享磁盘（ocr,vote）的方法
- oracle rac ocr 简述
- RAC之备份恢复ocr
- RAC OCR备份与恢复
- RAC在OCR磁盘故障且无备份时快速恢复的方法
- RAC在OCR磁盘故障且无备份时快速恢复的方法
- RAC在OCR磁盘故障且有备份时的恢复操作
- Oracle 11.2.0.1 RAC ASM磁盘组全部丢失后的恢复
- Oracle Study之--AIX RAC下OCR磁盘故障（PROT-602）
- Oracle RAC OCR 与健忘症
- iOS Dev (55) 获取当前年、月、日等信息
- OSX下为php安装redis扩展~~~
- js实现复选框的操作-------Day41
- 使php支持mbstring库
- H323 AAC音频能力协商问题
- Oracle RAC OCR 磁盘组异常恢复
- iOS Dev (56) iTunes Store 销售日报更新时间
- 经纬财富:井冈山天通银-现货白银-现货黄金技术面分析培训
- Caused by: java.lang.NoSuchMethodException: <init> [class android.content.Context, interface android
- Eclipse rcp 实现文本内容对比功能
- 自定义齿轮方式的时间选择器
- 简易方法提高手机3G上网速度（2G转3G）
- 基于Qt的视频播放器的设计与实现
- iOS Dev (57) 解决UITableView重绘导致重叠的问题
