RE: List disk/disk partition of the diskgroup
- From: "Steiner, Randy" <Randy.Steiner@xxxxxxxx>
- To: <shivaswamykr@xxxxxxxxx>
- Date: Mon, 30 Oct 2006 08:24:18 -0500
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
>
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
