| Changing dbname,sid,data/control file locations [message #481699] |
Fri, 05 November 2010 06:05  |
dbaoracleinin
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
thanks
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
