Changing the DBID - DBNEWID utility

Changing the DBID - DBNEWID utility

Prior to the introduction of the DBNEWID utility alteration of the internal DBID of an instance was impossible and alteration of the DBNAME required the creation of a new controlfile.

The DBNEWID utility allows the DBID to be altered for the first time and makes changing the DBNAME simpler. Changing the DBID is necessary when you want to use an RMAN catalog to backup a cloned instance.

RMAN identifies instances using the DBID, preventing the original and cloned instance being managed by the same catalog. Alteration of the BID in the cloned instance removes this restriction.

Procedure :

- Backup the database.
- Mount the database after a clean shutdown
SHUTDOWN IMMEDIATE
STARTUP MOUNT

- Invoke the DBNEWID utility (nid) from the command line using a user with SYSDBA privilege.

nid TARGET=sys/password@TSH3

- Shutdown and open the database with RESETLOGS:

SHUTDOWN IMMEDIATE
STARTUP MOUNT
ALTER DATABASE OPEN RESETLOGS;

- Backup the database.