PDA

View Full Version : how to add datafile on rac


neeraj19
05-20-2011, 09:18 PM
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
05-20-2011, 10:03 PM
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
05-24-2011, 09:15 PM
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
05-24-2011, 09:31 PM
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,