環境：AIX6.1 + Oracle RAC 11.2.0.3
前期準備：
1.查看DG磁盤組空間情況：
–查看DG磁盤組空間情況：
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 9728000 19046 0 19046 0 N DATADG/
MOUNTED EXTERN N 512 4096 1048576 3584000 1261514 0 1261514 0 N RECOVERYDG/
2.查看ASM磁盤信息：
–查看ASM磁盤信息
ASMCMD> lsdsk -k
Total_MB Free_MB OS_MB Name Failgroup Failgroup_Type Library Label UDID Product Redund Path512000 950 512000 DATADG_0007 DATADG_0007 REGULAR System UNKNOWN /dev/rhdisk23512000 945 512000 DATADG_0008 DATADG_0008 REGULAR System UNKNOWN /dev/rhdisk24512000 953 512000 DATADG_0009 DATADG_0009 REGULAR System UNKNOWN /dev/rhdisk25512000 948 512000 DATADG_0011 DATADG_0011 REGULAR System UNKNOWN /dev/rhdisk26512000 948 512000 DATADG_0012 DATADG_0012 REGULAR System UNKNOWN /dev/rhdisk27512000 953 512000 DATADG_0020 DATADG_0020 REGULAR System UNKNOWN /dev/rhdisk28512000 949 512000 DATADG_0021 DATADG_0021 REGULAR System UNKNOWN /dev/rhdisk29512000 948 512000 DATADG_0022 DATADG_0022 REGULAR System UNKNOWN /dev/rhdisk30512000 947 512000 DATADG_0023 DATADG_0023 REGULAR System UNKNOWN /dev/rhdisk31512000 946 512000 DATADG_0024 DATADG_0024 REGULAR System UNKNOWN /dev/rhdisk32512000 957 512000 DATADG_0025 DATADG_0025 REGULAR System UNKNOWN /dev/rhdisk33512000 950 512000 DATADG_0026 DATADG_0026 REGULAR System UNKNOWN /dev/rhdisk34512000 956 512000 DATADG_0027 DATADG_0027 REGULAR System UNKNOWN /dev/rhdisk35512000 946 512000 DATADG_0028 DATADG_0028 REGULAR System UNKNOWN /dev/rhdisk36512000 950 512000 DATADG_0029 DATADG_0029 REGULAR System UNKNOWN /dev/rhdisk37512000 178001 512000 RECOVERYDG_0006 RECOVERYDG_0006 REGULAR System UNKNOWN /dev/rhdisk38512000 177979 512000 RECOVERYDG_0007 RECOVERYDG_0007 REGULAR System UNKNOWN /dev/rhdisk39512000 177968 512000 RECOVERYDG_0008 RECOVERYDG_0008 REGULAR System UNKNOWN /dev/rhdisk40512000 177984 512000 RECOVERYDG_0009 RECOVERYDG_0009 REGULAR System UNKNOWN /dev/rhdisk41512000 177983 512000 RECOVERYDG_0010 RECOVERYDG_0010 REGULAR System UNKNOWN /dev/rhdisk42512000 177984 512000 RECOVERYDG_0011 RECOVERYDG_0011 REGULAR System UNKNOWN /dev/rhdisk43512000 939 512000 DATADG_0000 DATADG_0000 REGULAR System UNKNOWN /dev/rhdisk44512000 1288 512000 DATADG_0001 DATADG_0001 REGULAR System UNKNOWN /dev/rhdisk45512000 1286 512000 DATADG_0002 DATADG_0002 REGULAR System UNKNOWN /dev/rhdisk46512000 1287 512000 DATADG_0003 DATADG_0003 REGULAR System UNKNOWN /dev/rhdisk47512000 177965 512000 RECOVERYDG_0000 RECOVERYDG_0000 REGULAR System UNKNOWN /dev/rhdisk48
實施步驟：
? 1.從RECOVERYDG磁盤組中剔除一塊磁盤
? 2.等待同步完成
? 3.將磁盤加入到DATADG磁盤組
? 4.等待同步完成
1.從RECOVERYDG磁盤組中剔除一塊磁盤
從 RECOVERYDG 剔除/dev/rhdisk38，對應信息：
512000 178001 512000 RECOVERYDG_0006 RECOVERYDG_0006 REGULAR System UNKNOWN /dev/rhdisk38
查詢asm磁盤組中的asm磁盤信息：
SQL> select disk_number, state, name, total_mb, free_mb from v$asm_disk where group_number = 2;
DISK_NUMBER STATE NAME TOTAL_MB FREE_MB
----------- ------------------------ ------------------------------------------------------------------------------------------ ---------- ----------6 NORMAL RECOVERYDG_0006 512000 1775367 NORMAL RECOVERYDG_0007 512000 1775148 NORMAL RECOVERYDG_0008 512000 1775039 NORMAL RECOVERYDG_0009 512000 17752010 NORMAL RECOVERYDG_0010 512000 17752011 NORMAL RECOVERYDG_0011 512000 1775210 NORMAL RECOVERYDG_0000 512000 177501
7 rows selected.
刪除計劃剔除的磁盤：
sqlplus / as sysasm
SQL> alter diskgroup RECOVERYDG drop disk RECOVERYDG_0006;
2.等待同步完成
等待同步完成
select * from v$asm_operation;
select disk_number, state, name, total_mb, free_mb from v$asm_disk where group_number = 2;
16:31:05 SQL> select disk_number, state, name, total_mb, free_mb from v$asm_disk where group_number = 2;
DISK_NUMBER STATE NAME TOTAL_MB FREE_MB
----------- -------- ------------------------------ ---------- ----------6 DROPPING RECOVERYDG_0006 512000 1803877 NORMAL RECOVERYDG_0007 512000 1768938 NORMAL RECOVERYDG_0008 512000 1768799 NORMAL RECOVERYDG_0009 512000 17689910 NORMAL RECOVERYDG_0010 512000 17689711 NORMAL RECOVERYDG_0011 512000 1768960 NORMAL RECOVERYDG_0000 512000 176874
16:56:44 SQL> /
DISK_NUMBER STATE NAME TOTAL_MB FREE_MB
----------- -------- ------------------------------ ---------- ----------7 NORMAL RECOVERYDG_0007 512000 1206788 NORMAL RECOVERYDG_0008 512000 1206849 NORMAL RECOVERYDG_0009 512000 12068910 NORMAL RECOVERYDG_0010 512000 12068111 NORMAL RECOVERYDG_0011 512000 1206910 NORMAL RECOVERYDG_0000 512000 120690
6 rows selected.
alert.log也會有對應的日志記錄：
Thu Apr 13 16:57:02 2017
NOTE: disk 6 (RECOVERYDG_0006) in group 2 (RECOVERYDG) is offline for reads
NOTE: disk 6 (RECOVERYDG_0006) in group 2 (RECOVERYDG) is offline for writes
SUCCESS: disk RECOVERYDG_0006 (6.2744176951) dropped from diskgroup RECOVERYDG
3.將磁盤加入到DATADG磁盤組
將/dev/rhdisk38 加入到 DATADG:
alter diskgroup DATADG add disk '/dev/rhdisk38' rebalance power 7;
查看rebalance情況：
select disk_number, state, name, total_mb, free_mb from v$asm_disk where group_number = 1;
16:59:56 SQL> select disk_number, state, name, total_mb, free_mb from v$asm_disk where group_number = 1;
DISK_NUMBER STATE NAME TOTAL_MB FREE_MB
----------- -------- ------------------------------ ---------- ----------7 NORMAL DATADG_0007 512000 10218 NORMAL DATADG_0008 512000 10169 NORMAL DATADG_0009 512000 102411 NORMAL DATADG_0011 512000 101912 NORMAL DATADG_0012 512000 102020 NORMAL DATADG_0020 512000 102521 NORMAL DATADG_0021 512000 102022 NORMAL DATADG_0022 512000 102023 NORMAL DATADG_0023 512000 101824 NORMAL DATADG_0024 512000 101725 NORMAL DATADG_0025 512000 1029
DISK_NUMBER STATE NAME TOTAL_MB FREE_MB
----------- -------- ------------------------------ ---------- ----------26 NORMAL DATADG_0026 512000 102127 NORMAL DATADG_0027 512000 102828 NORMAL DATADG_0028 512000 101829 NORMAL DATADG_0029 512000 10214 NORMAL DATADG_0004 512000 5106470 NORMAL DATADG_0000 512000 10111 NORMAL DATADG_0001 512000 13562 NORMAL DATADG_0002 512000 13543 NORMAL DATADG_0003 512000 1355
20 rows selected.
alert.log同樣也有日志記錄：
Thu Apr 13 16:59:54 2017
SUCCESS: disk DATADG_0004 (4.2744176966) added to diskgroup DATADG
4.等待同步完成
等待同步完成:
select * from v$asm_operation;
GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES ERROR_CODE
------------ ----- ---- ---------- ---------- ---------- ---------- ---------- ----------- --------------------------------------------1 REBAL RUN 7 7 10833 492997 7195 67
Elapsed: 00:00:00.46
17:00:49 SQL>
可以在同步的期間根據實際業務需求調整rebalance的級別：
17:04:59 SQL> alter diskgroup datadg rebalance power 5;
Diskgroup altered.
17:06:34 SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES ERROR_CODE
------------ ----- ---- ---------- ---------- ---------- ---------- ---------- ----------- --------------------------------------------1 REBAL RUN 5 5 11106 240895 6817 33
Elapsed: 00:00:00.46
最后同步完成，上述查詢將不會有結果輸出。
最后可以查看下DG磁盤組空間情況：
–查看DG磁盤組空間情況
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN Y 512 4096 1048576 10240000 531040 0 531040 0 N DATADG/
MOUNTED EXTERN N 512 4096 1048576 3072000 713616 0 713616 0 N RECOVERYDG/
ASMCMD>
至此，整個ASM磁盤組的刪盤加盤實施操作已經完成。
)
