4 Replies Latest reply: May 19, 2009 6:47 AM by 441582 RSS

    Problem with NID utility

    441582
      Hi, I meet some problems to change DBID with NID....thanks, I tried to revert but same result....I don't know that I can do now ?



      bash-3.00$ nid target=sys@M3RPT DBNAME=M3RPT

      DBNEWID: Release 10.2.0.4.0 - Production on Thu Apr 9 13:48:25 2009

      Copyright (c) 1982, 2007, Oracle. All rights reserved.

      Password:
      Connected to database M3PROD (DBID=3493640939)

      Connected to server version 10.2.0

      Control Files in database:
      /u02/oradata/M3PROD/control01.ctl

      Change database ID and database name M3PROD to M3RPT? (Y/[N]) => Y

      Proceeding with operation
      Changing database ID from 3493640939 to 4114889140
      Changing database name from M3PROD to M3RPT
      Control File /u02/oradata/M3PROD/control01.ctl - modified
      Datafile /u02/oradata/M3PROD/system01.dbf - dbid changed, wrote new name
      Datafile /u03/oradata/M3PROD/undotbs01.dbf - dbid changed, wrote new name
      Datafile /u03/oradata/M3PROD/sysaux01.dbf - dbid changed, wrote new name
      Datafile /u03/oradata/M3PROD/perfstat01.dbf - dbid changed, wrote new name
      Datafile /u05/oradata/M3PROD/users01.dbf - dbid changed, wrote new name
      Datafile /u05/oradata/M3PROD/tools01.dbf - dbid changed, wrote new name
      Datafile /u04/oradata/M3PROD/tmvxld01.dbf - dbid changed, wrote new name
      Datafile /u04/oradata/M3PROD/tmvxmd01.dbf - dbid changed, wrote new name
      Datafile /u04/oradata/M3PROD/tmvxsd01.dbf - dbid changed, wrote new name
      Datafile /u04/oradata/M3PROD/tmvxtd01.dbf - dbid changed, wrote new name
      Datafile /u05/oradata/M3PROD/tmvxli01.dbf - dbid changed, wrote new name
      Datafile /u05/oradata/M3PROD/tmvxmi01.dbf - dbid changed, wrote new name
      Datafile /u05/oradata/M3PROD/tmvxsi01.dbf - dbid changed, wrote new name
      Datafile /u05/oradata/M3PROD/tmvxti01.dbf - dbid changed, wrote new name
      Datafile /u04/oradata/M3PROD/tmvxarch01.dbf - dbid changed, wrote new name
      Datafile /u04/oradata/M3PROD/tmvxrunt01.dbf - dbid changed, wrote new name

      NID-00111: Oracle error reported from target database while executing
      begin dbms_backup_restore.nidprocessdf(:fno, :istemp, :skipped, :idchged, :nmchged); end;
      ORA-01455: converting column overflows integer datatype



      Change of database name and database ID failed.
      Must finish change or REVERT changes before attempting any database operation.
      DBNEWID - Completed with errors.

      bash-3.00$
      bash-3.00$
      bash-3.00$ nid target=sys@M3RPT REVERT=Y

      DBNEWID: Release 10.2.0.4.0 - Production on Thu Apr 9 14:13:08 2009

      Copyright (c) 1982, 2007, Oracle. All rights reserved.

      Password:
      Connected to database M3PROD (DBID=3493640939)

      Connected to server version 10.2.0

      Control Files in database:
      /u02/oradata/M3PROD/control01.ctl

      Revert changes for database M3PROD (Y/[N]) => Y

      Proceeding with operation
      Reverting database ID from 4114889140 to 3493640939
      Reverting database name from M3RPT to M3PROD
      Control File /u02/oradata/M3PROD/control01.ctl - modified
      Datafile /u03/oradata/M3PROD/undotbs01.dbf - reverted
      Datafile /u03/oradata/M3PROD/sysaux01.dbf - reverted
      Datafile /u03/oradata/M3PROD/perfstat01.dbf - reverted
      Datafile /u05/oradata/M3PROD/users01.dbf - reverted
      Datafile /u05/oradata/M3PROD/tools01.dbf - reverted
      Datafile /u04/oradata/M3PROD/tmvxld01.dbf - reverted
      Datafile /u04/oradata/M3PROD/tmvxmd01.dbf - reverted
      Datafile /u04/oradata/M3PROD/tmvxsd01.dbf - reverted
      Datafile /u04/oradata/M3PROD/tmvxtd01.dbf - reverted
      Datafile /u05/oradata/M3PROD/tmvxli01.dbf - reverted
      Datafile /u05/oradata/M3PROD/tmvxmi01.dbf - reverted
      Datafile /u05/oradata/M3PROD/tmvxsi01.dbf - reverted
      Datafile /u05/oradata/M3PROD/tmvxti01.dbf - reverted
      Datafile /u04/oradata/M3PROD/tmvxarch01.dbf - reverted
      Datafile /u04/oradata/M3PROD/tmvxrunt01.dbf - reverted

      NID-00111: Oracle error reported from target database while executing
      begin dbms_backup_restore.nidprocessdf(:fno, :istemp, :skipped, :idchged, :nmchged); end;
      ORA-01455: converting column overflows integer datatype



      Reversion of database name and database ID failed.
      Must finish REVERT changes before attempting any database operation.
      DBNEWID - Completed with errors.

      Edited by: oldschool on Apr 9, 2009 7:05 AM
      Can someone help me, please ?
        • 1. Re: Problem with NID utility
          user097815
          looks like your problem is more of realted to this error
          ORA-01455: converting column overflows integer datatype

          looks like some kind of bug..but not able to find a lot about it on metalink espicially with NID uitility...but for the above error...here are some links

          http://www.edhanced.com/ask-mred/?q=node/view/204

          http://www.dba-oracle.com/t_ora_01455_converting_column_overflow_integer_datatype.htm
          • 2. Re: Problem with NID utility
            441582
            Thanks but not really helpful...I entered a new SR in Metalink.
            • 3. Re: Problem with NID utility
              user097815
              i understand, as i was not able to find anything..

              please let us know what oracle suggested for that once you hear back from them
              • 4. Re: Problem with NID utility
                441582
                Sorry for delay; the problem was due missing tempfiles !!! thanks

                PROPOSED SOLUTION(S)
                ====================
                Can you please copy the tempfiles from primary to restored location & retry the nid command?
                If there is mismatch in path perform following step.
                Mount restored copy & drop all tempfiles using following command.
                alter database tempfile 1 drop ;

                + use query for tempfiles.
                select * from v$tempfile;

                PROPOSED SOLUTION JUSTIFICATION(S)
                ==================================
                alertlog file.