12c online move datafile

最新推荐文章于 2024-09-07 23:15:43 发布

原创最新推荐文章于 2024-09-07 23:15:43 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍如何使用Oracle 12C进行在线移动数据文件操作，通过SQL命令实现数据文件的位置更改，并验证移动前后文件路径的变化。

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

oracle12C可以实现在线move数据文件,使得我们rename file方便了很多

SQL> select file#,name from v$datafile;
FILE# NAME
---------- -------------------------------------------------------------------------------------
1 /opt/app/oracle/oradata/ORA12C/datafile/system.dbf
3 /opt/app/oracle/oradata/ORA12C/datafile/sysaux.dbf
4 /opt/app/oracle/oradata/ORA12C/datafile/undotbs1.dbf
6 /opt/app/oracle/oradata/ORA12C/datafile/users.dbf
SQL> alter database move datafile 6 to '/tmp/users.dbf';
Database altered.
SQL> select file#,name from v$datafile;
FILE# NAME
---------- -------------------------------------------------------------------------------------
1 /opt/app/oracle/oradata/ORA12C/datafile/system.dbf
3 /opt/app/oracle/oradata/ORA12C/datafile/sysaux.dbf
4 /opt/app/oracle/oradata/ORA12C/datafile/undotbs1.dbf
6 /tmp/users.dbf
SQL> alter database move datafile 6 to '/opt/app/oracle/oradata/ORA12C/datafile/users.dbf';
Database altered.
SQL> select file#,name from v$datafile;
FILE# NAME
---------- -------------------------------------------------------------------------------------
1 /opt/app/oracle/oradata/ORA12C/datafile/system.dbf
3 /opt/app/oracle/oradata/ORA12C/datafile/sysaux.dbf
4 /opt/app/oracle/oradata/ORA12C/datafile/undotbs1.dbf
6 /opt/app/oracle/oradata/ORA12C/datafile/users.dbf
SQL> alter database move datafile 1 to '/tmp/system.dbf';
Database altered.
SQL> select file#,name from v$datafile;
FILE# NAME
---------- -------------------------------------------------------------------------------------
1 /tmp/system.dbf
3 /opt/app/oracle/oradata/ORA12C/datafile/sysaux.dbf
4 /opt/app/oracle/oradata/ORA12C/datafile/undotbs1.dbf
6 /opt/app/oracle/oradata/ORA12C/datafile/users.dbf
SQL> alter database move datafile 1 to '/opt/app/oracle/oradata/ORA12C/datafile/system.dbf';
Database altered.
SQL> select file#,name from v$datafile;
FILE# NAME
---------- -------------------------------------------------------------------------------------
1 /opt/app/oracle/oradata/ORA12C/datafile/system.dbf
3 /opt/app/oracle/oradata/ORA12C/datafile/sysaux.dbf
4 /opt/app/oracle/oradata/ORA12C/datafile/undotbs1.dbf
6 /opt/app/oracle/oradata/ORA12C/datafile/users.dbf