Adding datafile to tablespace on ASM in RAC Environment

The following example shows how to add a datafile to the NBLT24DATA tablespace in the +DATA ASM group.

1. Find out where the current datafiles are defined. In this example the ASM group is +DATA.

SQL> select file_name,bytes/1024/1024/1024 GB from dba_data_files where tablespace_name = 'NBLT24DATA' order by file_name;

2. Add the datafile on ASM.

SQL> alter tablespace NBLT24DATA add datafile '+DATA' size 30G;

Tablespace altered.