How to Change the DBID and the DBNAME by using NID

The NID (New Database ID) is a new utility introduced with Oracle 9.2. The NID utility allows you to change only the DBNAME, or only the DBID or both DBNAME and DBID in the same command.

Notes:

1. If you change the DBID you must open the database with the RESETLOGS option, which re-creates the online redo logs and resets their sequence to 1.
2. If you change the DBNAME without changing the DBID then this does not require you to open with the RESETLOGS option, so database backups and archived logs are not invalidated. You must change the DB_NAME initialization parameter after a database name change to reflect the new name. Also, you may have to re-create the Oracle password file. If you restore an old backup of the control file (before the name change, then you should use the initialization parameter file and password file from before the database name change.

Steps to use NID :
=============

1. Backup the database
2. SHUTDOWN IMMEDIATE of the database
3. STARTUP MOUNT
4. Open one session and run NID with sysdba privileges
5. Shutdown IMMEDIATE of the database
   
6. Set the DB_NAME initialization parameter in the initialization parameter file to the new database name
7. Create a new password file
8. Startup of the database with open resetlogs/no resetlogs

NID Usage:
========

TARGET --> Username/Password
DBNAME --> New database name
LOGFILE --> Output Log
REVERT --> Revert failed change (NO)
SETNAME --> Set a new database name only (NO)
APPEND --> Append to output log (NO)
HELP --> Displays these messages (NO)