ORA-01516: nonexistent log file, data file, or temporary file

Issue:

SQL> alter database rename file ‘/u01/oradata/SAMPLE/index19.dbf’     to ‘/u06/oradata/SAMPLE/index19.dbf’;
alter database rename file ‘/u01/oradata/SAMPLE/index19.dbf’     to ‘/u06/oradata/SAMPLE/index19.dbf’
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, data file, or temporary file
“/u01/oradata/SAMPLE/index19.dbf”

Causes:-

1.This file is not available the mentioned location
2.check the name of the datafile(case sensitive)

Solution:-

1. Check the fild# and location from v$datafile and re run the query.

  • October 9, 2017 | 20 views
  • Comments