Adding new file to ASM

Problem and symptoms:

Curent Setup Info

Sql*Plus

AsmCMD

Add file using dd

Add disk to diskgroup

Resize Database Datafile

Set Compatible ASM Attribute

Note

Info: on existing RAC configuration we have to add new file. Asm files ware almost full.

Problem and symptoms:

In db alert log there are messages like ORA-1653: unable to extend table SYSMAN.MGMT_STRING_METRIC_HISTORY by 128 in tablespace SYSAUX

From the ex. EM console there are warning sucs as: rac2.localdomainHostFilesystemsFilesystem Space Available (%) - Filesystem / has 11% available space, fallen below warning (20) or critical (5) threshold.05-Jun-2010 15:31:16

Curent Setup Info

Sql*Plus

[oracle@rac1.localdomain] # echo $ORACLE_SID

RAC1

[oracle@rac1.localdomain] # echo $ORACLE_HOME

/u01/app/oracle/product/11.2.0/db_1

[oracle@rac1.localdomain] # sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri May 27 16:12:08 2011

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL> select name,path,REDUNDANCY, TOTAL_MB, os_mb, free_mb from V$ASM_DISK

NAME PATH REDUNDA TOTAL_MB OS_MB FREE_MB

------------------------------ ---------------------------------------- ------- ---------- ---------- ----------

TEST_0000 /home/oracle/u01/oradata/nfsdisk1 UNKNOWN 781 781 1

TEST_0001 /home/oracle/u01/oradata/nfsdisk2 UNKNOWN 781 781 0

TEST_0002 /home/oracle/u01/oradata/nfsdisk3 UNKNOWN 781 781 3

AsmCMD

[oracle@rac1.localdomain] # echo $ORACLE_HOME

/u01/app/11.2.0/grid

[oracle@rac1.localdomain] # echo $ORACLE_SID

+ASM1

[oracle@rac1.localdomain] # asmcmd

ASMCMD> lsdsk -k

Total_MB Free_MB OS_MB Name Failgroup Library Label UDID Product Redund Path

781 177 781 TEST_0000 TEST_0000 System UNKNOWN /home/oracle/u01/oradata/nfsdisk1

781 176 781 TEST_0001 TEST_0001 System UNKNOWN /home/oracle/u01/oradata/nfsdisk2

781 177 781 TEST_0002 TEST_0002 System UNKNOWN /home/oracle/u01/oradata/nfsdisk3

Add file using dd

From RAC1

dd if=/dev/zero of=/home/oracle/u01/oradata/nfsdisk4 bs=1k count=819200

ls -all /home/oracle/u01/oradata

total 3222376

drwxr-xr-x 2 oracle oinstall 4096 May 26 00:50 .

drwxr-xr-x 6 root oinstall 4096 Jun 3 2010 ..

-rw-r--r-- 1 oracle oinstall 819200000 May 26 01:12 nfsdisk1

-rw-r--r-- 1 oracle oinstall 819200000 May 26 01:12 nfsdisk2

-rw-r--r-- 1 oracle oinstall 819200000 May 26 01:12 nfsdisk3

-rw-r--r-- 1 oracle oinstall 838860800 May 26 01:12 nfsdisk4

Add disk to diskgroup

[oracle@rac1.localdomain] # sqlplus / as sysasm

SQL> ALTER DISKGROUP TEST ADD DISK '/home/oracle/u01/oradata/nfsdisk4';

SQL> select name,path,REDUNDANCY, TOTAL_MB, os_mb, free_mb from V$ASM_DISK

NAME PATH REDUNDA TOTAL_MB OS_MB FREE_MB

------------------------------ --------------------------------------------- ------- ---------- ---------- ----------

TEST_0000 /home/oracle/u01/oradata/nfsdisk1 UNKNOWN 781 781 174

TEST_0001 /home/oracle/u01/oradata/nfsdisk2 UNKNOWN 781 781 175

TEST_0002 /home/oracle/u01/oradata/nfsdisk3 UNKNOWN 781 781 174

TEST_0003 /home/oracle/u01/oradata/nfsdisk4 UNKNOWN 800 800 199

Resize Database Datafile

ALTER DATABASE DATAFILE '+TEST/rac/datafile/system.256.720889819' RESIZE 770M

ALTER DATABASE DATAFILE '+TEST/rac/datafile/system.256.720889819' AUTOEXTEND ON NEXT 10M

SQL> select INSTANCE_NUMBER,INSTANCE_NAME,VERSION,DATABASE_STATUS from v$instance;

INSTANCE_NUMBER INSTANCE_NAME VERSION DATABASE_STATUS

--------------- ---------------- ----------------- -----------------

1 +ASM1 11.2.0.1.0 ACTIVE

Set Compatible ASM Attribute

ASQL> ALTER DISKGROUP TEST SET ATTRIBUTE 'compatible.asm' = '11.2';

Diskgroup altered.

SQL> ALTER DISKGROUP TEST SET ATTRIBUTE 'compatible.rdbms' = '11.2';

Diskgroup altered.

Note

Installation was done using method simmilar to: http://www.oracle-base.com/articles/11g/OracleDB11gR2RACInstallationOnLinuxUsingNFS.php