Storage addition (ASM DISK )

 Storage addition

Below are newlu added disks

[root@xxxx3807 ~]# perl /home/lg023534/dkdisk.pl | grep -i unknown
sdba  [3:0:8:0]   UNKNOWN                      unknown    36000c297354fc7a27badcfa62d3de4f6   500     536870912000
sdi   [0:0:9:0]   UNKNOWN                      unknown    36000c2977c7d9e97508ce14dc5f66c01   500     536870912000
sdm   [0:0:13:0]  UNKNOWN                      unknown    36000c290c36034e381e34a1d9e12de70   16      17179869184
sdn   [0:0:14:0]  UNKNOWN                      unknown    36000c29f83ab2331b9c36365e5b41984   16      17179869184
sdo   [0:0:15:0]  UNKNOWN                      unknown    36000c29c7ccbad46c675c620a02ed1a5   16      17179869184
[root@xxxx3807 ~]# ls -ltr /dev/sdba*
brw-r----- 1 root disk 67, 64 Jun 21 04:26 /dev/sdba
brw-r----- 1 root disk 67, 65 Jun 22 07:35 /dev/sdba1
[root@xxxx3807 ~]# ls -ltr /dev/sdi*
brw-r----- 1 root disk 8, 128 Jun 21 04:26 /dev/sdi
[root@xxxx3807 ~]# /sbin/parted -s /dev/sdi mklabel msdos unit s mkpart primary '500 -1'
[root@xxxx3807 ~]# ls -ltr /dev/sdi*
brw-r----- 1 root disk 8, 128 Jun 22 07:58 /dev/sdi
brw-r----- 1 root disk 8, 129 Jun 22 07:58 /dev/sdi1
[root@xxxx3807 ~]# oracleasm listdisks |grep -i orpogpc1
ORPOGPC1_DATA001
ORPOGPC1_DATA002
ORPOGPC1_DATA003
ORPOGPC1_DATA004
ORPOGPC1_DATA005
ORPOGPC1_DATA006
ORPOGPC1_DATA007
[root@xxxx3807 ~]# oracleasm createdisk ORPOGPC1_DATA008 /dev/sdba1
Writing disk header: done
Instantiating disk: done
[root@xxxx3807 ~]# oracleasm listdisks |grep -i orpogpc1
ORPOGPC1_DATA001
ORPOGPC1_DATA002
ORPOGPC1_DATA003
ORPOGPC1_DATA004
ORPOGPC1_DATA005
ORPOGPC1_DATA006
ORPOGPC1_DATA007
ORPOGPC1_DATA008
[root@xxxx3807 ~]# oracleasm createdisk ORPOGPC1_DATA009 /dev/sdi1
Writing disk header: done
Instantiating disk: done
[root@xxxx3807 ~]#
[root@xxxx3807 ~]# oracleasm listdisks |grep -i orpogpc1
ORPOGPC1_DATA001
ORPOGPC1_DATA002
ORPOGPC1_DATA003
ORPOGPC1_DATA004
ORPOGPC1_DATA005
ORPOGPC1_DATA006
ORPOGPC1_DATA007
ORPOGPC1_DATA008
ORPOGPC1_DATA009
[root@xxxx3807 ~]# perl /home/lg023534/dkdisk.pl | grep -i unknown
sdm   [0:0:13:0]  UNKNOWN                      unknown    36000c290c36034e381e34a1d9e12de70   16      17179869184
sdn   [0:0:14:0]  UNKNOWN                      unknown    36000c29f83ab2331b9c36365e5b41984   16      17179869184
sdo   [0:0:15:0]  UNKNOWN                      unknown    36000c29c7ccbad46c675c620a02ed1a5   16      17179869184
[root@xxxx3807 ~]# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
[root@xxxx3807 ~]#
[root@xxxx3807 ~]#
[root@xxxx3807 ~]# su - grid
[grid@xxxx3807 ~]$ . ./gridasm.env
[grid@xxxx3807 ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Mon Jun 22 08:09:39 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> select distinct (NAME) "DISKGROUP",TOTAL_MB/1024 "Total Size in GB",FREE_MB/1024 "Free Space in GB" ,FREE_MB/TOTAL_MB*100 "Pct Free" from gv$ASM_DISKGROUP where NAME = 'ORPOGPC1_DATA';

DISKGROUP                      Total Size in GB Free Space in GB   Pct Free
------------------------------ ---------------- ---------------- ----------
ORPOGPC1_DATA                        3499.99316       3499.86133 99.9962333

To add diskgroup to Datamount

SQL> alter diskgroup ORPOGPC1_DATA add disk 'ORCL:ORPOGPC1_DATA008';

Diskgroup altered.