Re: List disk/disk partition of the diskgroup

Thank you, Randy.

I get this:
[oracle@lin2 disks]$ pwd
/dev/oracleasm/disks
[oracle@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@xxxxxxxx> 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@xxxxxxxxxxxxx
[mailto: oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Shivaswamy Raghunath
> Sent: Monday, October 30, 2006 7:03 AM
> To: Hallas, John
> Cc: valpis@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxx > 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@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|q
> uery
>       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
>
>
>
>


Other related posts: