000028212 - KB-1092 - Adding Disks to the Oracle ASM Disk Group

Document created by RSA Customer Support Employee on Jun 14, 2016•Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • Comment • 0
  • View in full screen mode

Article Content

Article Number000028212
Applies ToAffected Versions: All Versions
ResolutionIf you are in a situation where you need to add more disk space for the database, the best approach is to add additional disks to Oracle ASM disk group. Aveksa uses Oracle ASM to provide a large virtual disk for the database. We use one disk group named DG01. Normally, there is only one disk VOL1, but additional disks can be added.

The disks should be configured as standard Linux partitions. In this example, the two partitions that we want to add are:
  • /dev/sdb2
  • /dev/sda3

Note: this assumes that the disk partitions have already been created via pvcreate / fdisk.
1. Configure the partitions as ASM volumes by formatting them and marking them as ASM disks
Do this as the root user.
# dd if=/dev/zero of=/dev/sdb2 bs=8192 count=12800

# service oracleasm createdisk VOL2 /dev/sdb2

# dd if=/dev/zero of=/dev/sda3 bs=8192 count=12800

# service oracleasm createdisk VOL3 /dev/sda3
2. Add the new disks to the existing ASM to the disk group (do this as the RedHat Linux oracle user):


 


Note that the environment commands and the sqlplus user are different depending on if Oracle 10g or 11g is being used. The actual alter command is the same regardless of version.


 


For Oracle 10g:


 


$ export ORACLE_SID=+ASM

$ sqlplus "/ as sysdba"


 


For Oracle 11g:


 


$ export ORACLE_HOME=$ORACLE_GRID_HOME


$ export PATH=$ORACLE_GRID_HOME/bin:$PATH


 


$ export ORACLE_SID=+ASM


$ export ORACLE_HOME=$ORACLE_GRID_HOME


$ export PATH=$ORACLE_GRID_HOME/.bin:$PATH

$ sqlplus "/ as sysasm"


 


 


To add the new disk devices to the existing ASM diskgroup:



SQL> ALTER DISKGROUP DG01 ADD DISK 'ORCL:VOL2' NAME VOL2, 'ORCL:VOL3' NAME VOL3;

SQL> quit;
See the oracle documentation at: http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/storeman.htm for additional information

Attachments

    Outcomes