查看磁盘组信息

SQL> select name,state from v$asm_diskgroup;
NAME			       STATE
------------------------------ -----------
SYSDG			       MOUNTED
DATADG			       CONNECTED
ARCHDG			       DISMOUNTED

[rac1:grid]:/home/grid>asmcmd ls -l
State    Type    Rebal  Name
MOUNTED  EXTERN  N      DATADG/
MOUNTED  NORMAL  N      SYSDG/

[rac1:grid]:/home/grid>asmcmd lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_fre
MOUNTED  EXTERN  N         512   4096  1048576     15360    13685             
MOUNTED  NORMAL  N         512   4096  1048576      6144     5218 

SELECT  NVL(a.name, '[CANDIDATE]') disk_group_name, b.path disk_file_path , b.name disk_file_name,b.failgroup disk_file_fail_group 
		FROM  v$asm_diskgroup a RIGHT OUTER JOIN v$asm_disk b USING (group_number) ORDER BY a.name;

SELECT GROUP_NUMBER,NAME,SECTOR_SIZE,BLOCK_SIZE,ALLOCATION_UNIT_SIZE,STATE,TYPE TOTAL_MB,FREE_MB FROM V$ASM_DISKGROUP;

SELECT MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,TOTAL_MB,FREE_MB,NAME,PATH,LABEL FROM V$ASM_DISK;