How to change the DB ID of a database using NID utility

1.       Check the current DB ID of the database.

SELECT DBID, NAME FROM V$DATABASE;

2.       Shutdown and then mount the database

shutdown immediate

startup mount

3.       Execute the nid utility to change the DB Id

nid target=system/syspwd@dw

** dw = Database name for the target database.

4.       Open the database with the RESETLOGS option

startup mount

ALTER DATABASE OPEN RESETLOGS;

5.       Check the new DB ID of the database.

SELECT DBID, NAME FROM V$DATABASE;