Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Primary DB's DB_UNIQUE_NAME

MaxJul 8 2013 — edited Jul 8 2013

DB version: 11.2.0.3

Platform : RHEL 5.8

Standby Type: Physical Standby

All the primary DBs in our shop have its DB_UNIQUE_NAME set as same as DB_NAME.

-- In primary

SQL> select name, db_unique_name from v$database;

NAME DB_UNIQUE_NAME

--------- ------------------------------

GCLRPMS GCLRPMS

As you can see in the below article by Bhavin Hingu, where he names the primary's DB_UNIQUE_NAME to be different than DB_NAME .

http://www.oracledba.org/11gR2/dr/11gR2_dataguard_RAC_to_RAC.html

DB_NAME= BHAVIN

DB_UNIQUE_NAME= USA

Is this recommended ? Do you think it is good for role reversals ?

This post has been answered by mseberg on Jul 8 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 5 2013

Added on Jul 8 2013

#data-guard, #performance-availability

2 comments

590 views