asm中怎样终止正在reblance的磁盘操作?

背景:公司新买了一套存储,准备替换。方法是通过加磁盘,剔除磁盘的方式操作。加盘时,发现盘的读写速度很慢。数据库性能明显下降
sql> alter diskgroup test add disk '/dev/mapper/asmnetappdata01p1' rebalance power 5;

asm中怎样终止正在添加的磁盘操作?
1.将正在进行reblance的磁盘终止reblance
SQL> alter diskgroup <TEST> rebalance power 0;     -----终止磁盘的reblance
Diskgroup altered.

SQL> select * from gv$asm_operation          ----检查磁盘是否终止reblance

INST_ID GROUP_NUMBER OPERA PASS STAT POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES ERROR_CODE CON_ID
---------- ------------ ----- --------- ---- ---------- ---------- ---------- ---------- ---------- ----------- -------------------------------------------- ----------
2 1 REBAL COMPACT WAIT 0 0
2 1 REBAL REBALANCE WAIT 0 0
2 1 REBAL REBUILD WAIT 0 0

SQL>

2.手动删除正在添加的磁盘
SQL> select NAME,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS ,STATE,REDUNDANCY,TOTAL_MB,FREE_MB,PATH from v$asm_disk;
NAME MOUNT_S HEADER_STATU MODE_ST STATE REDUNDA TOTAL_MB FREE_MB PATH
------------------------- ------- ------------ ------- -------- ------- ---------- ---------- -------------------------------------------------------
TEST04 CACHED MEMBER ONLINE NORMAL UNKNOWN 2097148 601540 AFD:TEST04
TEST06 CACHED MEMBER ONLINE NORMAL UNKNOWN 2097148 601480 AFD:TEST06
TEST02 CACHED MEMBER ONLINE NORMAL UNKNOWN 2097148 601512 AFD:TEST02
TEST03 CACHED MEMBER ONLINE NORMAL UNKNOWN 2097148 601516 AFD:TEST03
TEST05 CACHED MEMBER ONLINE NORMAL UNKNOWN 2097148 601544 AFD:TEST05
TEST07 CACHED MEMBER ONLINE NORMAL UNKNOWN 2097148 601584 AFD:TEST07
TEST01 CACHED MEMBER ONLINE NORMAL UNKNOWN 2097148 601552 AFD:TEST01
NETAPP0001 CACHED MEMBER ONLINE DROPPING UNKNOWN 2047996 1766320 /dev/mapper/asmnetappdata01p1 <<<<<<<新添加的盘
SQL>
3.删除正在添加的磁盘。
SQL> ALTER DISKGROUP TEST DROP DISK NETAPP0001 REBALANCE POWER 15 WAIT;
SQL>

查看删盘的进度:

SQL> select name,OS_MB,TOTAL_MB,FREE_MB,TOTAL_MB-FREE_MB from v$asm_disk_stat;

NAME OS_MB TOTAL_MB FREE_MB TOTAL_MB-FREE_MB
------------------------------ ---------- ---------- ---------- ----------------
TEST04 2097150 2097148 572348 1524800
TEST06 2097150 2097148 572280 1524868
TEST02 2097150 2097148 572312 1524836
TEST03 2097150 2097148 572324 1524824
TEST05 2097150 2097148 572340 1524808
TEST07 2097150 2097148 572388 1524760
TEST01 2097150 2097148 572352 1524796
NETAPP0001 2047999 2047996 1970704 77292

8 rows selected.

SQL>

 

posted on 2017-12-15 18:30  erwadba  阅读(448)  评论(0编辑  收藏  举报

导航