RE: List disk/disk partition of the diskgroup

Quite a good script which provides a lot of information in one go

clear columns


set wrap off
set lines 200
set pages 999
col "Group"        form 999
col "Group Name"   form a25
col "Disk Name"    form a30
col "State"  form a15
col "Type"   form a7

prompt
prompt ASM Disk Groups 
prompt ===============
select group_number  "Group"
,      name          "Group Name"
,      state         "State"
,      type          "Type"
,      total_mb/1024 "Total GB"
,      free_mb/1024  "Free GB" 
from   v$asm_diskgroup 
/


prompt
prompt ASM Disks 
prompt =========

col "Group"          form 999
col "Disk"           form 999
col "Header"         form a9
col "Mode"           form a8
col "Redundancy"     form a10
col "Failure Group"  form a30
col "Path"           form a16

select group_number  "Group"
,      disk_number   "Disk"
,      header_status "Header"
,      mode_status   "Mode"
,      state         "State"
,      redundancy    "Redundancy"
,      total_mb      "Total MB"
,      free_mb       "Free MB"
,      name          "Disk Name"
,      failgroup     "Failure Group"
,      path          "Path"
from   v$asm_disk
order by group_number
,        disk_number
/

prompt
prompt Instances currently accessing these diskgroups
prompt ==============================================
col "Instance" form a8
select c.group_number  "Group"
,      g.name          "Group Name"
,      c.instance_name "Instance"
from   v$asm_client c
,      v$asm_diskgroup g
where  g.group_number=c.group_number
/

prompt
prompt Current ASM disk operations
prompt ===========================
select *
from   v$asm_operation
/

clear columns
 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Johan Eriksson
Sent: Monday, October 30, 2006 9:20 AM
To: shivaswamykr@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: List disk/disk partition of the diskgroup

Hi

Try this:
$ /etc/init.d/oracleasm
Usage: /etc/init.d/oracleasm
{start|stop|restart|enable|disable|configure|createdisk|deletedisk|query
disk|listdisks|scandisks|status}

/johan

On 10/30/06, Shivaswamy Raghunath <shivaswamykr@xxxxxxxxx> wrote:
> Hello.
>
> I could not find a way to list the disk or disk partition underlying 
> the disk group in any of the ASM views. Can you help me?
>
> Thanks,
> Shiva
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Other related posts: