I have a doubt about a question that has made me a customer and hope that if you can you solve me,
It's about the db_name and db_unique_name.
The question is this, in a Data Guard (11gR2), the db_name is the same for all databases, and what changes is the db_unique_name, so far so clear.
It may be that in a physical standby and a standby primary, the primary parameter db_unique_name db_name is different than, let me explain:
db_name = BDRP
db_unique_name = bdrpo3
db_name = BDRP
db_unique_name = bdrpo4
In all the notes and manuals on the primary meeting these two parameters are equal and these parameters change in standby. May be different in the Primary like in the standby, or on the contrary there is a restriction.
Is there a note explaining this very thing.
thank you very much
Not sure I understand your question. On Oracle 11 each database's DB_UNIQUE_NAME must be different or the databases will not communicate.
You can check the V$DATABASE view to get the DB_UNIQUE_NAME.
Data Guard Concepts and Administration is a great source of information on this:
It has unique value on the primary database and on each standby database(s).
So on the Primary it can be different that the DB_NAME as long as its unique.
Also of interest:
Unable To Start Oracle Restart Db using 12c if db_unique_name and db_name are different [ID 1479564.1]
11.2 Data Guard Physical Standby Switchover Best Practices using the Broker [ID 1305019.1]