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
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 > -- > //www.freelists.org/webpage/oracle-l > > > >