Forum Stats

  • 3,838,230 Users
  • 2,262,342 Discussions
  • 7,900,547 Comments

Discussions

NID tool hangs

User_1KNAV
User_1KNAV Member Posts: 1 Green Ribbon

Hi team!

I have problem with NID tool, i have executed nid TARGET=SYS/[email protected] in our 10.2.0.5 dev environment. Database is in mount state before i executed nid.

And it lists all database files with " - dbid changed " and it sopped on control file with same message near name.


DBNEWID: Release 10.2.0.5.0 - Production on Wed Nov 25 15:37:01 2020


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


Connected to database DEV (DBID=61663411)


Connected to server version 10.2.0


Control Files in database:

  /d01/oracle/DEV/db/tech_st/10.2.0/dbs/cntrlDEV.dbf


Change database ID of database DEV? (Y/[N]) => y

Changing database ID from 61665847 to 4135760874

Proceeding with operation

......

Datafile /data/oracle/DEV/db/a_txn_ind05.dbf - dbid changed

 Datafile /data/oracle/DEV/db/a_ref02.dbf - dbid changed

 Datafile /data/oracle/DEV/db/temp01.dbf - dbid changed

 Control data/db/oracle/DEV/db/10.2.0/dbs/cntrlDEV.dbf - dbid changed

.....

Database is big, but im not sure how long nid tool does DBID changes approximately? Currently im waiting hour and half to finish, and still waiting...

Any ideas?

Thank you