asm删除磁盘操作asmdropdisk_sqlora

http://blog.sina.com.cn/u/5592732073

首页博文目录关于我

个人资料

微博

加好友发纸条

写留言加关注

博客等级：
博客积分：

博客访问：
关注人气：
获赠金笔：0支
赠出金笔：0支
荣誉徽章：

正文字体大小：大中小

asm删除磁盘操作asmdropdisk

(2018-09-13 10:44:36)

分类： oracle

Authorized users only.All activities will be monitored and reported.

[root@racj1 ~]# su - grid

[grid@racj1 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Thu Sep 13 10:27:05 2018

SQL> conn /as sysasm

Connected.

SQL> set line 132

SQL> set wrap off

SQL> col name for a20

SQL> col path for a30

SQL> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;

GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB

------------ -------------------- ---------------------- ---------- ----------

1 ARCHDG MOUNTED 1024000 1023868

2 CRSDG MOUNTED 25600 24670

3 DATADG MOUNTED 9216000 7790628

SQL> select group_number,mount_status,path from v$asm_disk where mount_status='CLOSED';

no rows selected

SQL> select name,path,group_number, disk_number,mount_status,header_status,mode_status,state from v$asm_disk;

rows will be truncated

NAME PATH GROUP_NUMBER DISK_NUMBER MOUNT_STATUS HEADER_STATUS MODE_STATUS

-------------------- ------------------------------ ------------ ----------- -------------- ------------------------ --------------

ARCHDG_0000 /dev/asmdisk/asm-data01 1 0 CACHED MEMBER ONLINE

DATADG_0009 /dev/asmdisk/asm-data12 3 9 CACHED MEMBER ONLINE

DATADG_0015 /dev/asmdisk/asm-data18 3 15 CACHED MEMBER ONLINE

DATADG_0016 /dev/asmdisk/asm-data19 3 16 CACHED MEMBER ONLINE

DATADG_0013 /dev/asmdisk/asm-data16 3 13 CACHED MEMBER ONLINE

DATADG_0017 /dev/asmdisk/asm-data20 3 17 CACHED MEMBER ONLINE

DATADG_0011 /dev/asmdisk/asm-data14 3 11 CACHED MEMBER ONLINE

DATADG_0012 /dev/asmdisk/asm-data15 3 12 CACHED MEMBER ONLINE

DATADG_0014 /dev/asmdisk/asm-data17 3 14 CACHED MEMBER ONLINE

DATADG_0007 /dev/asmdisk/asm-data10 3 7 CACHED MEMBER ONLINE

DATADG_0010 /dev/asmdisk/asm-data13 3 10 CACHED MEMBER ONLINE

NAME PATH GROUP_NUMBER DISK_NUMBER MOUNT_STATUS HEADER_STATUS MODE_STATUS

-------------------- ------------------------------ ------------ ----------- -------------- ------------------------ --------------

DATADG_0006 /dev/asmdisk/asm-data09 3 6 CACHED MEMBER ONLINE

DATADG_0002 /dev/asmdisk/asm-data05 3 2 CACHED MEMBER ONLINE

DATADG_0003 /dev/asmdisk/asm-data06 3 3 CACHED MEMBER ONLINE

DATADG_0005 /dev/asmdisk/asm-data08 3 5 CACHED MEMBER ONLINE

DATADG_0008 /dev/asmdisk/asm-data11 3 8 CACHED MEMBER ONLINE

DATADG_0004 /dev/asmdisk/asm-data07 3 4 CACHED MEMBER ONLINE

DATADG_0000 /dev/asmdisk/asm-data03 3 0 CACHED MEMBER ONLINE

DATADG_0001 /dev/asmdisk/asm-data04 3 1 CACHED MEMBER ONLINE

ARCHDG_0001 /dev/asmdisk/asm-data02 1 1 CACHED MEMBER ONLINE

CRSDG_0004 /dev/asmdisk/asm-crs05 2 4 CACHED MEMBER ONLINE

CRSDG_0002 /dev/asmdisk/asm-crs03 2 2 CACHED MEMBER ONLINE

NAME PATH GROUP_NUMBER DISK_NUMBER MOUNT_STATUS HEADER_STATUS MODE_STATUS

-------------------- ------------------------------ ------------ ----------- -------------- ------------------------ --------------

CRSDG_0003 /dev/asmdisk/asm-crs04 2 3 CACHED MEMBER ONLINE

CRSDG_0001 /dev/asmdisk/asm-crs02 2 1 CACHED MEMBER ONLINE

CRSDG_0000 /dev/asmdisk/asm-crs01 2 0 CACHED MEMBER ONLINE

25 rows selected.

SQL> ALTER DISKGROUP DATADG DROP DISK DATADG_0017;

Diskgroup altered.

SQL> ALTER DISKGROUP DATADG DROP DISK DATADG_0016;

Diskgroup altered.

SQL> select * from v$asm_operation;

GROUP_NUMBER OPERATION STATE POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES ERROR_CODE

------------ ---------- -------- ---------- ---------- ---------- ---------- ---------- ----------- --------------------------------

3 REBAL RUN 1 1 2 55488 1400 39

SQL> alter diskgroup DATADG rebalance power 11;

Diskgroup altered.

SQL> select round(100*SOFAR/EST_WORK ,2),EST_MINUTES,power from v$asm_operation;

ROUND(100*SOFAR/EST_WORK,2) EST_MINUTES POWER

--------------------------- ----------- ----------

2.22 9 11

SQL> /

ROUND(100*SOFAR/EST_WORK,2) EST_MINUTES POWER

--------------------------- ----------- ----------

2.66 9 11

SQL> /

ROUND(100*SOFAR/EST_WORK,2) EST_MINUTES POWER

--------------------------- ----------- ----------

3.53 8 11

SQL> /

ROUND(100*SOFAR/EST_WORK,2) EST_MINUTES POWER

--------------------------- ----------- ----------

5.82 6 11

SQL> select * from v$asm_operation;

GROUP_NUMBER OPERATION STATE POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES ERROR_CODE

------------ ---------- -------- ---------- ---------- ---------- ---------- ---------- ----------- --------------------------------

3 REBAL RUN 11 11 3889 55016 7679 6

SQL> /

GROUP_NUMBER OPERATION STATE POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES ERROR_CODE

------------ ---------- -------- ---------- ---------- ---------- ---------- ---------- ----------- --------------------------------

3 REBAL RUN 11 11 5951 55016 7858 6

SQL> select round(100*SOFAR/EST_WORK ,2),EST_MINUTES,power from v$asm_operation;

ROUND(100*SOFAR/EST_WORK,2) EST_MINUTES POWER

--------------------------- ----------- ----------

12.95 5 11

SQL> set timing on

SQL> set time on

10:31:12 SQL> set timing off

10:31:16 SQL> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;

GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB

------------ -------------------- ---------------------- ---------- ----------

1 ARCHDG MOUNTED 1024000 1023868

2 CRSDG MOUNTED 25600 24670

3 DATADG MOUNTED 8192000 6766628

10:31:24 SQL> select round(100*SOFAR/EST_WORK ,2),EST_MINUTES,power from v$asm_operation;

ROUND(100*SOFAR/EST_WORK,2) EST_MINUTES POWER

--------------------------- ----------- ----------

24.62 5 11

10:31:57 SQL> select name,path,group_number, disk_number,mount_status,header_status,mode_status,state from v$asm_disk;