在传统的ASM磁盘组管理中,常分步骤使用alter diskgroup add(drop) disk disk_name(disk_path) rebalance power #
但在实际操作中可联合使用参数来删除磁盘,速度会比较快些。
测试环境:两个节点(Oracle11.2.0.3 patch 29)在PC机的vmware 虚拟机,磁盘使用本地硬盘。
方法一:增加 disk是 power 为0
SQL> alter diskgroup datadg add disk '\\.\ORCLDISKDATA0' rebalance power 0;
SQL> select * from gv$asm_operation;
INST_ID GROUP_NUMBER OPERATION STATE POWER ACTUAL SOFAR
---------- ------------ ---------- -------- ---------- ---------- ----------
EST_WORK EST_RATE EST_MINUTES
---------- ---------- -----------
ERROR_CODE
--------------------------------------------------------------------------------
1 1 REBAL WAIT 0
3 1 REBAL WAIT 0
INST_ID GROUP_NUMBER OPERATION STATE POWER ACTUAL SOFAR
---------- ------------ ---------- -------- ---------- ---------- ----------
EST_WORK EST_RATE EST_MINUTES
---------- ---------- -----------
ERROR_CODE
--------------------------------------------------------------------------------
从15:25考试,到17:51结束。
SQL>alter diskgroup datadg drop disk datadg_0000 rebalance power 8;
SQL> alter diskgroup datadg rebalance power 10;
Wed Jul 25 15:25:03 2018
SQL> alter diskgroup datadg drop disk datadg_0000 rebalance power 8
NOTE: GroupBlock outside rolling migration privileged region
NOTE: requesting all-instance membership refresh for group=1
。。。。。。。。。。。。。。
NOTE: Attempting voting file refresh on diskgroup DATADG
Wed Jul 25 17:51:49 2018
NOTE: stopping process ARB0
SUCCESS: rebalance completed for group 1/0x47f0a018 (DATADG)