干净的关闭数据库，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

Copyright (c) 1982, 2005, Oracle. All rights reserved.

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>