:: 极限 Linux ::Oracle HowTo:在非归档模式下如何更改数据文件位置

如果数据库处于非归档模式下，可以通过如下步骤更改文件路径:
1.关闭数据库
2.系统级进行文件复制
3.启动数据库到mount状态
3.通过SQL修改数据文件位置
4.打开数据库

以下是实际操作的步骤示范：

1.数据库处于非归档模式

SQL> archive log list;

            Database log mode              No Archive Mode

            Automatic archival             Enabled

            Archive destination            /opt/oracle/oradata/conner/archive

            Oldest online log sequence     150

            Current log sequence           153

2.需要移动test.dbf文件

SQL> select name from v$datafile;

            

            NAME

            ------------------------------------------------------------

            /opt/oracle/oradata/conner/system01.dbf

            /opt/oracle/oradata/conner/undotbs01.dbf

            /opt/oracle/oradata/conner/users01.dbf

            /opt/oracle/test.dbf

3.关闭数据库

SQL> shutdown immediate;

            Database closed.

            Database dismounted.

            ORACLE instance shut down.

4.复制文件到新的位置

SQL> ! cp /opt/oracle/test.dbf /opt/oracle/oradata/conner/test.dbf

5.启动数据库到mount状态

SQL> startup mount;

            ORACLE instance started.

            

            Total System Global Area  101782828 bytes

            Fixed Size                   451884 bytes

            Variable Size              37748736 bytes

            Database Buffers           62914560 bytes

            Redo Buffers                 667648 bytes

            Database mounted.

            SQL> select name from v$datafile;

            

            NAME

            -----------------------------------------------------------

            /opt/oracle/oradata/conner/system01.dbf

            /opt/oracle/oradata/conner/undotbs01.dbf

            /opt/oracle/oradata/conner/users01.dbf

            /opt/oracle/test.dbf

6.修改文件位置

SQL> alter database rename file '/opt/oracle/test.dbf' to '/opt/oracle/oradata/conner/test.dbf';

            

            Database altered.

            

            SQL> alter database open;

            

            Database altered.

            

            

            SQL> select name from v$datafile;

            

            NAME

            ----------------------------------------------------------------

            /opt/oracle/oradata/conner/system01.dbf

            /opt/oracle/oradata/conner/undotbs01.dbf

            /opt/oracle/oradata/conner/users01.dbf

            /opt/oracle/oradata/conner/test.dbf

            

            SQL>