votedisk 磁盘组,存储替换

网友投稿 572 2022-05-28

votedisk 磁盘组,存储替换

数据库版本: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

版权声明:本文内容由网络用户投稿,版权归原作者所有,本站不拥有其著作权,亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容,请联系我们jiasou666@gmail.com 处理,核实后本网站将在24小时内删除侵权内容。

上一篇:【最佳实践】使用云硬盘组建RAID磁盘阵列
下一篇:grid 删除磁盘组
相关文章