votedisk 磁盘组，存储替换
【摘要】 数据库版本：11.2.0.4.0votedisk磁盘信息：[grid@db01 ~]$ crsctl query css votedisk## STATE File Universal Id File Name Disk group-- ----- ----------------- --------- ------...
数据库版本：11.2.0.4.0
votedisk磁盘信息：
[grid@db01 ~]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 600ed35a4c5a4f02bfbb1ea7b05f1cd8 (/dev/oracleasm/disks/OCR01) [OCR]
2. ONLINE 41d6d012d12f4fe4bf8d5ecc955c9d07 (/dev/oracleasm/disks/OCR02) [OCR]
3. ONLINE 7167bc2d62bf4fd8bfbd8cb6edea469c (/dev/oracleasm/disks/OCR03) [OCR]
#DISK GROUP 信息
col name format a15;
col path format a30;
col failgroup format a20;
select dg.name, d.path, d.failgroup, d.failgroup_type
from v$asm_diskgroup dg, v$asm_disk d
where dg.group_number = d.group_number and dg.name = 'OCR'
order by dg.name, d.path, d.failgroup;
NAME PATH FAILGROUP FAILGRO
--------------- ------------------------------ -------------------- -------
OCR /dev/oracleasm/disks/OCR01 OCR_0000 REGULAR
OCR /dev/oracleasm/disks/OCR02 OCR_0001 REGULAR
OCR /dev/oracleasm/disks/OCR03 OCR_0002 REGULAR
操作过程：
01，添加新磁盘
SQL> alter diskgroup ocr add disk
'/dev/oracleasm/disks/OCR101',
'/dev/oracleasm/disks/OCR102',
'/dev/oracleasm/disks/OCR103'; 2 3 4
Diskgroup altered.02，删除就磁盘
SQL> ALTER DISKGROUP OCR drop disk
'OCR_0000',
'OCR_0001',
'OCR_0002';
2 3 4
Diskgroup altered.
03，查看votedisk信息
[grid@db01 ~]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 093f536704a64f91bf978e3d3669e9a8 (/dev/oracleasm/disks/OCR101) [OCR]
2. ONLINE 34eb9d2c44824fb3bf8479b22b517771 (/dev/oracleasm/disks/OCR102) [OCR]
3. ONLINE 24f853a217ca4f22bf13c28e48be2c05 (/dev/oracleasm/disks/OCR103) [OCR]
Located 3 voting disk(s日志信息：
Wed Sep 08 20:38:50 2021
SQL> ALTER DISKGROUP OCR drop disk
'OCR_0000',
'OCR_0001',
'OCR_0002'
NOTE: GroupBlock outside rolling migration privileged region
NOTE: requesting all-instance membership refresh for group=1
Wed Sep 08 20:38:52 2021
NOTE: Attempting voting file relocation on diskgroup OCR
NOTE: Successful voting file relocation on diskgroup OCR
Wed Sep 08 20:38:52 2021
GMON updating for reconfiguration, group 1 at 10 for pid 31, osid 15246
NOTE: group 1 PST updated.
NOTE: membership refresh pending for group 1/0xbefb6a6b (OCR)
GMON querying group 1 at 11 for pid 18, osid 11947
SUCCESS: refreshed membership for 1/0xbefb6a6b (OCR)
NOTE: starting rebalance of group 1/0xbefb6a6b (OCR) at power 1
SUCCESS: ALTER DISKGROUP OCR drop disk
'OCR_0000',
'OCR_0001',
'OCR_0002'
Starting background process ARB0
Wed Sep 08 20:38:55 2021
ARB0 started with pid=32, OS id=15859
NOTE: assigning ARB0 to group 1/0xbefb6a6b (OCR) with 1 parallel I/O
cellip.ora not found.
NOTE: F1X0 copy 1 relocating from 0:2 to 4:114 for diskgroup 1 (OCR)
NOTE: F1X0 copy 2 relocating from 1:2 to 3:115 for diskgroup 1 (OCR)
NOTE: F1X0 copy 3 relocating from 2:2 to 5:115 for diskgroup 1 (OCR)
NOTE: Attempting voting file refresh on diskgroup OCR
NOTE: Refresh completed on diskgroup OCR
. Found 3 voting file(s).
NOTE: Voting file relocation is required in diskgroup OCR
NOTE: Attempting voting file relocation on diskgroup OCR
NOTE: voting file allocation on grp 1 disk OCR_0003
NOTE: voting file allocation on grp 1 disk OCR_0004
NOTE: voting file allocation on grp 1 disk OCR_0005
NOTE: voting file deletion on grp 1 disk OCR_0000
NOTE: voting file deletion on grp 1 disk OCR_0001
NOTE: voting file deletion on grp 1 disk OCR_0002
NOTE: Successful voting file relocation on diskgroup OCR
Wed Sep 08 20:39:07 2021
NOTE: stopping process ARB0
SUCCESS: rebalance completed for group 1/0xbefb6a6b (OCR)
Wed Sep 08 20:39:09 2021
NOTE: GroupBlock outside rolling migration privileged region
NOTE: requesting all-instance membership refresh for group=1
Wed Sep 08 20:39:12 2021
GMON updating for reconfiguration, group 1 at 12 for pid 27, osid 15539
NOTE: group 1 PST updated.
SUCCESS: grp 1 disk OCR_0000 emptied
SUCCESS: grp 1 disk OCR_0001 emptied
SUCCESS: grp 1 disk OCR_0002 emptied
NOTE: erasing header on grp 1 disk OCR_0000
NOTE: erasing header on grp 1 disk OCR_0001
NOTE: erasing header on grp 1 disk OCR_0002
NOTE: process _x000_+asm1 (15539) initiating offline of disk 0.3916143267 (OCR_0000) with mask 0x7e in group 1
NOTE: process _x000_+asm1 (15539) initiating offline of disk 1.3916143266 (OCR_0001) with mask 0x7e in group 1
NOTE: process _x000_+asm1 (15539) initiating offline of disk 2.3916143265 (OCR_0002) with mask 0x7e in group 1
NOTE: initiating PST update: grp = 1, dsk = 0/0xe96b9aa3, mask = 0x6a, op = clear
NOTE: initiating PST update: grp = 1, dsk = 1/0xe96b9aa2, mask = 0x6a, op = clear
NOTE: initiating PST update: grp = 1, dsk = 2/0xe96b9aa1, mask = 0x6a, op = clear
GMON updating disk modes for group 1 at 13 for pid 27, osid 15539
NOTE: group OCR: updated PST location: disk 0003 (PST copy 0)
NOTE: group OCR: updated PST location: disk 0004 (PST copy 1)
NOTE: group OCR: updated PST location: disk 0005 (PST copy 2)
NOTE: group OCR: updated PST location: disk 0003 (PST copy 0)
NOTE: group OCR: updated PST location: disk 0004 (PST copy 1)
NOTE: group OCR: updated PST location: disk 0005 (PST copy 2)
NOTE: group OCR: updated PST location: disk 0003 (PST copy 0)
NOTE: group OCR: updated PST location: disk 0004 (PST copy 1)
NOTE: group OCR: updated PST location: disk 0005 (PST copy 2)
NOTE: PST update grp = 1 completed successfully
NOTE: initiating PST update: grp = 1, dsk = 0/0xe96b9aa3, mask = 0x7e, op = clear
NOTE: initiating PST update: grp = 1, dsk = 1/0xe96b9aa2, mask = 0x7e, op = clear
NOTE: initiating PST update: grp = 1, dsk = 2/0xe96b9aa1, mask = 0x7e, op = clear
GMON updating disk modes for group 1 at 14 for pid 27, osid 15539
NOTE: cache closing disk 0 of grp 1: OCR_0000
NOTE: cache closing disk 1 of grp 1: OCR_0001
NOTE: cache closing disk 2 of grp 1: OCR_0002
NOTE: PST update grp = 1 completed successfully
GMON updating for reconfiguration, group 1 at 15 for pid 27, osid 15539
NOTE: cache closing disk 0 of grp 1: (not open) OCR_0000
NOTE: cache closing disk 1 of grp 1: (not open) OCR_0001
NOTE: cache closing disk 2 of grp 1: (not open) OCR_0002
NOTE: group 1 PST updated.
NOTE: membership refresh pending for group 1/0xbefb6a6b (OCR)
NOTE: Attempting voting file refresh on diskgroup OCR
NOTE: Refresh completed on diskgroup OCR
. Found 3 voting file(s).
NOTE: Voting file relocation is required in diskgroup OCR
NOTE: Attempting voting file relocation on diskgroup OCR
NOTE: Successful voting file relocation on diskgroup OCR
GMON querying group 1 at 16 for pid 18, osid 11947
GMON querying group 1 at 17 for pid 18, osid 11947
NOTE: Disk OCR_0000 in mode 0x0 marked for de-assignment
NOTE: Disk OCR_0001 in mode 0x0 marked for de-assignment
NOTE: Disk OCR_0002 in mode 0x0 marked for de-assignment
SUCCESS: refreshed membership for 1/0xbefb6a6b (OCR)
Wed Sep 08 20:39:18 2021
NOTE: Attempting voting file refresh on diskgroup OCR
NOTE: Refresh completed on diskgroup OCR
. Found 3 voting file(s).
#在执行旧磁盘删除命令之后，自动同步votedisk 磁盘数据到新的磁盘，无需人工操作。
执行更改votedisk位置？
Wed Sep 08 20:38:52 2021
NOTE: Attempting voting file relocation on diskgroup OCR
NOTE: Successful voting file relocation on diskgroup OCR
更改完成之后执行删除操作？
Wed Sep 08 20:38:52 2021
GMON updating for reconfiguration, group 1 at 10 for pid 31, osid 15246
NOTE: group 1 PST updated.
NOTE: membership refresh pending for group 1/0xbefb6a6b (OCR)
GMON querying group 1 at 11 for pid 18, osid 11947
SUCCESS: refreshed membership for 1/0xbefb6a6b (OCR)
NOTE: starting rebalance of group 1/0xbefb6a6b (OCR) at power 1
SUCCESS: ALTER DISKGROUP OCR drop disk
'OCR_0000',
'OCR_0001',
'OCR_0002'
Starting background process ARB0
Wed Sep 08 20:38:55 2021
【声明】本内容来自华为云开发者社区博主，不代表华为云及华为云开发者社区的观点和立场。转载时必须标注文章的来源（华为云社区）、文章链接、文章作者等基本信息，否则作者和本社区有权追究责任。如果您发现本社区中有涉嫌抄袭的内容，欢迎发送邮件进行举报，并提供相关证据，一经查实，本社区将立刻删除涉嫌侵权内容，举报邮箱：
cloudbbs@huaweicloud.com
- 点赞
- 收藏
- 关注作者
评论（0）