Change database name & DBID (internal database identifier) using DBNEWID utility. - Oracle Control Files

Q.  You can change the database name and DBID (internal database identifier) using the DBNEWID utility.
- Published on 28 Jul 15

a. True
b. False

ANSWER: True

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 28 Aug 15
    - DBNEWID is a database utility that can change the internal database identifier (DBID) and the database name (DBNAME) for an operational database.

    - DBNEWID utility
    - Prior to the introduction of the DBNEWID utility, you could manually create a copy of a database and give it a new database name (DBNAME) by re-creating the control file.
    - However, you could not give the database a new identifier (DBID).
    - The DBID is an internal, unique identifier for a database.
    - Because Recovery Manager (RMAN) distinguishes databases by DBID, you could not register a seed database and a manually copied database together in the same RMAN repository.
    - The DBNEWID utility solves this problem by allowing you to change any of the following:

    1. Only the DBID of a database
    2. Only the DBNAME of a database
    3. Both the DBNAME and DBID of a database

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲