oracle 迁移数据文件，online redo-优快云博客

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/prod/system01.dbf
/u01/app/oracle/oradata/prod/undotbs01.dbf
/u01/app/oracle/oradata/prod/sysaux01.dbf
/u01/app/oracle/oradata/prod/users01.dbf
/u01/app/oracle/oradata/prod/mgmt.dbf
/u01/app/oracle/oradata/prod/mgmt_ecm_depot1.dbf
/u01/test01.dbf
/u01/app/oracle/oradata/prod/catalog01.dbf

在不能关闭数据库的情况下：将表空间offline

alter tablespace USERS offline immediate;

os层面移动好文件后：alter tablespace USERS rename datafile '/u01/app/oracle/oradata/prod/users01.dbf' to '/u01/app/oracle/oradata/prod/users02.dbf'

recover tablespace USERS;

alter tablespace users online;

能关数据库的情况：

启动到mount 状态，

alter database rename file '/u01/app/oracle/oradata/prod/users02.dbf' to '/u01/app/oracle/oradata/prod/users01.dbf

打开数据库即可。

移动online redo

mount状态下

alter database rename file语句