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

最新推荐文章于 2022-05-18 18:31:37 发布

weixin_30451709

最新推荐文章于 2022-05-18 18:31:37 发布

阅读量564

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/erwadba/p/8044439.html

本文介绍了在Oracle ASM环境中如何终止正在进行的磁盘Rebalance操作及手动删除正在添加的磁盘的方法。具体步骤包括使用SQL命令调整Rebalance的功率为0来停止Rebalance进程，以及通过查询gv$asm_operation视图验证Rebalance状态。此外，还提供了手动删除磁盘的具体SQL语句，并展示了如何监控删盘进度。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

背景：公司新买了一套存储，准备替换。方法是通过加磁盘，剔除磁盘的方式操作。加盘时，发现盘的读写速度很慢。数据库性能明显下降
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>

转载于:https://www.cnblogs.com/erwadba/p/8044439.html