Hi team!
I have problem with NID tool, i have executed nid TARGET=SYS/test@DEV 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