Oracle数据文件迁移

Oracle数据文件迁移

1. 关闭数据库

shutdown immediate

2.物理迁移数据文件

–这里演示将acptdat.dbf从/u01/app/oracle/oradata/orcl/下迁移~~~~到/u02/oradata/hsbop下

mv /u01/app/oracle/oradata/orcl/acptdat.dbf  /u02/oradata/hsbop/acptdat.dbf

3. 将数据库启动到mount状态

SQL> startup mount
ORACLE instance started.
Total System Global Area 536870912 bytes
Fixed Size 1220408 bytes
Variable Size 171966664 bytes
Database Buffers 356515840 bytes
Redo Buffers 7168000 bytes
Database mounted.

3. 进行数据文件的rename

set pagesize 0
set linesize 200
select name from v$datafile;
select * from v$tempfile;



SQL> alter database rename file '/u01/app/oracle/oradata/orcl/acptdat.dbf' to '/u02/oradata/hsbop/acptdat.dbf';

Database altered.

5. 打开数据库

SQL> alter database open;

Database altered.

–迁移redo log同理。