ASM磁盘空间查看
1、使用SQL查看
[rac1:grid]:/home/grid>sqlplus / as sysasm
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
SYSDG MOUNTED
DATADG MOUNTED
ARCHDG MOUNTED
SQL> select group_number,name,total_mb,free_mb from v$asm_diskgroup;
GROUP_NUMBER NAME TOTAL_MB FREE_MB
------------ ------------------------------ ---------- ----------
1 SYSDG 6144 5218
2 DATADG 15360 13360
3 ARCHDG 5120 4773
SQL> select state,name,type,total_mb, free_mb from v$asm_diskgroup_stat ;
STATE NAME TYPE TOTAL_MB FREE_MB
----------- ------------------------------ ------ ---------- ----------
MOUNTED SYSDG NORMAL 6144 5218
MOUNTED DATADG EXTERN 15360 13360
MOUNTED ARCHDG EXTERN 5120 4773
2、使用ASMCMD查看
[rac1:grid]:/home/grid>asmcmd ASMCMD> lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED EXTERN N 512 4096 1048576 5120 4773 0 4773 0 N ARCHDG/ MOUNTED EXTERN N 512 4096 1048576 15360 13360 0 13360 0 N DATADG/ MOUNTED NORMAL N 512 4096 1048576 6144 5218 310 2454 0 N SYSDG/
3、查看磁盘路径
#通过PLSQL查看磁盘组路径 select name, path, group_number from v$asm_disk_stat;
4、查看磁盘状态
SQL> SELECT SUBSTR(d.name,1,16) AS asmdisk,d.mount_status,HEADER_STATUS, d.state,dg.name AS diskgroup FROM V$ASM_DISKGROUP_STAT dg, V$ASM_DISK_STAT d WHERE dg.group_number = d.group_number; ASMDISK MOUNT_S HEADER_STATU STATE DISKGROUP ---------------- ------- ------------ -------- ------------------------------ SYSDG_0000 CACHED MEMBER NORMAL SYSDG SYSDG_0001 CACHED MEMBER NORMAL SYSDG SYSDG_0002 CACHED MEMBER NORMAL SYSDG DATADG_0000 CACHED MEMBER NORMAL DATADG ARCHDG_0000 CACHED MEMBER NORMAL ARCHDG