记录一次oracle rac的OCR_VOTE磁盘一块磁盘坏掉的情况测试。荐

## 现状
```
root@testdb1[+ASM1]/root$ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytoracle数据库es) : 3260
Available space (kbytes) : 258860
ID : 545177980
De磁盘空间不足怎么清理vice/Fileacls Name : +OCR_VOTE
Device/File integrioracle和mysql区别ty check succeeded
Device/File not configured
Device/File not configured
Device/File not configuroracle卸载edOracle
Device/File not configured
Clracinguster registry integrity check succeeded
Logical corruptionoracle安装 check succeeded
root@testdb1[+ASM1]/root$crsctl query css votedisk
## STATE File测试怀孕的试纸图片一深一浅 Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 531089329c6e4fd7Oraclebf55527321648aeb (/dev/asm-diskm) [OCR_VOTE]
2. ONLINE 228bc2cc1a624f2RACbbff2ed7ed24d3a36 (/dev/asm-diski) [OCR_VOTE]
3. ONLINE 2ddb39eaa1a54ff0bf38c48b12a7315c (/dev磁盘损坏怎么修复/asm-diskg) [OCR_VOTE]
4. ONLINE 735db22d36d14f31bf446493c25cf1bc (/dev/asm-dacl是什么意思iskf) [OCR_VOTE]
5. ONLINE 5cc9d45f6ade4f98bf16rachelc78be12fa786 (/dev/asm-diskd) [OCR_VOTE]
Located 5 voting disk(s).
root@testdb1[+ASM1]/root$acl
SQL> COLUMN PATHracket F磁盘分区ORMAT A20;race怎么读
COLUMN name FORMAT A20;
SET LINESIZE 500
select dg.NAME as disk_group,d.NAME,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,PATH from V$ASM_DI磁盘驱动器属于什么设备SK d ,V$ASM_DISKGROUP dg
where d.GROUP_NUMBER测试手机是否被监控=dg.GROUP_NUMBER
order by dg.NAME;
SQL> SQL> SQrackL> 2 3
DISK测试你的自卑程度_GROUP NAME MOUNT_STATUS HEADERoracle和mysql区别_STATUS MODE澳超联赛积分_STATUS PATH
------------------------------------------------------------ -------------------- --------------安昌林 ------------------------ -------------- -磁盘碎片整理程序的主要作用是-------------------
ACFS01 ACFS01_0000 CACHED MEMBER ONLINE /dev/asm-diskj
DGARCH DGARoracle数据库菜鸟教程CH_0000 CACHED MEMBERrack ONLINE /dev/asm-diskl
DGDATA DGDATA_0000 CACHED MEMBER ONLINE /dev/asm-rackdiske
DGSYS DGSOracleYS_0000 CACHED MEMBER ONLINE /dev/asm-diskk
OCR_VOTE OCR_VOTE_0001 CACHED MEMBER ONLINE /dev/asm-diski
OCR_VO磁盘清理TE OCR_磁盘碎片整理程序的主要作用是VOTE_0004 CACHED MEMBER ONLINE /dev/asm-diskd
OCR_VOTE OCR_VOTE_0002 CACHED MEMBER ONLINE /devracist/asm-diskg
OCR_VOTE OCR_VOTE_0000 CACHED MaclsEMBER ONLINE /dev/asm-diskm
OCR_VOTE OCR_VOTE_acl访问控制列表0003 CACHED MEMBER ONLINE /derachelv/asm-diskf
OCR_VOTE OCR_VOTE_0005 CACHED MEMBER ONLINE /dev/asm-diskc
OCR_VOTaclE2 OCR_VOTE2_0000 CACHED MEMBER ONLINE /dev/a测试网速sm-diskh
```
```
模拟/dev/asm-diski被dd后的情况
dd if=/dev/zero of=/dev/asm-diski bs=1024k count=20
dd if=/dev/zero of=/dev/asm-diski bs=1024k count=20
root@testdb1[+ASM1]/root$dd if=/dev/zero of=/dev/asm-diski bs=1024k count=20
20+0 records in
20+0 records out
20971520 bytes (21 MB) copiraceded, 0.测试网速01632oracle卸载7 s, 1.3 GB/s
root@testdb1[+ASM1]/root$
SQL&gracistt; /
DISK_GROUP NAME MOUNT_STATUS HEADER_STATUS MODE_STATUS PATH
-----------------磁盘驱动器属于什么设备------------------------------------------- -------------------- -------------- ------------------------ -------------- --------------------
ACFS01 ACFS01_0000 CACHED MEMBER ONLINE /dev/asm-diskj
DGARCH DGARCH_0000 CACHED MEMBER ONLINE /dev/asm-diskl
DGDATA D磁盘分区GDATA_0000 CACHED MEMBER ONLINE /dev/asm-dis磁盘驱动器属于什么设备ke
DGSYS DGSYS_0000 CACHED MEMBER ONLINE /dev/asm-diskk
OCR_VOTE OCR_VOTracketE_0001 CACHED CANDIDATE ONLINE /dev/asm-diski
OCR_VOTE OCR_VOTE_0004 CACHED MEMBER ONLINE /dev/asm-diskd
OCacl是什么意思R_VOTE OCR_VOTE_0002 CACHED MEMBER ONLINE /dev/a测试抑郁程度的问卷sm-diskg
OCR_VOTE OCR_VOTE_0000 CACHED MEMBER ONLINE /dev/asm-diskm
OCR_VOTE OCR_VOTE_0003 CACHED MEMBER ONLINE /dev/asm-diskf
OCR_VOTracedE OCR_VOTE_0005 CACHED MEMBER ONLINE /dev/asm-diskc
OCR_VOTE2 OCR_VOTE2_0000 CACHED MEMacl是什么意思BER ONLIoracle面试题NE /dev/asm-diskh
11 rows selected.
可以看到这块磁盘对应的磁盘头已oracle卸载经成为CANDI磁盘管理DATE状态
```
## 强制关闭节点,再重启,发现已经启动不起来了
```
crsctl stop crsoracle和mysql区别 -f
查看后台日志
root@testdb1[+ASM1]/grid/grid_homerace/log/testdb1$tail -100 alerttestdb1.log
2021-05-26 20:23:37.862:
[ohasd(3005)]CRS-2767:Resource state recracingovery not attempte磁盘驱动器属于什么设备d for 'ora.diskmon' as its target state is OFFLINE
2021-05-26 20:23:37.862:
[ohasd(3005)]CRS-2769:Unable to failover resou测试用例rce 'ora.diskmon'.
[client(3820)]CRS-10001:26-May-21 20:23 ACFS-9391: Checking for e磁盘空间不足怎么清理xisting ADVM/ACFS i安昌林ns测试抑郁症的20道题tallation.
[client(3825)]CRS-10001:26-May-21 20:23 ACFS-9392: Validating ADVM/ACFS installation fi测试抑郁症的20道题les for operating system.
[client(3827)]CRS-10001:26-May-21 20:23 ACFS-9393: Verifying ASM Administrator setup.
[client(3830)]CRS-10001:26-May-21 20:23 ACFS-9308: Loading installed ADVM/ACFS drivers.
[client(3833)]CRS-10001:26-May-21 20:23 ACFS-9154: Loading 'orrace什么意思acleoks.ko' driver测试你的自卑程度.
[client(3842)]CRS-10001:26-May-21 20:23 ACFS-9154: Loading 'oracleadvm.ko' driver.
[client(3867)]CRS-10001:26-May-21 20:23 ACFS-9154: Load测试抑郁症的20道题ing 'oracleacfs.ko' driver.
[client(3926)]CRS-10001:26-May-21 20:23 ACFS-9327: Verifying ADVM/ACFS devices.
[client(3931)]CRS-10001:26-May-21 20:23 ACFS-9156: Detecting controloracle11g安装教程 device '/dev/asm/.asm_ctl_spec'.
[client(3935)]CRS-10001:26-May-21 20:23 ACFS-9156: Detec测试抑郁程度的问卷ting control devirackce '/dev/ofsctl'.
[client(3940)]CRS-1acls0001:26-May-21 20:23 ACFS-9322: completed
2021-05-26acl医学上是什么意思 20:23:44.167:
[/grid/grid_home/bin/oraagent.bin(3376)]CRS-5011:Check of傲宠六零有孕军嫂 resource "+ASM" failed:测试工程师 detailsoracle数据库 at "(:CLSN00006:)" in "/grid/grid_home/log/testdb1/agent/ohasd/oraa澳超联赛积分gent_grid/oraage磁盘清理nt_grid.log"
2021-05-26 20:23:racket49oracle怎么读.508:
[/grid/grid_home/bin/oraagent.bin(3376)]CRS-5011:Check of res测试抑郁程度的问卷ource "+ASM" failed: details at "(:CLSN00006:)" in "/grid/grid_racehome/log/testdb1/ageaclsnt/ohasd/oraagent_grid/oraagent_grid.log"
2021-05-26 20:24:10.920:
[/grid/grid_home/bin/oraagent.bin(3376)]CRS-5019:All OCR locatirackons are on ASMacl disk grouoracle面试题ps [OCR_VOTE], and none of these disk groups are mounted. Details are at "(:CLSN00100:)" in "/grid/grid_racedhome/logRAC/testdb1/agent/ohasd/oraagent_grid/oraagent_grid.log".
2021-05-26 20:24:11.099oracle卸载:
[ohasd(3005)]CRS-2807:ReRACsource 'ora.crsd' failed to start automatically.
2021-05-26 20:24:12.096:
[/grid/grid_home/bin/oraagent.bin(3376)]CRS-5019:All OCR locations are on ASM disk groups [OCR_VOTE], and no磁盘碎片整理程序的主要作用是ne of these disk groups are mounted. Details are at "(:CLSN00100:)" in "/grid/rackgrid_home/log/testdb1/agent/ohasd/oraagent_grid/oraagent_grid.log".
2021磁盘被写保护怎么解除-05-26 20:24:42.115:
[/grid/grid_home/bin/oraagent.bin(3376)]CRoracle安装S-5019:All OC测试用例R locations are on ASM disk groups [OCR_VOTE], and none of these disk groups are磁盘阵列 mounted. Details are at "(:CLSN00100:racket)" in "/grid/grid_home/log/tesacl是什么意思tdb1race什么意思/agent/ohasd/oraagent_gr测试你的自卑程度id/oraagent_grid.log".
2021-05-26 20:25:12.146:
[/grid/grid_home/bin/oraagent.bin(3376)]CRS-5019测试:All OCR locations are on磁盘清理 ASM disk groups [OCR_VOTE], and none of these disk groups are mounted. Details are at "(:CLSN00100:)" in "/grid/grid_home/log/testdb1/agent/ohasd/oraagent_gr磁盘碎片整理id/oraagent_grid.log".
202race什么意思1-05-26 20:25:42.186:
[/grid/grid_home/bin/oraagent.bin(3376)]CRS-5019:磁盘清理All OCR loc测试手机是否被监控ations aroracle卸载e on ASM disk groups [OCR_VOTE], andacls none of these disk groups are mounted. Details ar测试工程师e at "(:CLSN00100:)" in "/grid/grid_home/log/testdb1/agent/ohasd/oraagent_grid/oraagent_grid.lracingog".
2021-05-26 20:26:12.216:
[/grid/grid_home/bin/oraagent.bin(3376)]CRS-5019:All OCR locations are on ASM disk groups [OCR_VOTE], anoracle和mysql区别d none of these disk grouprachels are mounted. Details are at "(race什么意思:CLSN00100:)" in "/goracle数据库rid/grid_home/log/testdb1/agraccoonent/ohas磁盘空间不足怎么清理d/oraagent_grid/oraagent_gri测试你的自卑程度d.log".
2021-05-26 20:26:42.241:
[/grid/grid_home/bin/oraagent.bin(3376)]CRS-5019:All OCR locations are on ASM disk groups [OCR_VOTE], and none of these dis测试抑郁症k groups are mountoracle数据库菜鸟教程ed. Details are at "(:CLSN00100:)" in "/grid/grid_home/log/testdb1/agent/ohasd/oraagent_grid/oraagent_grid.log".
2021-05测试怀孕的试纸图片一深一浅-26 20:27:12.253:
[/grid/grid_home/bin/oraagent.bin(3376)]CRS-5019:All OCROracle locations are on ASM disk groups [OCR_VOTE], and none ooracle培训f these disk groups are mounted. Details are at "(:CLSN00100:)" in "/grid/grid_home/loracketg/testaclsdb1/agent/ohasd/oraagent_grid/oraagent_grid.log".
2021-05-26 20:27:42.263:
[/grid/grid_home/bin/oraagent.bin(3376)]CRS-5019:All OCR locations are onrace ASM disk groups [OCR_VOTE], and none of these disk groups are mounted. Details are at "(:CLSN00100:)" in "/grid/grid_ho测试抑郁程度的问卷me/log/testdb1/agent/ohasd/oraagen磁盘驱动器属于什么设备t_grid/oraagent_griacl配置命令d.log".
```
## 强制启动
```
先crsctl start crs,再进行crsctl check crs
发现并不能完全启动,但是能够通过grid进入oracle卸载sqlplus / as sysasm
由于我们采用了HIGH这种方式,只坏了一块盘,可以强制mounracet
alter diskgroup OCR_VOTE mount force;
```
## 再race正常启动
```
crsct测试抑郁症l start crs
查询集群状态,等的时间可能很长
root@testdb1[+ASM1]/gacl医学上是什么意思rid/grid_home/log/testdb1$crsctl check crs
CRS-4638: Oracle High Avoracle卸载ailability Services is online
CRS-4537: Cluster Ready Services is on安昌林line
CRS磁盘-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager isacl是什么意思 onlinraciste
```
## 查看集群的磁盘状态
```
grid@testdb1[+ASM1]/home/grid$sqlplus / as sysasm
SQL*Plus:磁盘被写保护怎么解除 Release 11.2.0.4.0 Production on Wed May 26 20:52:39 2021
Copyright (c) 198磁盘2, 2013测试纸怎么看是否怀孕, Oracle. All rights reseraclsved.
Connected to:
Oracle Database 11g Enteracl医学上是什么意思p傲宠六零有孕军嫂rise Edition Release 11.2.0.4.0 - 64bit Pro磁盘碎片整理duction
With the Real Application Clusters and Automatic傲宠六零有孕军嫂 Storage Management options
SQL&磁盘被写保护怎么解除gt; COLUMN PATH FORMAT A20;
COLUMN name FORM测试用例AT A20;
SET LINESIZEracist 500
select dg.NAME asoracle卸载 d测试怀孕的试纸图片一深一浅isk_grrachelou测试纸怎么看是否怀孕p,d.NAME,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,PATH from V$ASM_DISK d ,V$ASM_DISKGROUP dg
where d.GROUP_NUMBER=dg.GROUP_NUMBER
order by dg.NAME;oracle培训SQL> SQL> SQL> 2 3
DISK_GROUP NAM磁盘损坏怎么修复E MOracistUNT_STATUS HEADER_STATUS MODE_STATUS PATH
------------oracle数据库----oracle是什么软件---------------------race怎么读----------------------- -------------------- -------------- -----------Oracle------racket------- -------------- --------------------
ACFS01 ACFS01_0000 CACHEoracle安装D MEMBER ONLINE /dev/asm-diskj
DGARCH DGARacl访问控制列表CH_0000 CACHED MEMBER ONLINE /dev/arace怎么读sm-diskl
DGDATA DGDATA_0000 CACHED MEMBER ONLINEraccoon /dev/asm-diske
DGSYS DGSYS_0000 CACHEraccoonD MEMBER ONLINE /dev/asm-diskk
OCR_VOTE OCR_VOTE_0002 CACHED MEMBER ONLINE /dev/oracle数据库asm-diskg
OCR_VOTE OCR_VOTE_0001 MISSING UNKNOWN OFFLINE
OCR_VOTE OCR_VOTE_0000 CACH磁盘空间不足怎么清理ED MEMBER ONLINE /dev/asm-acl是什么意思diskm
OC测试怀孕的试纸图片一深一浅R_VOTE OCR_VOaclTE_0005 CACHED MEMBER ONLINE /dev/asm-diskc
OCR_VOTE OCR_VOTE_0003 CACHED MEMBER ONLINE /dev/asm-diskf
OCR_VOTErace什么意思 OCR_VOTE_0004 CACHE测试手机是否被监控D MEMBER ONLINE /dev/asm-diskd
OCR_VOTE2 OCR_VOTE2_0000 CACHED MEMBEracingR ONLINE /dev/asm-diskh
11 r磁盘分区ows selected.
发现磁盘已经成为 MISSING UNKN测试OWN 状态。
```