My Oracle Support Banner

Unable to open database after NID fails due to missing temp files (Doc ID 1339657.1)

Last updated on FEBRUARY 18, 2019

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version to [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 22-Feb-2013***


After a manual clone of the database using RMAN restore, NID is used to change the dbid.
TEMP files are missing as they are not backed up by RMAN.   NID fails:

nid TARGET=/
NID-00111: Oracle error reported from target database while executing
begin dbms_backup_restore.nidprocessdf(:fno, :istemp, :skipped, :idchged, :nmchged); end;
ORA-01116: error in opening database file /oradata/<SID>/<DB_NAME>/<FILE_NAME>.dbf
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 6164
ORA-06512: at line 1

Subsequent attempt to open the database fails:

SQL> alter database open;
alter database open
ERROR at line 1:
ORA-19951: cannot modify control file until DBNEWID is completed

Alert log shows:

*** DBNEWID utility started ***
DBID will be changed from 2577615657 to new DBID of <DB_ID> for database <DB_NAME>
Starting datafile conversion
*** DBNEWID utility started ***
DBNEWID utility is reverting a failed conversion
DBID will be reverted from 2381382096 to original DBID of <DB_ID> for database <DB_NAME>
Starting datafile conversion
Fri Jul 15 10:01:41 2011
alter database open
Fri Jul 15 10:01:42 2011
Errors in file /<DIR>/<DB_NAME>/udump/<FILE_NAME>.trc:
Fri Jul 15 10:01:42 2011
ORA-19951 signalled during: alter database open...

Inspection of file headers shows:

SQL>Select distinct(FHDBI) ,count(*) from x$kcvfh group by fhdbi;

---------- ----------
2381382096 1
2577615657 603

SQL>select FHDBN,FHBSZ,FHFNO,HXFNM,FHDBI from x$kcvfh where FHDBI=nnnnnnnnn;

--------- ---------- ---------- -------------------------------------------------- ----------
<COLUMN_DATA> 8192 1 ........../<FILE_NAME>

So only the system datafile has had the dbid change completed - all other files have the old dbid.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.