需求:
将oracle控制文件、数据文件、日志文件、临时文件从A目录迁移到B目录。
A目录:D:ORACLEORADATATEST
B目录:F:TEST
步骤:
1、关闭数据库,把D:ORACLEORADATATEST下文件复制到F:TEST下;
2、编辑D:oracleora92databaseINITTEST.ORA,修改为:
control_files=("F:TESTcontrol01.ctl", "F:TESTcontrol02.ctl", "F:TESTcontrol03.ctl")
3、创建SPFILE: create spfile from pfile;
4、载入数据库:startup mount;
5、查询文件位置:
select name from v$datafile;
select member from v$logfile;
select name from v$controlfile;
select name from v$tempfile;
6、移动数据文件、日志文件
alter database rename file 'D:ORACLEORADATATESTREDO01.LOG' to 'F:TEST edo01.log';
alter database rename file 'D:ORACLEORADATATESTSYSTEM01.DBF' to 'F:TESTSYSTEM01.DBF';
7、启动数据库:alter database open;
8、重建临时文件:
alter database tempfile '临时文件路径' drop;
alter tablespace temp add tempfile '临时文件路径' size 100M reuse;
select * from v$tempfile;
9、重启数据库,迁移完成。