Re: List disk/disk partition of the diskgroup

Thank you, Randy.

I get this:
[oracle_at_lin2 disks]$ pwd
/dev/oracleasm/disks
[oracle_at_lin2 disks]$ ls -l
total 0

brw-rw----  1 oracle dba 8, 2 Oct 29 13:26 VOL1
brw-rw----  1 oracle dba 8, 3 Oct 29 13:26 VOL2
brw-rw----  1 oracle dba 8, 4 Oct 29 13:26 VOL3

Actually I want to be able to query the disk/disk partition name underlying the DiskGroup.

Can you someone help?

Thanks,
Shiva

On 10/30/06, Steiner, Randy <Randy.Steiner_at_nyct.com> wrote:
>
> Is this what your looking for:
>
> To associate an ASM disk with a linux device:
> cd /dev/oracleasm/disks
> ls -l
> brw-rw---- 1 oracle oinstall 8, 176 May 11 15:19 DISK11
> brw-rw---- 1 oracle oinstall 8, 208 May 11 15:19 DISK12
> brw-rw---- 1 oracle oinstall 8, 224 May 11 15:19 DISK13
> brw-rw---- 1 oracle oinstall 8, 240 May 11 15:19 DISK14
> brw-rw---- 1 oracle oinstall 8, 160 May 11 15:19 DISK15
> brw-rw---- 1 oracle oinstall 8, 32 May 11 15:19 DISK2
> brw-rw---- 1 oracle oinstall 8, 48 May 11 15:19 DISK3
> brw-rw---- 1 oracle oinstall 8, 64 May 11 15:19 DISK4
> brw-rw---- 1 oracle oinstall 8, 80 May 11 15:19 DISK5
> brw-rw---- 1 oracle oinstall 8, 96 May 11 15:19 DISK6
> brw-rw---- 1 oracle oinstall 8, 112 May 11 15:19 DISK7
> brw-rw---- 1 oracle oinstall 8, 128 May 11 15:19 DISK8
> brw-rw---- 1 oracle oinstall 8, 144 May 11 15:19 DISK9
>
> /cd dev
> ls -l | grep '8, 176'
> brw-rw---- 1 root disk 8, 176 Jun 24 2004 sdl
>
>
>
>
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org
> [mailto: oracle-l-bounce_at_freelists.org]
> > On Behalf Of Shivaswamy Raghunath
> > Sent: Monday, October 30, 2006 7:03 AM
> > To: Hallas, John
> > Cc: valpis_at_gmail.com; oracle-l_at_freelists.org
> > Subject: Re: List disk/disk partition of the diskgroup
> >
> > Thank you everybody. But I am not able to list what I want from these.
> May
> > be I did not explain well.
> >
> > While creating the ASMDISK during installation, I had used:
> > # /etc/init.d/oracleasm createdisk VOL1 /dev/sda2
> >
> > I want to see "/dev/sda2" in my listing now (preferably) in an ASM
> > Instance or a database instance. And I do not know how to do it. If
> you
> > know, can you share it?
> >
> >
> >
> > On 10/30/06, Hallas, John <john.hallas_at_eds.com > wrote:
> >
> > 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 <http://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
> >
> > Hi
> >
> > Try this:
> > $ /etc/init.d/oracleasm
> > Usage: /etc/init.d/oracleasm
> >
> {start|stop|restart|enable|disable|configure|createdisk|deletedisk|q
> > uery
> > 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