假如数据库处于非归档模式下,可以通过如下步骤更改文件路径:
1.关闭数据库
2.系统级进行文件复制
3.启动数据库到mount状态
3.通过SQL修改数据文件位置
4.打开数据库
以下是实际操作的步骤示范:
1.数据库处于非归档模式
SQL archive log list;
Database log modeNo 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 Area101782828 bytes
Fixed Size 451884 bytes
Variable Size37748736 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