oracle 冷备份 改路径,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

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：http://sysdba.blog.51cto.com/10492366/1702452