ASM在线替换ASM磁盘

1.查看ASM磁盘组和ASM磁盘间的关系

SQL> select a.path,b.name from v$asm_disk a,v$asm_diskgroup b where a.group_number=b.group_number;

PATH       NAME
---------- ------------------------------
ORCL:VOL1  DATA
ORCL:VOL3  DATA
ORCL:VOL4  ARCHIVELOG

SQL> 

2.往ASM磁盘中中添加ASM磁盘

SQL> alter diskgroup DATA add disk 'ORCL:VOL2' rebalance power 10;

Diskgroup altered.


3.查看rebalance进度，确保完成
SQL> select * from v$asm_operation;

GROUP_NUMBER OPERA STAT      POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE
------------ ----- ---- ---------- ---------- ---------- ---------- ----------
EST_MINUTES ERROR_CODE
----------- --------------------------------------------
           2 REBAL RUN          10         10        113       6190        358
         16

SQL> select * from v$asm_operation;

no rows selected

4.查看ASM磁盘组和ASM磁盘间的关系

SQL> select a.path,b.name from v$asm_disk a,v$asm_diskgroup b where a.group_number=b.group_number;


PATH       NAME
---------- ------------------------------
ORCL:VOL1  DATA
ORCL:VOL2  DATA
ORCL:VOL3  DATA
ORCL:VOL4  ARCHIVELOG


SQL> 

5.从ASM磁盘组中删除ASM磁盘

SQL> alter diskgroup DATA drop disk 'VOL3' rebalance power 10;

Diskgroup altered.

6.查看rebalance进度，确保完成

SQL> select * from v$asm_operation;


GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES
------------ ----- ---- ----- ------ ----- -------- -------- -----------
ERROR_CODE
--------------------------------------------
           2 REBAL RUN     10     10   947     6472     1448           3

SQL> select * from v$asm_operation;

no rows selected

7.查看ASM磁盘组和ASM磁盘间的关系

SQL> select a.path,b.name from v$asm_disk a,v$asm_diskgroup b where a.group_number=b.group_number;

PATH       NAME
---------- ------------------------------
ORCL:VOL1  DATA
ORCL:VOL2  DATA
ORCL:VOL4  ARCHIVELOG

SQL> 

至此成功将VOL3替换为VOL2。