sqlplus 添加和删除磁盘

1，添加磁盘

alter diskgroup newdata add disk '/dev/rhdiskpower1' rebalance power 8;
alter diskgroup newdata add disk '/dev/rhdiskpower2' rebalance power 8;
alter diskgroup newdata add disk '/dev/rhdiskpower7' rebalance power 8;
alter diskgroup newdata add disk '/dev/rhdiskpower8' rebalance power 8;
alter diskgroup newdata add disk '/dev/rhdiskpower9' rebalance power 8;
alter diskgroup newdata add disk '/dev/rhdiskpower10' rebalance power 8;
alter diskgroup newdata add disk '/dev/rhdiskpower11' rebalance power 8;
alter diskgroup newdata add disk '/dev/rhdiskpower12' rebalance power 8;
alter diskgroup newdata add disk '/dev/rhdiskpower13' rebalance power 8;
alter diskgroup newdata add disk '/dev/rhdiskpower14' rebalance power 8;
alter diskgroup newdata add disk '/dev/rhdiskpower18' rebalance power 8;

2，删除磁盘

 SQL> select name,path,state from v$asm_disk ORDER BY 2;

NAME                           PATH                 STATE
------------------------------ -------------------- --------
ZXMRIDATA_0000                 /dev/rhdiskpower0    NORMAL
NEWDATA_0000                   /dev/rhdiskpower1    NORMAL
NEWDATA_0005                   /dev/rhdiskpower10   NORMAL
NEWDATA_0006                   /dev/rhdiskpower11   NORMAL
NEWDATA_0007                   /dev/rhdiskpower12   NORMAL
NEWDATA_0008                   /dev/rhdiskpower13   NORMAL
NEWDATA_0009                   /dev/rhdiskpower14   NORMAL
ZXMRIDATA_0001                 /dev/rhdiskpower15   NORMAL
NEWDATA_0010                   /dev/rhdiskpower18   NORMAL
NEWDATA_0001                   /dev/rhdiskpower2    NORMAL
OCR_0003                       /dev/rhdiskpower20   NORMAL
OCR_0004                       /dev/rhdiskpower21   NORMAL
OCR_0005                       /dev/rhdiskpower22   NORMAL
ZXMRIDATA_0002                 /dev/rhdiskpower23   NORMAL
ZXMRIDATA_0003                 /dev/rhdiskpower24   NORMAL
NEWDATA_0011                   /dev/rhdiskpower25   NORMAL
NEWDATA_0012                   /dev/rhdiskpower26   NORMAL
                               /dev/rhdiskpower27   NORMAL
NEWDATA_0013                   /dev/rhdiskpower28   NORMAL
NEWDATA_0014                   /dev/rhdiskpower29   NORMAL
                               /dev/rhdiskpower3    NORMAL
NEWDATA_0015                   /dev/rhdiskpower30   NORMAL
NEWDATA_0016                   /dev/rhdiskpower31   NORMAL
NEWDATA_0017                   /dev/rhdiskpower32   NORMAL
NEWDATA_0018                   /dev/rhdiskpower33   NORMAL
NEWDATA_0019                   /dev/rhdiskpower34   NORMAL
NEWDATA_0020                   /dev/rhdiskpower35   NORMAL
NEWDATA_0021                   /dev/rhdiskpower36   NORMAL
                               /dev/rhdiskpower4    NORMAL
                               /dev/rhdiskpower5    NORMAL
                               /dev/rhdiskpower6    NORMAL
NEWDATA_0002                   /dev/rhdiskpower7    NORMAL
NEWDATA_0003                   /dev/rhdiskpower8    NORMAL
NEWDATA_0004                   /dev/rhdiskpower9    NORMAL

####
 alter diskgroup newdata drop DISK 
NEWDATA_0011,
NEWDATA_0012,
NEWDATA_0013,
NEWDATA_0014,
NEWDATA_0015,
NEWDATA_0016,
NEWDATA_0017,
NEWDATA_0018,
NEWDATA_0019,
NEWDATA_0020,
NEWDATA_0021 rebalance power 8;

####

3，查看同步

$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Mon Sep 6 21:38:03 2021

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> select * from V$ASM_OPERATION;

GROUP_NUMBER OPERA STAT      POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE
------------ ----- ---- ---------- ---------- ---------- ---------- ----------
EST_MINUTES ERROR_CODE
----------- --------------------------------------------
           1 REBAL RUN           8          8      50046      60796       8355
          1


SQL>