Home » RDBMS Server » Server Administration » Rename datafile in Production when using Physical Standby (oracle 10.2.0.1.0,Redhat Linux 4)
Rename datafile in Production when using Physical Standby [message #437116] Thu, 31 December 2009 02:33 Go to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
Dear All,

i Added one datafile for the tablespace parts, data file name /u01/oradata/prod/parts2 (without giving .dbf)

it automatically added to standby database
/u01/oradata/prod/parts2, but all the datafiles are in the folder called
/u01/oradata/stdb/*.dbf

if i want to rename the datafile /u01/oradata/prod/parts2 to /u01/oaradata/prod/parts2.dbf as well need to rename in standby accordingly

please give me procedure.

[Updated on: Thu, 31 December 2009 02:34] by Moderator

Report message to a moderator

Re: Rename datafile in Production when using Physical Standby [message #437117 is a reply to message #437116] Thu, 31 December 2009 02:36 Go to previous messageGo to next message
Michel Cadot
Messages: 63808
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ALTER DATABASE as an option to rename a file but you have to know that Oracle (RDBMS) does not care of the file name and even does not know what an extension is.

By the way, do NOT use code tags for your question, use it for code or anything that needs to be aligned (like result table).

Regards
Michel

[Updated on: Thu, 31 December 2009 02:37]

Report message to a moderator

Re: Rename datafile in Production when using Physical Standby [message #437119 is a reply to message #437116] Thu, 31 December 2009 02:40 Go to previous message
Michel Cadot
Messages: 63808
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The procedure to rename a file with a standby database is described in:
Data Guard Concepts and Administration
Chapter 8 Managing a Physical Standby Database
Section 8.3.4 Renaming a Datafile in the Primary Database

Regards
Michel
Previous Topic: Moving subsets of data between servers
Next Topic: how to use a DB from another Oracle System
Goto Forum:
  


Current Time: Wed Sep 28 15:58:58 CDT 2016

Total time taken to generate the page: 0.07998 seconds