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
prashanthgs
Messages: 83
Registered: May 2005
Location: chennai
Member
Hi,

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

Regards,
Prasanth
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: 4611
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
babuknb
Messages: 1731
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

http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/toc.htm
Babu

[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: Thu Oct 02 09:46:42 CDT 2014

Total time taken to generate the page: 0.15513 seconds