Dbvisit Community Dbvisit home       

Go Back   Dbvisit Community > Dbvisit Standby - Technical > Dbvisit Standby - with RAC

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 05-20-2011, 09:18 PM
neeraj19 neeraj19 is offline
Junior Member
 
Join Date: May 2011
Posts: 2
Default how to add datafile on rac

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
Reply With Quote
  #2  
Old 05-20-2011, 10:03 PM
Arjen Visser Arjen Visser is offline
Dbvisit Team
 
Join Date: Jan 2008
Location: Auckland, New Zealand
Posts: 380
Default

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,
Reply With Quote
  #3  
Old 05-24-2011, 09:15 PM
neeraj19 neeraj19 is offline
Junior Member
 
Join Date: May 2011
Posts: 2
Default

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.
Reply With Quote
  #4  
Old 05-24-2011, 09:31 PM
Arjen Visser Arjen Visser is offline
Dbvisit Team
 
Join Date: Jan 2008
Location: Auckland, New Zealand
Posts: 380
Default

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,
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT +12. The time now is 04:26 AM.