RE: db_unique_name
Date: Tue, 24 May 2011 15:20:36 -0400
Message-ID: <6B0D50B70F12BD41B5A67F14F5AA887F10DE7DF4_at_us-bos-mx022.na.pxl.int>
Not really needed. The DB_UNIQUE_NAME I believe only gets involved in DG and RAC. Nothing to say you can't be a touch more creative. Actually I do something of the sorts. DB_UNIQUE_NAME = DBNAME.SITE.COUNTRY. SO you could have FOX.NEWYORK.US and FOX.LONDON.UK. Richard Goulet
Senior Oracle DBA/Na Team Leader
From: K R [mailto:kp0773_at_gmail.com]
Sent: Tuesday, May 24, 2011 3:17 PM
To: Goulet, Richard
Cc: Oracle-L_at_freelists.org
Subject: Re: db_unique_name
thanks Richard,
by the way if ever we start to failover the standby database then should we be able to change the db_unique_name to be same as db_name ( as at that point the old primary database is no more in the dataguard configuration )
On Tue, May 24, 2011 at 12:02 PM, Goulet, Richard <Richard.Goulet_at_parexel.com> wrote:
DB_UNIQUE_NAME must be different between the primart and standby as follows:
Primary
Db_name=fox
Db_unique_name =foxp
Standby
Db_name=fox
Db_unique_name=foxs
Rather simplistic, but I think you'll catch on.
Richard Goulet
Senior Oracle DBA/Na Team Leader
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of K R
Sent: Tuesday, May 24, 2011 2:47 PM
To: Oracle-L_at_freelists.org
Subject: db_unique_name
All,
I have the primary db on server A , and planning to make the standby on server B. Can I have the db_unique_name same same as db_name in standby database.?
appreicate any suggestion.
thanks
Kart
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 24 2011 - 14:20:36 CDT