新舊磁盤數量不一致,能否刪除帶votedisk的磁盤?
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]
添加2塊磁盤,執行刪除舊磁盤操作:
NAME PATH FAILGROUP FAILGRO --------------- ------------------------------ -------------------- ------- OCR /dev/oracleasm/disks/OCR101 OCR_0003 REGULAR OCR /dev/oracleasm/disks/OCR102 OCR_0004 REGULAR OCR /dev/oracleasm/disks/OCR103 OCR_0005 REGULAR #添加2塊磁盤 SQL> alter diskgroup ocr add disk '/dev/oracleasm/disks/OCR01', '/dev/oracleasm/disks/OCR02'; 2 3 Diskgroup altered. #刪除舊磁盤 SQL> ALTER DISKGROUP OCR drop disk 'OCR_0003', 'OCR_0004', 'OCR_0005'; 2 3 4 Diskgroup altered.
#
#舊磁盤未刪除
NAME PATH FAILGROUP FAILGRO --------------- ------------------------------ -------------------- ------- OCR /dev/oracleasm/disks/OCR01 OCR_0000 REGULAR OCR /dev/oracleasm/disks/OCR02 OCR_0001 REGULAR OCR /dev/oracleasm/disks/OCR101 OCR_0003 REGULAR OCR /dev/oracleasm/disks/OCR102 OCR_0004 REGULAR OCR /dev/oracleasm/disks/OCR103 OCR_0005 REGULAR SQL> select STATE from v$asm_disk; STATE -------- NORMAL DROPPING《====狀態為刪除 DROPPING DROPPING NORMAL NORMAL 日志信息: Wed Sep 08 20:49:45 2021 SQL> ALTER DISKGROUP OCR drop disk 'OCR_0003', 'OCR_0004', 'OCR_0005' NOTE: GroupBlock outside rolling migration privileged region NOTE: requesting all-instance membership refresh for group=1 Wed Sep 08 20:49:48 2021 NOTE: Attempting voting file relocation on diskgroup OCR NOTE: Successful voting file relocation on diskgroup OCR Wed Sep 08 20:49:48 2021 GMON updating for reconfiguration, group 1 at 23 for pid 31, osid 15246 NOTE: group 1 PST updated. NOTE: membership refresh pending for group 1/0xbefb6a6b (OCR) GMON querying group 1 at 24 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_0003', 'OCR_0004', 'OCR_0005' Starting background process ARB0 Wed Sep 08 20:49:51 2021 ARB0 started with pid=28, OS id=17057 NOTE: assigning ARB0 to group 1/0xbefb6a6b (OCR) with 1 parallel I/O cellip.ora not found. NOTE: F1X0 copy 1 relocating from 4:114 to 0:136 for diskgroup 1 (OCR) NOTE: F1X0 copy 2 relocating from 3:115 to 1:137 for diskgroup 1 (OCR) NOTE: F1X0 copy 3 relocating from 5:115 to 65534:4294967294 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_0000 NOTE: voting file allocation on grp 1 disk OCR_0001 NOTE: Failed voting file relocation on diskgroup OCR Wed Sep 08 20:50:02 2021 NOTE: stopping process ARB0 SUCCESS: rebalance completed for group 1/0xbefb6a6b (OCR) Wed Sep 08 20:50:03 2021 NOTE: GroupBlock outside rolling migration privileged region NOTE: requesting all-instance membership refresh for group=1 Wed Sep 08 20:50:06 2021 GMON updating for reconfiguration, group 1 at 25 for pid 32, osid 16894 NOTE: group 1 PST updated. WARNING: grp 1 disk OCR_0003 still has contents (32 AUs) WARNING: grp 1 disk OCR_0004 still has contents (32 AUs) WARNING: grp 1 disk OCR_0005 still has contents (32 AUs) NOTE: membership refresh pending for group 1/0xbefb6a6b (OCR) GMON querying group 1 at 26 for pid 18, osid 11947 SUCCESS: refreshed membership for 1/0xbefb6a6b (OCR) Wed Sep 08 20:50:12 2021 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_0000 NOTE: voting file allocation on grp 1 disk OCR_0001 NOTE: Failed voting file relocation on diskgroup OCR
#在添加一塊磁盤之后自動刪除舊磁盤
#添加磁盤之后,自動刪除。 SQL> alter diskgroup ocr add disk '/dev/oracleasm/disks/OCR03';SQL> 2 Diskgroup altered. SQL> 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; 2 3 4 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 [grid@db01 ~]$ crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 57e24fe4466a4f57bf09968b9dd8585c (/dev/oracleasm/disks/OCR01) [OCR] 2. ONLINE 4065d42296204f8bbfd8cccbaca0b68b (/dev/oracleasm/disks/OCR02) [OCR] 3. ONLINE 901ec22713a64fefbfad784eef648c31 (/dev/oracleasm/disks/OCR03) [OCR] 日志信息: Wed Sep 08 20:53:37 2021 SQL> alter diskgroup ocr add disk '/dev/oracleasm/disks/OCR03' NOTE: GroupBlock outside rolling migration privileged region NOTE: Assigning number (1,2) to disk (/dev/oracleasm/disks/OCR03) NOTE: requesting all-instance membership refresh for group=1 NOTE: initializing header on grp 1 disk OCR_0002 NOTE: requesting all-instance disk validation for group=1 Wed Sep 08 20:53:39 2021 NOTE: skipping rediscovery for group 1/0xbefb6a6b (OCR) on local instance. NOTE: requesting all-instance disk validation for group=1 NOTE: skipping rediscovery for group 1/0xbefb6a6b (OCR) on local instance. Wed Sep 08 20:53:39 2021 GMON updating for reconfiguration, group 1 at 27 for pid 31, osid 15246 NOTE: group 1 PST updated. NOTE: initiating PST update: grp = 1 GMON updating group 1 at 28 for pid 31, osid 15246 NOTE: PST update grp = 1 completed successfully NOTE: membership refresh pending for group 1/0xbefb6a6b (OCR) GMON querying group 1 at 29 for pid 18, osid 11947 NOTE: cache opening disk 2 of grp 1: OCR_0002 path:/dev/oracleasm/disks/OCR03 GMON querying group 1 at 30 for pid 18, osid 11947 SUCCESS: refreshed membership for 1/0xbefb6a6b (OCR) NOTE: starting rebalance of group 1/0xbefb6a6b (OCR) at power 1 Starting background process ARB0 SUCCESS: alter diskgroup ocr add disk '/dev/oracleasm/disks/OCR03' Wed Sep 08 20:53:42 2021 ARB0 started with pid=29, OS id=17504 NOTE: assigning ARB0 to group 1/0xbefb6a6b (OCR) with 1 parallel I/O cellip.ora not found. NOTE: F1X0 copy 3 relocating from 65534:4294967294 to 2:2 for diskgroup 1 (OCR)
版權聲明:本文內容由網絡用戶投稿,版權歸原作者所有,本站不擁有其著作權,亦不承擔相應法律責任。如果您發現本站中有涉嫌抄襲或描述失實的內容,請聯系我們jiasou666@gmail.com 處理,核實后本網站將在24小時內刪除侵權內容。