Home » RDBMS Server » Backup & Recovery » replace database (10G,Windows 2003)
replace database [message #430858] Thu, 12 November 2009 10:38 Go to next message
mamingui
Messages: 83
Registered: July 2006
Member
Hi All

I want to know if there is another method to replace database from one folder to another folder.
I have to replace my database which is in my C:/ drive to a SAN Space.
This Database is currently use by an application.
How to do that correctly. Please give me a step by step procedure to do that.

Thanks in advance
Re: replace database [message #430860 is a reply to message #430858] Thu, 12 November 2009 10:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You have to do it in mount and not open state.
Then use ALTER DATABASE RENAME FILE statement for each file.

Regards
Michel
Re: replace database [message #430861 is a reply to message #430860] Thu, 12 November 2009 11:02 Go to previous messageGo to next message
mamingui
Messages: 83
Registered: July 2006
Member
Ok Thanks

"alter database rename file" after copying files from C:\ to SAN directory, right ?

Thanks again
Re: replace database [message #430864 is a reply to message #430861] Thu, 12 November 2009 11:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Right!
(Actually it does not matter you do it before or after, the important point is that you do it after shutdown and before full startup (before open).)

Regards
Michel

[Updated on: Thu, 12 November 2009 11:34]

Report message to a moderator

Re: replace database [message #430866 is a reply to message #430864] Thu, 12 November 2009 12:03 Go to previous message
mamingui
Messages: 83
Registered: July 2006
Member
Thanks Guy
Previous Topic: Rman backup piece size in oracle 9i
Next Topic: Oracle Backup Views
Goto Forum:
  


Current Time: Fri Nov 22 01:27:08 CST 2024