Check Asm Disks


bash-3.2$ ps -afe | grep smon

root 823 1 0 Dec 23 ? 142:13 /u02/app/oracle/product/grid/db_1/bin/osysmond.bin

oracle 19016 1 0 Jun 20 ? 7:03 asm_smon_+ASM1

oracle 4844 1 0 Dec 22 ? 1:10 ora_smon_ANARDB1

oracle 21510 18592 0 15:27:13 pts/2 0:00 grep smon

bash-3.2$

bash-3.2$

bash-3.2$ sqll

SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 27 15:27:14 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.







Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL>

SQL> select name from v$database;

NAME

---------

ANARDB







SQL> set pages 50000 lines 120

SQL> col path for a30

SQL> select disk_number,

2 mount_status,

3 header_status,

4 mode_status,

5 state,path

6 from v$asm_disk ;

DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE PATH

----------- ------- ------------ ------- -------- ------------------------------

0 CACHED MEMBER ONLINE NORMAL /dev/rdsk/emcpower0a

1 CACHED MEMBER ONLINE NORMAL /dev/rdsk/emcpower1a

0 CACHED MEMBER ONLINE NORMAL /dev/rdsk/emcpower2a

SQL> set pages 50000 lines 120

SQL> select path,redundancy,total_mb,free_mb,failgroup

2 from v$asm_disk

3 where mount_status='CACHED' and header_status='MEMBER' and

4 mode_status='ONLINE' and state='NORMAL'

5 order by path;

PATH REDUNDA TOTAL_MB FREE_MB FAILGROUP

------------------------------ ------- ---------- ---------- ------------------------------

/dev/rdsk/emcpower0a UNKNOWN 307140 235583 DATA_0000

/dev/rdsk/emcpower1a UNKNOWN 307140 235607 DATA_0001

/dev/rdsk/emcpower2a UNKNOWN 204752 201573 FRA_0000







SQL> set pages 50000 lines 120

SQL> col path for a15

SQL> select a.path,b.NAME from v$asm_disk a, v$asm_diskgroup b

2 where a.GROUP_NUMBER=b.GROUP_NUMBER and

3 a.path like '%raw%' ;

no rows selected

SQL> set pages 50000 lines 120

SQL> col path for a15

SQL> select a.path,b.NAME from v$asm_disk a, v$asm_diskgroup b

2 where a.GROUP_NUMBER=b.GROUP_NUMBER;

PATH NAME

--------------- ------------------------------

/dev/rdsk/emcpo DATA

wer0a

/dev/rdsk/emcpo DATA

wer1a

/dev/rdsk/emcpo FRA

wer2a







SQL> select

2 instname,

3 dbname,

4 group_number,

5 failgroup,

6 disk_number,

7 reads,

8 writes

9 from v$asm_disk_iostat

10 order by 1,2,3,4,5,6

11 /

INSTNAME DBNAME GROUP_NUMBER FAILGROUP

---------------------------------------------------------------- -------- ------------ ------------------------------

DISK_NUMBER READS WRITES

----------- ---------- ----------

ANARDB1 ANARDB 1 DATA_0000

0 25109347 5938833

ANARDB1 ANARDB 1 DATA_0001

1 25948365 6987332

ANARDB1 ANARDB 2 FRA_0000

0 24 14607

 

Advertisements

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: