NID DBNAME

Hi I would like to have the information about NID as well as DBNAME for the Oracle as well as the process for changing the NID as well as DBNAME?

NID utility was presented in Oracle 10g. DBNEWID is a database utility, in $ORACLE_HOME/container registry, that can change the interior database identifier (DBID) and the database name (DBNAME) for an operational database. Before the presentation of the DBNEWID utility

The DBID is an interior, novel identifier for a database. Since Recovery Manager (RMAN) recognizes databases by DBID, you couldn't enlist a seed database and a physically duplicated database together in the same RMAN storehouse. The DBNEWID utility takes care of this issue.

NID utility permits us to change

Just DBID of a database

Just DBNAME of a database

Both DBNAME and DBID of a database

Changing the DBID of a database is a genuine technique. At the point when the DBID of a database is changed every single past reinforcement and documented logs of the database get to be distinctly unusable.

Changing the DBNAME without changing the DBID does not oblige you to open with the RESETLOGS alternative, so database reinforcements and documented logs are not negated. In any case, changing the DBNAME has results. You should change the DB_NAME instatement parameter after a database name change to mirror the new name. Additionally, you may need to re-make the Oracle secret key document.

Parameters of NID utility (same parameters in Oracle 10g & Oracle 11g):
$ nid help=y
Keyword Description
TARGET Username/Password
DBNAME New database name
LOGFILE Output log
REVERT Revert failed change (YES/NO)?
SETNAME Set name only (YES/NO)?
APPEND Append to output log (YES/NO)?
HELP Displays help messages (YES/NO)?

Changing DBNAME & DBID
SQL> select dbid, name from v$database;
DBID NAME
---------- ---------
1744662402 SFM

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

Invoke the DBNEWID (NID) utility specifying the DBNAME from the command line using a user with SYSDBA privilege.
$ nid TARGET=sys/password DBNAME=new_name LOGFILE=change_dbname.log

__________________
Answered By StudyChaCha Member