ASM在线替换ASM磁盘

来源：互联网发布：网络写作和传统写作编辑：程序博客网时间：2024/05/18 02:05

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。

0 0