Home » Server Options » Data Guard » Changing dbname,sid,data/control file locations (10g)
Changing dbname,sid,data/control file locations [message #481699] Fri, 05 November 2010 06:05 Go to next message
Messages: 19
Registered: November 2010
Location: abc
Junior Member
I want to change dbname,sid,data/control file locations in operational dataguard setup i plan to follow as below
1)shutdown primary and standby (stop managed recovery)
2)change db name in init.ora of primary and standby change database name control file location
3)create control file for primary from trace(script) make changes for db name and file locations
4)mount and open primary database
5)create standby control file
6) transfer standby control file to standby
7) mount stand by database and start manage recovery

Let me know if this steps will error free do i need to follow any thing additional to this or what is other best way for this or its not possible at all

Re: Changing dbname,sid,data/control file locations [message #482593 is a reply to message #481699] Sat, 13 November 2010 08:47 Go to previous message
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

I don't think any other steps require here.

PS: Make sure before doing any changes you should have valid backup Smile

Previous Topic: dataguard best practise
Next Topic: Unable to create physical standby database using RMAN
Goto Forum:

Current Time: Sat Dec 10 00:23:05 CST 2022