News

  1. Home
  2. All posts
All posts, Oracle, RAC by Team Ajara

How to add new disks in ASM Diskgroup

Adding new Disks in ASM DiskGroup

 

Get the LUN #/ name from the Unix/storage team,and follow the below steps.

Step 1 :List the mapper details

# cd /dev/mapper/
# ls -1 /dev/mapper/mpathx
1rwxrwxrwx 1 root root 9 Jul 15 03:07 /dev/mapper/mpathx -> ../dm-145
#

Step 2 :Createdisk

# . oraenv
ORACLE SID = [+ASM] ?
# oracleasm createdisk DATA_0119 /dev/mapper/mpathx
Writing disk header: done Instantiating disk: done
#

Step 3 : add disk in the Oracle Level

SQL> alter diskgroup ORA_DATA03 add disk /dev/oracleasm/disks/DATA_0119 name ORA_DATA03_0003 size 100G rebalance power 5; Diskgroup altered.
Elapsed: 00:00:00.70

Step 4: Check rebalance activity

SQL>Select * From v$asm_operation;

GROUP NUMBER OPERA PASS STAT POWER ACTUAL SOFAR “EST_WORK” “EST RATE” “EST MINUTES” ERROR_CODE CON_ID
14 REBAL COMPACT WAIT 5 5 0 0 0 0 0
14 REBAL REBALANCE RUN 5 5 55258 92768 12648 2 0
14 REBAL REBUILD DONE 5 5 0 0 0 0
Elapsed: 00:00:00.00
SQL>

Step 5:Alert log file content verification

NOTE: Starting expel slave for group 14/0xc6a1b85b (ORA_DATA03) 2023-07-18T10:46:41.832645-04:00
NOTE: membership refresh pending for group 14/0xc6a1b85b (ORA_DATA03)
2023-07-18T10:46:41.837733-04:00
GMON querying group 14 at 9574 for pid 19, osid 113650 2023-07-18T10:46:41.860631-04:00
SUCCESS: refreshed membership for 14/0xc6a1b85b (ORA_DATA03) 2023-07-18T10:46:44.848656-04:00
NOTE: Attempting voting file refresh on diskgroup ORA_DATA03
2023-07-18T10:51:44.866273-04:00
NOTE: stopping process ARBO NOTE: stopping process ARBA
2023-07-18T10:51:44.980119-04:00
SUCCESS: rebalance completed for group 14/0xc6a1b85b (ORA_DATA03)

Step 6 : Adding Disk in RAC environment

Creating new disk from node1 (Node1 for production) as root

/usr/sbin/oracleasm createdisk DATA14 /dev/emcpowera1
/usr/sbin/oracleasm scandisks -v /dev/emcpowera1
/usr/sbin/oracleasm listdisks
/usr/sbin/oracleasm querydisk -d DATA14

Discover the new disk from node2 (Node2 for production) as root

/usr/sbin/oracleasm scandisks -v /dev/emcpowerb1
/usr/sbin/oracleasm listdisks
/usr/sbin/oracleasm querydisk -d DATA14

If there is any permission issue with above steps

/usr/sbin/asmtool -C -I /dev/oracleasm/ -n DATA14 -s /dev/emcpowera1 -a force=yes
cd /dev/oracleasm/disks
chown oracle:dba DATA14

 

See also