OraFAQ Forum: Server Administration » Move datafile from One location to another

Home » RDBMS Server » Server Administration » Move datafile from One location to another (Oracle 10g, AIX)

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

Move datafile from One location to another [message #388178]

Mon, 23 February 2009 12:23

prashanthgs
Messages: 89
Registered: May 2005
Location: chennai

Member

Hi,

I want to move a datafile from one Location to another location.

Its in Dataguard setup, with ARCHIVLOG mode. I want to do this in Primay db without shutting down the db. Pls tell me if below steps work

a. ALTER DATABASE DATAFILE (OLD LOCATION) OFFLINE
b. Move file to new location
c. ALTER DATABASE RENAME FILE FROM OLD LOCATION TO NEW LOCATION
d. RECOVER DATAFILE (NEW LOCATION)
c. ALTER DATABASE DATAFILE NEW LOCATION ONLINE

Thanks

Report message to a moderator

Re: Move datafile from One location to another [message #388180 is a reply to message #388178]

Mon, 23 February 2009 12:37

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

1/ I think it's should be work.

2/ Confirm me; In Standby database STANDBY_FILE_MANAGEMENT is Auto or Manual??

Report message to a moderator

Re: Move datafile from One location to another [message #388184 is a reply to message #388180]

Mon, 23 February 2009 12:51

prashanthgs
Messages: 89
Registered: May 2005
Location: chennai

Member

Thanks babu.

Its AUTO only.

Report message to a moderator

Re: Move datafile from One location to another [message #388192 is a reply to message #388184]

Mon, 23 February 2009 14:39

prashanthgs
Messages: 89
Registered: May 2005
Location: chennai

Member

Hi

I moved the datafile from one location to another location in Primary db successfully.

But I expected the same change to be happened in Standby automatically. But It didnt happened.

How I can accomplish this.

Thanks
Prashanth

Report message to a moderator

Re: Move datafile from One location to another [message #388221 is a reply to message #388192]

Mon, 23 February 2009 22:33

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>>Its AUTO only
>>But I expected the same change to be happened in Standby automatically

Thanks; Standby automatically take care datafile location because your STANDBY_FILE_MANAGEMENT.

Can you explain; what exactly your expecting from standby database?

Report message to a moderator

Re: Move datafile from One location to another [message #388646 is a reply to message #388221]

Wed, 25 February 2009 15:58

prashanthgs
Messages: 89
Registered: May 2005
Location: chennai

Member

It didnt took automatically moving the files in Standby databse once I moved in Primary.

So Do I want to do these steps again manually in Standby db. If so can I follow the same steps which did for PRIMARY db.

Report message to a moderator

Re: Move datafile from One location to another [message #388676 is a reply to message #388192]

Wed, 25 February 2009 22:25

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

When you rename one or more datafiles in the primary database, the change is not propagated to the standby database. Therefore, if you want to rename the same datafiles on the standby database, you must manually make the equivalent modifications on the standby database because the modifications are not performed automatically, even if the STANDBY_FILE_MANAGEMENT initialization parameter is set to AUTO.

The following steps describe how to rename a datafile in the primary database and manually propagate the changes to the standby database.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/manage_ps.htm#i1035175

PS: Please don't start new thread; Try to open in new thread under "Data Guard"

[Updated on: Thu, 26 February 2009 07:13]

Report message to a moderator

Previous Topic:	adding extra hard drive to my server
Next Topic:	Segment Space Managemrnt

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 20:34:51 CST 2024