• 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>

  • 相关阅读:
    解析xml
    序列化为xml
    aspose.cells excel表格导入导出
    文件下载
    jquery拼接和拆分字符串,并加入特殊符号
    VC Windows系统服务创建代码
    Lua 基础知识-面向对象
    iOS 网络与多线程--8.百度地图的使用(调用系统浏览器)
    iOS 网络与多线程--7.Performselector消息处理方法
    iOS 网络与多线程--6.下载并保存网络图片
  • 原文地址:https://www.cnblogs.com/erwadba/p/8044439.html
Copyright © 2020-2023  润新知