Home » RDBMS Server » Server Administration » Move datafile from One location to another (Oracle 10g, AIX)
Move datafile from One location to another [message #388178] Mon, 23 February 2009 12:23 Go to next message
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


Re: Move datafile from One location to another [message #388180 is a reply to message #388178] Mon, 23 February 2009 12:37 Go to previous messageGo to next message
babuknb
Messages: 1734
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??

Re: Move datafile from One location to another [message #388184 is a reply to message #388180] Mon, 23 February 2009 12:51 Go to previous messageGo to next message
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
Member
Thanks babu.

Its AUTO only.
Re: Move datafile from One location to another [message #388192 is a reply to message #388184] Mon, 23 February 2009 14:39 Go to previous messageGo to next message
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

Re: Move datafile from One location to another [message #388221 is a reply to message #388192] Mon, 23 February 2009 22:33 Go to previous messageGo to next message
babuknb
Messages: 1734
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?
Re: Move datafile from One location to another [message #388646 is a reply to message #388221] Wed, 25 February 2009 15:58 Go to previous messageGo to next message
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.



Re: Move datafile from One location to another [message #388676 is a reply to message #388192] Wed, 25 February 2009 22:25 Go to previous message
babuknb
Messages: 1734
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:
  


Current Time: Thu Dec 08 12:24:29 CST 2016

Total time taken to generate the page: 0.10956 seconds