RE: List disk/disk partition of the diskgroup

From: Hallas, John <john.hallas_at_eds.com>
Date: Mon, 30 Oct 2006 12:12:03 +0100
Message-ID: <C353F42ACF29E240B9050B86F1852A4F012795E3@nlspm204.emea.corp.eds.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Johan Eriksson Sent: Monday, October 30, 2006 9:20 AM
To: shivaswamykr_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: List disk/disk partition of the diskgroup

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_at_gmail.com> 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

Received on Mon Oct 30 2006 - 05:12:03 CST