OraFAQ Forum: Server Administration » Rename datafile in Production when using Physical Standby

Home » RDBMS Server » Server Administration » Rename datafile in Production when using Physical Standby (oracle 10.2.0.1.0,Redhat Linux 4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Rename datafile in Production when using Physical Standby [message #437116]

Thu, 31 December 2009 02:33

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

Michel Cadot
Messages: 68658
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

Michel Cadot
Messages: 68658
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 02 11:09:26 CDT 2024