ORA-01516: nonexistent log file, datafile, or tempfile

Hi

While resizing the file due to Space issue in database we encountered this error. Mistake by DBA :( while creating/adding the datafile.

ERROR at line 1:

ORA-01516: nonexistent log file, datafile, or tempfile "/m001/oradata/pptl001/pptl001p1ptl00202.dbf"

Resizing of file was necessary due to space issue . instead of the file name we took the file number [12]

SQL> select FILE#,CREATION_TIME,name from v$datafile where name like '%pptl001p1ptl00202.dbf%';




FILE# CREATION_

---------- ---------

NAME

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

12 06-MAR-10

/m001/oradata/pptl001/pptl001p1prtl00202.dbf


SQL> alter database datafile 12 resize 1024m;

Database altered.
 
Finding the root couse of the error
 
creat a controlfile trace to check
 
 
SQL> alter database backup controlfile to trace as '/ora/admin/pprtl001/bdump/contrlbkp_03052010.lst';

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ah36(pptl001):/em/home/oracle>vi /ora/admin/pprtl001/bdump/controlbkp_03052010.lst


DATAFILE
'/m001/oradata/pprtl001/pprtl001system01.dbf',
'/m002/oradata/pprtl001/pprtl001undotbs01.dbf',
'/m001/oradata/pprtl001/pprtl001sysaux01.dbf',
'/m002/oradata/pprtl001/pprtl001users01.dbf',
'/m003/oradata/pprtl001/pprtl001p1prtl00101.dbf',
'/m004/oradata/pprtl001/pprtl001p1prtl00201.dbf',
'/m003/oradata/pprtl001/pprtl001wmtsappl00101.dbf',
'/m004/oradata/pprtl001/pprtl001wmtsappl00201.dbf',
'/m003/oradata/pprtl001/pprtl001p1intf00101.dbf',
'/m004/oradata/pprtl001/pprtl001p1intf00201.dbf',
'/m003/oradata/pprtl001/pprtl001p1prtl00102.dbf',
'/m001/oradata/pprtl001/pprtl001p1prtl00202.dbf ',-----extra whitespace space
'/m001/oradata/pprtl001/pprtl001p1prtl00103.dbf'
CHARACTER SET WE8ISO8859P1

;
 
we can check that there is an extra space .so to rectify the we need to rename the file
 
vijay kumar