Changing Database Name With Standby Database In Place Using NID Utility (Doc ID 790406.1)

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.0 [Release 9.2 to 11.2]
Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.2 [Release 11.2 to 12.1]
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 18-Sep-2013***

 

 

NID utility can be used to change the name of the database.

The option setname=y needs to be used to change the db name alone not touching the DBID.
Once the name of the database is changed the standby controlfile needs to be re-created to reflect the new name of the primary database.
After the standby controlfile is re-created the media recovery can be enabled.

The goal of the document is to summarize the steps to be performed to change the name of the database in a Data Guard environment.

Steps to be performed are

1. Ensure that the primary database and the standby database are in sync.
2. Shutdown the primary database cleanly ( shutdown immediate) , mount the database and use the NID utility to change the name of the database.

$nid target=sys/<password>@tnsalias dbname=<new db name> setname=Y

3. Change the parameter db_name parameter in the init.ora parameter file to reflect the new database name
4. Re-create the password file.
5. Change the tnsnames.ora and the listerner.ora parameters accordingly.
6. Open the database.
7. The logs will be shipped normally to the standby database.
8. Shutdown the standby database and change the db_name parameter to reflect the same in the primary db name.
7. Re-create the standby controlfile from the primary database.
8. Re-create the password file.
9. Modify the tnsnames.ora and the listener.ora parameter to reflect the changes.
10. Mount the database and start the media recovery.

 

 

1. Test the above steps in a test environment before implementing in a production environment.The above steps were not regression tested.

2. Once we change the database name in primary as per this document, it leads to the situation where as in standby datafiles will have old db_name.
To change the db_name in standby in all datafile, database should be started in read and write.

Follow below steps,

1) We need to perform switchover
OR
2) we need to perform snapshot standby conversion

3. Finally use the below query to confirm the DBID.

select FHDBI,FHDBN,count(*) from x$kcvfh group by FHDBI,FHDBN;