SYS@orser> set line 120
SYS@orser> col file_name for a40
SYS@orser> col tablespace_name for a40
SYS@orser> col sizem for a30
SYS@orser> select file_name,tablespace_name,bytes/1024/1024||'M' sizem from dba_data_files;

FILE_NAME TABLESPACE_NAME SIZEM
---------------------------------------- ---------------------------------------- ------------------------------
/u01/app/oracle/oradata/orser/system01.d SYSTEM 720M
bf

/u01/app/oracle/oradata/orser/sysaux01.d SYSAUX 620M
bf

/u01/app/oracle/oradata/orser/undotbs01. UNDOTBS1 755M
dbf

/u01/app/oracle/oradata/orser/users01.db USERS 5M
f

FILE_NAME TABLESPACE_NAME SIZEM
---------------------------------------- ---------------------------------------- ------------------------------

/u01/app/oracle/oradata/orser/example01. EXAMPLE 200M
dbf

/u01/app/oracle/oradata/orser/orser01.db ORSER 200M
f

/u01/app/oracle/oradata/orser/test01.dbf TEST 200M
/u01/app/oracle/oradata/orser/test02.dbf TEST 200M

8 rows selected.

SYS@orser> alter tablespace test drop datafile '/u01/app/oracle/oradata/orser/test02.dbf';

Tablespace altered.

SYS@orser> alter tablespace test add datafile '/u01/app/oracle/oradata/orser/test02.dbf' size 200m autoextend on;

Tablespace altered.

SYS@orser> alter tablespace test rename datafile '/u01/app/oracle/oradata/orser/test02.dbf' to '/u01/app/oracle/oradata/orser/test03.dbf';
alter tablespace test rename datafile '/u01/app/oracle/oradata/orser/test02.dbf' to '/u01/app/oracle/oradata/orser/test03.dbf'
*
ERROR at line 1:
ORA-01525: error in renaming data files
ORA-01121: cannot rename database file 8 - file is in use or recovery
ORA-01110: data file 8: '/u01/app/oracle/oradata/orser/test02.dbf'

SYS@orser> alter tablespace test offline;

Tablespace altered.

SYS@orser> alter tablespace test rename datafile '/u01/app/oracle/oradata/orser/test02.dbf' to '/u01/app/oracle/oradata/orser/test03.dbf';
alter tablespace test rename datafile '/u01/app/oracle/oradata/orser/test02.dbf' to '/u01/app/oracle/oradata/orser/test03.dbf'
*
ERROR at line 1:
ORA-01525: error in renaming data files
ORA-01141: error renaming data file 8 - new file '/u01/app/oracle/oradata/orser/test03.dbf' not found
ORA-01110: data file 8: '/u01/app/oracle/oradata/orser/test02.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

[oracle@orser orser]$ cp test02.dbf test03.dbf

SYS@orser> alter tablespace test rename datafile '/u01/app/oracle/oradata/orser/test02.dbf' to '/u01/app/oracle/oradata/orser/test03.dbf';

Tablespace altered.

SYS@orser> alter database rename file '/u01/app/oracle/oradata/orser/test03.dbf' to '/u01/app/oracle/oradata/orser/test04.dbf';
alter database rename file '/u01/app/oracle/oradata/orser/test03.dbf' to '/u01/app/oracle/oradata/orser/test04.dbf'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01141: error renaming data file 8 - new file '/u01/app/oracle/oradata/orser/test04.dbf' not found
ORA-01110: data file 8: '/u01/app/oracle/oradata/orser/test03.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

[oracle@orser orser]$ cp test03.dbf test04.dbf

SYS@orser> alter database rename file '/u01/app/oracle/oradata/orser/test03.dbf' to '/u01/app/oracle/oradata/orser/test04.dbf';

Database altered.

SYS@orser> select file_name,tablespace_name,bytes/1024/1024||'M' sizem from dba_data_files;

FILE_NAME TABLESPACE_NAME SIZEM
---------------------------------------- ---------------------------------------- ------------------------------
/u01/app/oracle/oradata/orser/system01.d SYSTEM 720M
bf

/u01/app/oracle/oradata/orser/sysaux01.d SYSAUX 620M
bf

/u01/app/oracle/oradata/orser/undotbs01. UNDOTBS1 755M
dbf

/u01/app/oracle/oradata/orser/users01.db USERS 5M
f

FILE_NAME TABLESPACE_NAME SIZEM
---------------------------------------- ---------------------------------------- ------------------------------

/u01/app/oracle/oradata/orser/example01. EXAMPLE 200M
dbf

/u01/app/oracle/oradata/orser/orser01.db ORSER 200M
f

/u01/app/oracle/oradata/orser/test01.dbf TEST M
/u01/app/oracle/oradata/orser/test04.dbf TEST M

8 rows selected.

SYS@orser> alter tablespace test rename datafile '/u01/app/oracle/oradata/orser/test04.dbf' to '/u01/app/oracle/oradata/orser/test02.dbf'
2 ;

Tablespace altered.

不管是alter datatable reame file 还是 alter tablespsce test rename datafile 都是在已经存在的文件上进行重命名。

ITPub博客

重命名数据文件ORA-01525: error in renaming data files

最新文章