Skip to Main Content

Oracle Database Discussions

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!

Changing the DB_UNIQUE_NAME Initialization Parameter for

happy10319Mar 2 2019 — edited Mar 2 2019

Hi,

I'm reading :Data GuardConcepts and Administration

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sbydb/data-guard-concepts-and-administration.pdf

In which I see:

For example, perform the following steps tochange the database with DB_UNIQUE_NAME of BOSTON_A to BOSTON_B:

1.In the initialization parameter file or SQL, change the DB_UNIQUE_NAMEinitialization parameter from BOSTON_A to BOSTON_B.

2.In RMAN, connect to any database in the Oracle Data Guard environment astarget database and connect to the recovery catalog. Then execute the CHANGEcommand:CHANGE DB_UNIQUE_NAME FROM BOSTON_A TO BOSTON_B;

My qustions:

-How to change it using SQL? Alter system set DB_UNIQUE_NAME=BOSTON_B ?

-After changing parameter in initialization parameter file should we restart databse?

Thanks.

This post has been answered by John Thorton on Mar 2 2019
Jump to Answer
Comments
Post Details
Added on Mar 2 2019
2 comments
4,914 views