Home » Server Options » Data Guard » Renaming DBName and Instance Name (Oracle 10g - sun solaris)
Renaming DBName and Instance Name [message #465312] Tue, 13 July 2010 09:38 Go to next message
Messages: 89
Registered: May 2005
Location: chennai

We are planning to change the dbname from appr to apdr. Its a DR (Standby Database). Please clarify our below queries

a. NID option will work for this? - DB in mount state (Standby db)

b. Is that possible to change the Instance name also?

c. Any Prerequsities and postrequirments for this change? (ie,Data Broker, communication with Primary and Standby etc?

If any good documents available for this please provide the link.

Oracle 10g, OS - Sun Solaris

Re: Renaming DBName and Instance Name [message #465315 is a reply to message #465312] Tue, 13 July 2010 10:15 Go to previous messageGo to next message
John Watson
Messages: 8560
Registered: January 2010
Location: Global Village
Senior Member
It is a physical standby, right? In that case, you can't change the db_name. You could change the db_unique_name, I suppose.
Re: Renaming DBName and Instance Name [message #465316 is a reply to message #465312] Tue, 13 July 2010 10:18 Go to previous message
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

1. I don't think so database name changes in standby

2. No

3. You may have to check


[Updated on: Tue, 13 July 2010 10:18]

Report message to a moderator

Previous Topic: difference between standby and dataguard
Next Topic: standby on same server
Goto Forum:

Current Time: Sat Jun 19 18:48:23 CDT 2021