Home » RDBMS Server » Server Administration » Addition of datafile (merged 3) (oracle 10g/Redhat Linux 4)
Addition of datafile (merged 3) [message #422215] Tue, 15 September 2009 02:32 Go to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
i added a datafile to produsction today.

ALTER TABLESPACE "PARTS" ADD DATAFILE '/u03/oradata/cdb/parts02' SIZE 2000M AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED


this was my queary. i missed .dbf instead of parts02.dbf

how to include externtion to data file, i have physical standby database, what is the effect of standby

urgent pls. Embarassed
Re: Addition of datafile [message #422228 is a reply to message #422215] Tue, 15 September 2009 03:13 Go to previous messageGo to next message
ThomasG
Messages: 3184
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
It's all in the very fine documentation.
Re: Addition of datafile [message #422248 is a reply to message #422228] Tue, 15 September 2009 04:44 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
Thanks for replying, but there is no notes for missing .dbf

please let me know exact queary.

it may be like
alter tablespace PARTS offline narmal;

alter tablespace PARTS rename datafile
'/u03/oradata/cdb/parts02' to '/u03/oradata/cdb/parts02.dbf';

alter tablespace PARTS online;
Re: Addition of datafile [message #422251 is a reply to message #422248] Tue, 15 September 2009 04:48 Go to previous messageGo to next message
Michel Cadot
Messages: 63804
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
but there is no notes for missing .dbf

Oracle does not care about "extension", it is just characters in the name.

Regards
Michel
Re: Addition of datafile [message #422254 is a reply to message #422251] Tue, 15 September 2009 04:52 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
thanks Mr.Michel

anyway for uniformation of datafile as otherfile

could i rename as i said previous post?

is it exact queaty for that???

but this is production mind please.
Re: Addition of datafile [message #422255 is a reply to message #422254] Tue, 15 September 2009 05:00 Go to previous messageGo to next message
ThomasG
Messages: 3184
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
The "exact query" is the four steps in the link under "Renaming Datafiles in a Single Tablespace"

But you have to do Step 2 also. Rename the datafile on the file system.
Re: Addition of datafile [message #422259 is a reply to message #422255] Tue, 15 September 2009 05:28 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
what is impact to standby database, i have physical standby database, standby_file_management=auto.
Re: Addition of datafile [message #422264 is a reply to message #422259] Tue, 15 September 2009 05:36 Go to previous message
ThomasG
Messages: 3184
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
That is also in the very fine documentation.
Previous Topic: Oracle Jobs are Not Running
Next Topic: problem bringing ASM instance up
Goto Forum:
  


Current Time: Mon Sep 26 11:11:27 CDT 2016

Total time taken to generate the page: 0.16224 seconds