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
