how to add datafile on rac

[neeraj19]

hi,
i m using oracle 10g rac on aix . i want to add one datafile to my existing tablespace . i want system generated datafile name so what should be my syntax.

reagrds

[Arjen Visser]

Hello,
Please set the following on your standby database:
SQL> alter system set STANDBY_FILE_MANAGEMENT = auto;

When a new datafile is added to the primary database, it will now be automatically added to the standby database using a system generated name (or OMF).

Kind regards,

[neeraj19]

thxs frd but i m not working on stand by server , i m just want to create an another datafile in my existing tablespace with system generated name. so what step i need to follow. i m using oracle 10g rac.

[Arjen Visser]

Hi,
To add a OMF datafile you have to make sure the DB_CREATE_FILE_DEST is set:
SQL> ALTER SYSTEM SET DB_CREATE_FILE_DEST='/app/oracle/oradata/db';

Then you can add the datafile to the tablespace:
SQL> ALTER TABLESPACE my_tbs ADD DATAFILE SIZE 500M;

Regards,