While cloning from Production to Non Production Databases, we come across same DBID being generated for the Non Prod Database.
This would result in RMAN backup related errors, if you are using the same catalog database for both Production and Non Production Databases. To overcome this, the DBID needs to be changed for the Non Production database. Below are the steps you can follow to change the DBID :
Select dbid from v$database;
Ensure that the target database is mounted but not open, and that it was shut down consistently prior to mounting.
In the Terminal Window, execute the nid command
bash-4.1$ which nid
> Invoke the DBNEWID utility on the command line, specifying a valid user with the
. For example:
bash-4.1$ nid TARGET=SYS/oracle@test_db
The DBNEWID utility performs validations in the headers of the datafiles and control files before attempting I/O to the files. If validation is successful, then DBNEWID prompts you to confirm the operation (unless you specify a log file, in which case it does not prompt), changes the DBID for each datafile (including offline normal and read-only datafiles), and then exits. The database is left mounted but is not yet usable.
After DBNEWID successfully changes the DBID, shut down the database
Alter database open resetlogs;
There you go. The DBID will be different now from that of Production