Re: error trying to rename datafile

Eugene wrote:
> 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

Just a guess:

Use the RENAME FILE clause to rename datafiles, tempfiles, or redo log file members. You must create each filename using the conventions for filenames on your operating system before specifying this clause.

and

This clause renames only files in the control file. It does not actually rename them on your operating system. The operating system files continue to exist, but Oracle Database no longer uses them.

Source:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_1004.htm#SQLRF00802

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org