Friday, March 16, 2012

Preparing LUN's for ASM with ASMLIB

A few simple steps for preparing new LUN's for addition to ASM.

Become root.


root@svr01[inst1]:/etc/init.d> oracleasm listdisks
VOL1
VOL10
VOL11
VOL12
VOL13
VOL14
VOL2
VOL3
VOL4
VOL5
VOL6
VOL7
VOL8
VOL9

root@svr01[inst1]:/etc/init.d> oracleasm createdisk VOL15 /dev/dm-34
Writing disk header: done
Instantiating disk: done

root@svr01[inst1]:/etc/init.d> oracleasm createdisk VOL16 /dev/dm-35
Writing disk header: done
Instantiating disk: done

root@svr01[inst1]:/etc/init.d> oracleasm createdisk VOL17 /dev/dm-36
Writing disk header: done
Instantiating disk: done

root@svr01[inst1]:/etc/init.d> oracleasm listdisks
VOL1
VOL10
VOL11
VOL12
VOL13
VOL14
VOL15
VOL16
VOL17
VOL2
VOL3
VOL4
VOL5
VOL6
VOL7
VOL8
VOL9

Monday, March 05, 2012

ASM Map To Disk

Here is a quick and simple way to map your ASM disks to their physical disks.  The examples are from Linux.


SQL> select path from v$asm_disk;

PATH
----------------------------------------------
/dev/oracleasm/disks/VOL3
/dev/oracleasm/disks/VOL7
/dev/oracleasm/disks/VOL4
/dev/oracleasm/disks/VOL8
/dev/oracleasm/disks/VOL5
/dev/oracleasm/disks/VOL9
/dev/oracleasm/disks/VOL10
/dev/oracleasm/disks/VOL11
/dev/oracleasm/disks/VOL12
/dev/oracleasm/disks/VOL6
/dev/oracleasm/disks/VOL13
/dev/oracleasm/disks/VOL14
/dev/oracleasm/disks/VOL1
/dev/oracleasm/disks/VOL2

14 rows selected.

(I used the following to get the Major and Minor numbers to id the disks):

$>:/home/oracle> cd /dev/oracleasm/disks
$>:/dev/oracleasm/disks> ls -ltarF
total 0
drwxr-xr-x 4 root   root       0 Sep 23 22:30 ../
drwxr-xr-x 1 root   root       0 Sep 23 22:30 ./
brw-rw---- 1 oracle dba  253, 30 Mar  5 13:54 VOL8
brw-rw---- 1 oracle dba  253, 32 Mar  5 13:54 VOL7
brw-rw---- 1 oracle dba  253, 31 Mar  5 13:54 VOL4
brw-rw---- 1 oracle dba  253, 33 Mar  5 13:54 VOL3
brw-rw---- 1 oracle dba  253, 19 Mar  5 13:54 VOL2
brw-rw---- 1 oracle dba  253, 22 Mar  5 13:54 VOL14
brw-rw---- 1 oracle dba  253, 23 Mar  5 13:54 VOL13
brw-rw---- 1 oracle dba  253, 27 Mar  5 13:54 VOL10
brw-rw---- 1 oracle dba  253, 20 Mar  5 13:54 VOL1
brw-rw---- 1 oracle dba  253, 28 Mar  5 13:54 VOL9
brw-rw---- 1 oracle dba  253, 24 Mar  5 13:54 VOL6
brw-rw---- 1 oracle dba  253, 29 Mar  5 13:54 VOL5
brw-rw---- 1 oracle dba  253, 25 Mar  5 13:54 VOL12
brw-rw---- 1 oracle dba  253, 26 Mar  5 13:54 VOL11

$>:/home/oracle> ls -l /dev
brw-rw----  1 root root 253,     0 Sep 23 22:29 dm-0
brw-rw----  1 root root 253,     1 Sep 23 22:29 dm-1
brw-rw----  1 root root 253,    10 Sep 23 22:29 dm-10
brw-rw----  1 root root 253,    11 Sep 23 22:29 dm-11
brw-rw----  1 root root 253,    12 Sep 23 22:29 dm-12
brw-rw----  1 root root 253,    13 Sep 23 22:29 dm-13
brw-rw----  1 root root 253,    14 Sep 23 22:29 dm-14
brw-rw----  1 root root 253,    15 Sep 23 22:29 dm-15
brw-rw----  1 root root 253,    16 Sep 23 22:29 dm-16
brw-rw----  1 root root 253,    17 Sep 23 22:29 dm-17
brw-rw----  1 root root 253,    18 Sep 23 22:29 dm-18
brw-rw----  1 root root 253,    19 Sep 23 22:29 dm-19
brw-rw----  1 root root 253,     2 Sep 23 22:29 dm-2
brw-rw----  1 root root 253,    20 Sep 23 22:29 dm-20
brw-rw----  1 root root 253,    21 Sep 23 22:29 dm-21
brw-rw----  1 root root 253,    22 Sep 23 22:29 dm-22
brw-rw----  1 root root 253,    23 Sep 23 22:29 dm-23
brw-rw----  1 root root 253,    24 Sep 23 22:29 dm-24
brw-rw----  1 root root 253,    25 Sep 23 22:29 dm-25
brw-rw----  1 root root 253,    26 Sep 23 22:29 dm-26
brw-rw----  1 root root 253,    27 Sep 23 22:29 dm-27
brw-rw----  1 root root 253,    28 Sep 23 22:29 dm-28
brw-rw----  1 root root 253,    29 Sep 23 22:29 dm-29
brw-rw----  1 root root 253,     3 Sep 23 22:29 dm-3
brw-rw----  1 root root 253,    30 Sep 23 22:29 dm-30
brw-rw----  1 root root 253,    31 Sep 23 22:29 dm-31
brw-rw----  1 root root 253,    32 Sep 23 22:29 dm-32
brw-rw----  1 root root 253,    33 Sep 23 22:29 dm-33
brw-rw----  1 root root 253,     4 Sep 23 22:29 dm-4
brw-rw----  1 root root 253,     5 Sep 23 22:29 dm-5
brw-rw----  1 root root 253,     6 Sep 23 22:29 dm-6
brw-rw----  1 root root 253,     7 Sep 23 22:29 dm-7
brw-rw----  1 root root 253,     8 Sep 23 22:29 dm-8
brw-rw----  1 root root 253,     9 Sep 23 22:29 dm-9

Thx