Oracle移动文件

关闭数据库
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

移动数据文件，用oracle用户操作
[oracle@test ~]$ mv /u01/app/oracle/oradata/ORCL/system01.dbf /home/oracle/oradata/system01.dbf
[oracle@test ~]$ mv /u01/app/oracle/oradata/ORCL/sysaux01.dbf /home/oracle/oradata/sysaux01.dbf
[oracle@test ~]$ mv /u01/app/oracle/oradata/ORCL/redo03.log /home/oracle/oradata/redo03.log
[oracle@test ~]$ mv /u01/app/oracle/oradata/ORCL/redo02.log /home/oracle/oradata/redo02.log
[oracle@test ~]$ mv /u01/app/oracle/oradata/ORCL/redo01.log /home/oracle/oradata/redo01.log

启动到mount状态
SQL> startup mount
ORACLE instance started.

Total System Global Area 1.0122E+10 bytes
Fixed Size 2237088 bytes
Variable Size 1610616160 bytes
Database Buffers 8489271296 bytes
Redo Buffers 19468288 bytes
Database mounted.

SQL> alter database rename file '/u01/app/oracle/oradata/ORCL/system01.dbf' to '/home/oracle/oradata/system01.dbf';

Database altered.

SQL> alter database rename file '/u01/app/oracle/oradata/ORCL/sysaux01.dbf' to '/home/oracle/oradata/sysaux01.dbf';

Database altered.

SQL> alter database rename file '/u01/app/oracle/oradata/ORCL/redo01.log' to '/home/oracle/oradata/redo01.log';

Database altered.

SQL> alter database rename file '/u01/app/oracle/oradata/ORCL/redo02.log' to '/home/oracle/oradata/redo02.log';

Database altered.

SQL> alter database rename file '/u01/app/oracle/oradata/ORCL/redo03.log' to '/home/oracle/oradata/redo03.log';

Database altered.

SQL> alter database open;

Database altered.

重启验证
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 1.0122E+10 bytes
Fixed Size 2237088 bytes
Variable Size 1610616160 bytes
Database Buffers 8489271296 bytes
Redo Buffers 19468288 bytes
Database mounted.
Database opened.