Friday, September 20, 2024

NID utility, NID-00131: Control file is not current.

   


        If NID utility fails with below error,

                   $ nid target=/ setname=true dbname=<TARGET_DB_NAME>

          DBNEWID: Release 19.0.0.0.0 - Production on Fri Sep 20                  12:19:38 2024

          Copyright (c) 1982, 2019, Oracle and/or its affiliates.                     All rights reserved.

          Connected to database TEST (DBID=16550)

          NID-00131: Control file is not current

          Change of database name failed during validation -                         database is intact.

          DBNEWID - Completed with validation errors.

       If you check the control file type it will not as "Current" .

                     select CONTROLFILE_TYPE  from v$database;

                   CONTROL

                     -------

                     BACKUP

    we need to change the control file type to the current, and for that post restoring the database 
    to restart the database, now the control file type will updated automatically to the current. now NID           utility   will work

             select CONTROLFILE_TYPE  from v$database;

                       CONTROL

                       -------

                      CURRENT