error trying to rename datafile

From: Eugene <epipko_at_gmail.com>
Date: Sun, 22 Jul 2007 21:52:06 -0700
Message-ID: <1185166326.743776.150540@i13g2000prf.googlegroups.com>

Hi all,
What may cause the following error?

---

select file_name
from dba_data_files
where
tablespace_name = 'XLARGE_DATA';

G:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_01.DBF
F:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_02.DBF
F:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_03.DBF
G:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_04.DBF
F:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_05.DBF
F:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_06.DBF
G:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_07.DBF
M:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_08.DBF
M:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_09.DBF
M:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_10.DBF
M:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_11.DBF
G:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_12.DBF
L:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_12.DBF
L:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_13.DBF
L:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_14.DBF
L:\ORACLE\ESST\DATA\ESST_LARGE_DATA_15.DBF
L:\ORACLE\ESST\DATA\ESST_XLARGE_INDX_13.DBF

.......
shutdown immediate;
.....
startup mount;
.....
ALTER DATABASE RENAME FILE 'L:\ORACLE\ESST\DATA
\ESST_XLARGE_INDX_13.DBF' TO 'L:\ORACLE\ESST\DATA
\ESST_XLARGE_DATA_16.DBF';
ALTER DATABASE RENAME FILE 'L:\ORACLE\ESST\DATA
\ESST_XLARGE_INDX_13.DBF' TO 'L:\ORACLE\ESST\DATA
\ESST_XLARGE_DATA_16.DBF'

*
ERROR at line 1:
ORA-01511: error in renaming log/data files ORA-01141: error renaming data file 114 - new file 'L:\ORACLE\ESST\DATA\ESST_XLARGE_DATA_16.DBF' not found ORA-01110: data file 114: 'L:\ORACLE\ESST\DATA
\ESST_XLARGE_INDX_13.DBF'

ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Thanks,
Eugene Received on Sun Jul 22 2007 - 23:52:06 CDT