ORACLE 12C 冷备份方式的数据迁移（rename方式）

修改了控制文件的路径
*.control_files=‘/u01/app/oracle/oradata/test/controlfile/control01.ctl‘



修改数据文件的路径
alter database rename file ‘/u01/app/oracle/oradata/test/system01.dbf‘  to ‘/u01/app/oracle/oradata/test/datafile/system01.dbf‘;
alter database rename file ‘/u01/app/oracle/oradata/test/sysaux01.dbf‘  to ‘/u01/app/oracle/oradata/test/datafile/sysaux01.dbf‘;
alter database rename file ‘/u01/app/oracle/oradata/test/undotbs01.dbf‘ to ‘/u01/app/oracle/oradata/test/datafile/undotbs01.dbf‘;
alter database rename file ‘/u01/app/oracle/oradata/test/users01.dbf‘   to ‘/u01/app/oracle/oradata/test/datafile/users01.dbf‘;
alter database rename file ‘/u01/app/oracle/oradata/test/qwerty.dbf‘    to ‘/u01/app/oracle/oradata/test/datafile/qwerty.dbf‘;
alter database rename file ‘/u01/app/oracle/oradata/test/testbig.dbf‘   to ‘/u01/app/oracle/oradata/test/datafile/testbig.dbf‘;
alter database rename file ‘/u01/app/oracle/oradata/test/data_01.dbf‘   to ‘/u01/app/oracle/oradata/test/datafile/data_01.dbf‘;
alter database rename file ‘/u01/app/oracle/oradata/test/temp_async_01.dbf‘ to  ‘/u01/app/oracle/oradata/test/datafile/temp_async_01.dbf‘;
alter database rename file ‘/u01/app/oracle/oradata/test/temp01.dbf‘ to  ‘/u01/app/oracle/oradata/test/datafile/temp01.dbf‘;
alter database rename file ‘/u01/app/oracle/oradata/test/temp02.dbf‘ to  ‘/u01/app/oracle/oradata/test/datafile/temp02.dbf‘;


修改日志文件的路径
alter database rename file ‘/u01/app/oracle/oradata/test/redo01.log‘ to ‘/u01/app/oracle/oradata/test/onlinelog/redo01.log‘;
alter database rename file ‘/u01/app/oracle/oradata/test/redo02.log‘ to ‘/u01/app/oracle/oradata/test/onlinelog/redo02.log‘;
alter database rename file ‘/u01/app/oracle/oradata/test/redo03.log‘ to ‘/u01/app/oracle/oradata/test/onlinelog/redo03.log‘;


 
alter database open; 

至此，完成数据的迁移。

本文出自 “Sysdba” 博客，请务必保留此出处http://sysdba.blog.51cto.com/10492366/1702452

ORACLE 12C 冷备份方式的数据迁移（rename方式）

标签：oracle数据库迁移   冷备份   12c