查询oracle11g asm,ORACLE11G中ASM磁盘组基本操作

磁盘组操作，grid用户下：

sqlplus /nolog

SQL> conn / as sysasm

查询现有磁盘组及磁盘信息：

SQL> select group_number gno,name,state,type,total_mb,free_mb,required_mirror_free_mb rmfmb,usable_file_mb ufmb from v$asm_diskgroup;

GNO NAME STATE TYPE TOTAL_MB FREE_MB RMFMB UFMB

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

1 DG1 MOUNTED NORMAL 4076 575 879 -152

2 DG2 MOUNTED NORMAL 4076 3531 139 1696

SQL>

SQL> col name format a10

SQL> col fgno format a20

SQL> select group_number gno,name,failgroup fgno,state,total_mb,free_mb,header_status from v$asm_disk;

GNO NAME FGNO STATE TOTAL_MB FREE_MB HEADER_STATUS

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

0 NORMAL 0 0 PROVISIONED

0 NORMAL 0 0 PROVISIONED

1 VOL1 VOL1 NORMAL 1019 141 MEMBER

1 VOL2 VOL2 NORMAL 1019 144 MEMBER

1 VOL3 VOL3 NORMAL 1019 140 MEMBER

1 VOL4 VOL4 NORMAL 1019 150 MEMBER

2 VOL5 VOL5 NORMAL 1019 880 MEMBER

2 VOL6 VOL6 NORMAL 1019 883 MEMBER

2 VOL7 VOL7 NORMAL 1019 885 MEMBER

2 VOL8 VOL8 NORMAL 1019 883 MEMBER

10 rows selected.

--创建磁盘组

SQL> create diskgroup dg3 normal redundancy disk 'ORCL:VOL9','ORCL:VOL10';

Diskgroup created.

或：

SQL> create diskgroup dg3 normal redundancy disk 'ORCL:VOL9' disk 'ORCL:VOL10';

Diskgroup created.

--添加磁盘

SQL> alter diskgroup dg1 add disk 'ORCL:VOL9';

Diskgroup altered.

--删除磁盘

SQL> alter diskgroup dg1 drop disk VOL9;

Diskgroup altered.

SQL> select group_number gno,name,failgroup fgno,state,total_mb,free_mb,header_status from v$asm_disk;

GNO NAME FGNO STATE TOTAL_MB FREE_MB HEADER_STATUS

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

0 NORMAL 0 0 FORMER

1 VOL1 VOL1 NORMAL 1019 284 MEMBER

1 VOL2 VOL2 NORMAL 1019 286 MEMBER

1 VOL3 VOL3 NORMAL 1019 284 MEMBER

1 VOL4 VOL4 NORMAL 1019 287 MEMBER

2 VOL5 VOL5 NORMAL 1019 880 MEMBER

2 VOL6 VOL6 NORMAL 1019 883 MEMBER

2 VOL7 VOL7 NORMAL 1019 885 MEMBER

2 VOL8 VOL8 NORMAL 1019 883 MEMBER

1 VOL9 VOL9 DROPPING 1019 451 MEMBER

10 rows selected.

--取消删除

alter diskgroup dg1 undrop disks;

--调整大小

ALTER DISKGROUP DG1 RESIZE DISK VOL4 SIZE 1024 M

--unmount和mount磁盘组

SQL> alter diskgroup dg3 dismount;

Diskgroup altered.

SQL> select group_number gno,name,state,type,total_mb,free_mb,required_mirror_free_mb rmfmb,usable_file_mb ufmb from v$asm_diskgroup;

GNO NAME STATE TYPE TOTAL_MB FREE_MB RMFMB UFMB

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

1 DG1 MOUNTED NORMAL 4076 575 879 -152

2 DG2 MOUNTED NORMAL 4076 3531 139 1696

0 DG3 DISMOUNTED

SQL> alter diskgroup dg3 mount;

Diskgroup altered.