rename 数据文件，在线文件路径-优快云博客

本文详细介绍如何在Oracle数据库中干净地关闭数据库，然后重新命名并移动数据文件、日志文件及临时文件至新的位置。通过SQL命令实现数据文件路径的更改，并确保数据库能够正确识别新路径。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

干净的关闭数据库，rename 数据文件，日志文件

[@more@]

$ ls -llt
total 27709826
-rw-r----- 1 oracle dba 7553024 Dec 25 16:47 control01.ctl
-rw-r----- 1 oracle dba 7553024 Dec 25 16:47 control02.ctl
-rw-r----- 1 oracle dba 7553024 Dec 25 16:47 control03.ctl
-rw-r----- 1 oracle dba 524288512 Dec 25 16:47 redo02.log
-rw-r----- 1 oracle dba 4194312192 Dec 25 16:47 sysaux01.dbf
-rw-r----- 1 oracle dba 4194312192 Dec 25 16:47 system01.dbf
-rw-r----- 1 oracle dba 4194312192 Dec 25 16:47 undotbs01.dbf
-rw-r----- 1 oracle dba 524288512 Dec 25 16:46 redo01.log
-rw-r----- 1 oracle dba 524288512 Dec 25 16:46 redo03.log
-rw-r----- 1 oracle dba 4194312192 Dec 24 22:00 temp01.dbf
drwxr-xr-x 2 oracle dba 1024 Dec 24 13:53 archive

$pwd

/u01/oracle/oradata/fcard
$ mv *.dbf ../fcardbak
$ ls -lt
total 3117938
-rw-r----- 1 oracle dba 7553024 Dec 25 16:47 control01.ctl
-rw-r----- 1 oracle dba 7553024 Dec 25 16:47 control02.ctl
-rw-r----- 1 oracle dba 7553024 Dec 25 16:47 control03.ctl
-rw-r----- 1 oracle dba 524288512 Dec 25 16:47 redo02.log
-rw-r----- 1 oracle dba 524288512 Dec 25 16:46 redo01.log
-rw-r----- 1 oracle dba 524288512 Dec 25 16:46 redo03.log
drwxr-xr-x 2 oracle dba 1024 Dec 24 13:53 archive
$ mv *.log ../fcardbak

启动到 mount 状态：

$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 25 16:49:45 2007

Connected to an idle instance.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 7516192768 bytes
Fixed Size 1990312 bytes
Variable Size 704643416 bytes
Database Buffers 6794772480 bytes
Redo Buffers 14786560 bytes
Database mounted.

查看原来数据文件的路径：

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u01/oracle/oradata/fcard/system01.dbf
/u01/oracle/oradata/fcard/undotbs01.dbf
/u01/oracle/oradata/fcard/sysaux01.dbf
/u01/oracle/oradata/fcardbak/users01.dbf

更改数据文件的路径：

SQL> alter database rename file '/u01/oracle/oradata/fcard/system01.dbf' to '/u01/oracle/oradata/fcardbak/system01.dbf';

Database altered.

SQL> alter database rename file '/u01/oracle/oradata/fcard/undotbs01.dbf' to '/u01/oracle/oradata/fcardbak/undotbs01.dbf';

Database altered.

SQL> alter database rename file '/u01/oracle/oradata/fcard/sysaux01.dbf' to '/u01/oracle/oradata/fcardbak/sysaux01.dbf';

Database altered.

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u01/oracle/oradata/fcardbak/system01.dbf
/u01/oracle/oradata/fcardbak/undotbs01.dbf
/u01/oracle/oradata/fcardbak/sysaux01.dbf
/u01/oracle/oradata/fcardbak/users01.dbf

查看临时文件的路径，更改临时文件的路径

SQL> select name from v$tempfile;

NAME
--------------------------------------------------------------------------------
/u01/oracle/oradata/fcard/temp01.dbf

SQL> alter database rename file '/u01/oracle/oradata/fcard/temp01.dbf' to '/u01/oracle/oradata/fcardbak/temp01.dbf';

Database altered.

查看日志文件的路径
SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/u01/oracle/oradata/fcard/redo01.log
/u01/oracle/oradata/fcard/redo02.log
/u01/oracle/oradata/fcard/redo03.log

更改日志文件的路径

SQL> alter database rename file '/u01/oracle/oradata/fcard/redo01.log' to '/u01/oracle/oradata/fcardbak/redo01.log';

Database altered.

SQL> alter database rename file '/u01/oracle/oradata/fcard/redo02.log' to '/u01/oracle/oradata/fcardbak/redo02.log';

Database altered.

SQL> alter database rename file '/u01/oracle/oradata/fcard/redo03.log' to '/u01/oracle/oradata/fcardbak/redo03.log';

Database altered.

SQL> alter database open;

Database altered.

SQL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/66233/viewspace-995756/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/66233/viewspace-995756/