NID-00111 error
Hi Guys,
I am running Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production on RHEL5.
I restored my database without a problem and now I tried to rename ny database name using NID.
Little did I knew that I did not add a tempfile or create a new temp tablespace after the restore.
Now I got this error when trying to rename the database:
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 /path/temp01.dbf
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 6236
ORA-06512: at line 1
I read on metalink note ID 1339657.1 that I should copy the file to where NID is trying to find them.
Now should I go to the production environment and copy this files to my dev and try to run revert?
What would be the impact by doing that?
Please help!!!!!!!!!!!