ASM QUICK REF‎ > ‎

ASM Disk Discovery

posted Mar 14, 2011, 1:57 PM by Sachchida Ojha   [ updated Mar 15, 2011, 7:56 AM ]
column path format a20
set lines 135
set pages 50


SQL> SELECT PATH, GROUP_NUMBER GROUP_#, DISK_NUMBER DISK_#, MOUNT_STATUS,HEADER_STATUS, STATE, TOTAL_MB, FREE_MB
FROM V$ASM_DISK
ORDER BY GROUP_NUMBER; 

PATH                                GROUP_#     DISK_# MOUNT_S HEADER_STATU STATE      TOTAL_MB    FREE_MB
-------------------------------- ---------- ---------- ------- ------------ -------- ---------- ----------
/dev/rhdisk10                             1          0 CACHED  MEMBER       NORMAL       112001       4793
/dev/rhdisk8                              1          7 CACHED  MEMBER       NORMAL       112001       4629
/dev/rhdisk9                              1          8 CACHED  MEMBER       NORMAL       112001       4624
/dev/rhdisk11                             1          1 CACHED  MEMBER       NORMAL       112001       4631
/dev/rhdisk12                             1          2 CACHED  MEMBER       NORMAL       112001       4627
/dev/rhdisk13                             1          3 CACHED  MEMBER       NORMAL       112001       4626
/dev/rhdisk15                             1         12 CACHED  MEMBER       NORMAL       112001       4626
/dev/rhdisk16                             1          9 CACHED  MEMBER       NORMAL       112001       4630
/dev/rhdisk17                             1         10 CACHED  MEMBER       NORMAL       112001       4629
/dev/rhdisk18                             1         11 CACHED  MEMBER       NORMAL       112001       4628
/dev/rhdisk19                             1         13 CACHED  MEMBER       NORMAL       112001       4628

PATH                                GROUP_#     DISK_# MOUNT_S HEADER_STATU STATE      TOTAL_MB    FREE_MB
-------------------------------- ---------- ---------- ------- ------------ -------- ---------- ----------
/dev/rhdisk20                             1         14 CACHED  MEMBER       NORMAL       112001       4626
/dev/rhdisk21                             1         15 CACHED  MEMBER       NORMAL       112001       4626
/dev/rhdisk22                             1         16 CACHED  MEMBER       NORMAL       112001       4627
/dev/rhdisk23                             1         17 CACHED  MEMBER       NORMAL       112001       4629
/dev/rhdisk24                             1         18 CACHED  MEMBER       NORMAL       112001       4629
/dev/rhdisk5                              1          4 CACHED  MEMBER       NORMAL       112001       4622
/dev/rhdisk6                              1          5 CACHED  MEMBER       NORMAL       112001       4631
/dev/rhdisk7                              1          6 CACHED  MEMBER       NORMAL       112001       4624
/dev/rhdisk14                             2          0 CACHED  MEMBER       NORMAL        51200      35813
                                          2          1 MISSING UNKNOWN      FORCING           0          0

21 rows selected.

Comments