On Jul 22, 10:37 pm, DA Morgan <damor..._at_psoug.org> wrote:
> 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/statem...
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>
> - Show quoted text -
Thank you, Daniel
Received on Mon Jul 23 2007 - 11:15:01 CDT
