My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.4 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 22-Feb-2013***

Goal

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>/db01/temp.01.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 2381382096 for database MDSWTRN
Starting datafile conversion
*** DBNEWID utility started ***
DBNEWID utility is reverting a failed conversion
DBID will be reverted from 2381382096 to original DBID of 2577615657 for database MDSWTRN
Starting datafile conversion
Fri Jul 15 10:01:41 2011
alter database open
Fri Jul 15 10:01:42 2011
Errors in file /orasw/app/oracle/admin/MDSWTRN/udump/mdswtrn_ora_704520.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;

FHDBI COUNT(*)
---------- ----------
2381382096 1
2577615657 603

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

FHDBN FHBSZ FHFNO HXFNM FHDBI
--------- ---------- ---------- -------------------------------------------------- ----------
MDSWTRN 8192 1 ........../system.01.dbf 2381382096


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

Solution

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

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


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