Home > Oracle > Check Asm Disks

Check Asm Disks

SQL>set pages 50000 lines 120
col path for a30
select disk_number,
mount_status,
header_status,
mode_status,
state,path
from v$asm_disk ;

DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE    PATH
----------- ------- ------------ ------- -------- ------------------------------
0 CLOSED  CANDIDATE    ONLINE  NORMAL   /dev/raw/raw4
1 CLOSED  CANDIDATE    ONLINE  NORMAL   /dev/raw/raw3
0 CACHED  MEMBER       ONLINE  NORMAL   /dev/raw/raw2
0 CACHED  MEMBER       ONLINE  NORMAL   /dev/raw/raw1

SQL>set pages 50000 lines 120
select path,redundancy,total_mb,free_mb,failgroup
from v$asm_disk
where mount_status='CACHED' and header_status='MEMBER' and
mode_status='ONLINE' and state='NORMAL'
order by path;

PATH                     REDUNDA   TOTAL_MB    FREE_MB FAILGROUP
------------------------ ------- ---------- ---------- ------------------------------
/dev/raw/raw1            UNKNOWN       5114       3500 DATA_0000
/dev/raw/raw2            UNKNOWN       5114       4206 FLASH_0000

--check free space in ASM
asmcmd lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Name
MOUNTED  EXTERN  N         512   4096  1048576      5114     3469                0            3469              0  DATA/
MOUNTED  EXTERN  N         512   4096  1048576      5114     4158                0            4158              0  FLASH/

 

 
 

-- Check ASM diskgroup built on raw devices
set pages 50000 lines 120
col path for a15
select a.path,b.NAME from v$asm_disk a, v$asm_diskgroup b
where a.GROUP_NUMBER=b.GROUP_NUMBER and
a.path like '%raw%' ;

PATH            NAME
--------------- ------------------------------
/dev/raw/raw4   FLASH
/dev/raw/raw3   DATA
/dev/raw/raw2   FLASH
/dev/raw/raw1   DATA

check how the different disks of the diskgroups are utilized
select
        instname,
        dbname,
        group_number,
        failgroup,
        disk_number,
        reads,
        writes
from v$asm_disk_iostat
order by 1,2,3,4,5,6
/
INSTNAME   DBNAME   GROUP_NUMBER FAILGROUP  DISK_NUMBER      READS     WRITES
---------- -------- ------------ ---------- ----------- ---------- ----------
TESTORAC   TESTORAC            1 DATA_0000            0      10137       3381
TESTORAC   TESTORAC            1 DATA_0001            1      10535       2960
TESTORAC   TESTORAC            2 FLASH_0000           0       7448       6174
TESTORAC   TESTORAC            2 FLASH_0001           1      20354       8223

Advertisements
Categories: Oracle
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: