SQL Script to Check Disk Group & Disks Details

advertisements

_____________________________________________________________________________________________________________________

SQL Script

set pages 1000 lines 333
col PATH for a50col ADG_NAME for a15
col DG_STATE for a10
col FAILGROUP for a20

select adg.name adg_name, adg.state dg_state, adg.type, ad.disk_number dsk_no,
ad.path,ad.total_mb,ad.free_mb, ad.mount_status, ad.FAILGROUP, ad.state 
from v$asm_diskgroup adg, v$asm_disk ad
where adg.group_number=ad.group_number
order by adg_name, dsk_no;

Sample Output

SQL> set lines 750 pages 9999
SQL>
SQL> select dg.name dg_name, dg.state dg_state, dg.type, d.disk_number dsk_no,
  2  d.path,d.total_mb,d.free_mb, d.mount_status, d.FAILGROUP, d.state
  3  from v$asm_diskgroup dg, v$asm_disk d
  4  where dg.group_number=d.group_number
  5  order by dg_name, dsk_no;

ADG_NAME        DG_STATE   TYPE       DSK_NO PATH                                                      TOTAL_MB    FREE_MB MOUNT_S FAILGROUP            STATE
--------------- ---------- ------ ---------- --------------------------------------------------      ---------- ---------- ------- -------------------- --------
DATA            CONNECTED  HIGH            0 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx            4479008     902628 CACHED  xxxxxxxxxx           NORMAL
DATA            CONNECTED  HIGH            1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx            4479008     902316 CACHED  xxxxxxxxxx           NORMAL
DATA            CONNECTED  HIGH            2 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx            4479008     903000 CACHED  xxxxxxxxxx           NORMAL

_____________________________________________________________________________________________________________________

Website Stats