This discussion is archived
4 Replies Latest reply: May 19, 2009 4:47 AM by 441582 RSS

Problem with NID utility

441582 Newbie
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Thanks but not really helpful...I entered a new SR in Metalink.
  • 3. Re: Problem with NID utility
    user097815 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points