OraFAQ Forum: Data Guard » Renaming DBName and Instance Name

Home » Server Options » Data Guard » Renaming DBName and Instance Name (Oracle 10g - sun solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Renaming DBName and Instance Name [message #465312]

Tue, 13 July 2010 09:38

prashanthgs
Messages: 89
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

Report message to a moderator

Re: Renaming DBName and Instance Name [message #465315 is a reply to message #465312]

Tue, 13 July 2010 10:15

John Watson
Messages: 8966
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.

Report message to a moderator

Re: Renaming DBName and Instance Name [message #465316 is a reply to message #465312]

Tue, 13 July 2010 10:18

babuknb
Messages: 1736
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 02:24:20 CDT 2025