oracle使用backup as copy方式迁移数据文件
1 基础环境
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | --确认数据文件路径set line 200col name for a75select file#,name from v$datafile FILE# NAME---------- --------------------------------------------------------------------------- 1 /u01/app/oracle/oradata/ORCL/system01.dbf 3 /u01/app/oracle/oradata/ORCL/sysaux01.dbf 4 /u01/app/oracle/oradata/ORCL/undotbs01.dbf 5 /u01/app/oracle/oradata/ORCL/test.dbf 7 /u01/app/oracle/oradata/ORCL/users01.dbf --目标路径（确认目标路径的所属）/oradata/ORCL[root@test ~]# ll /oradata/total 0drwxrwxr-x 2 oracle oinstall 6 Jul 25 02:37 ORCL |
2 重新起库到mount状态
1 2 | SQL> shu immediateSQL> startup mount; |
3 backup as copy 方式改路径
1 2 3 4 5 6 7 8 9 10 11 12 13 | rman target /backup as copy datafile 1 format '/oradata/ORCL/system01.dbf';backup as copy datafile 3 format '/oradata/ORCL/sysaux01.dbf';backup as copy datafile 4 format '/oradata/ORCL/undotbs01.dbf';backup as copy datafile 5 format '/oradata/ORCL/test.dbf';backup as copy datafile 7 format '/oradata/ORCL/users01.dbf';switch datafile 1 to copy;switch datafile 3 to copy;switch datafile 4 to copy;switch datafile 5 to copy;switch datafile 7 to copy; |
4 确认文件路径是否是目标路径
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | SQL> set line 200SQL> col name for a75SQL> select file#,name from v$datafile; FILE# NAME---------- --------------------------------------------------------------------------- 1 /oradata/ORCL/system01.dbf 3 /oradata/ORCL/sysaux01.dbf 4 /oradata/ORCL/undotbs01.dbf 5 /oradata/ORCL/test.dbf 7 /oradata/ORCL/users01.dbf[oracle@test ~]$ cd /oradata/ORCL/[oracle@test ORCL]$ lltotal 3986472-rw-r----- 1 oracle oinstall 618668032 Jul 25 02:47 sysaux01.dbf-rw-r----- 1 oracle oinstall 954212352 Jul 25 02:47 system01.dbf-rw-r----- 1 oracle oinstall 2147491840 Jul 25 02:47 test.dbf-rw-r----- 1 oracle oinstall 356524032 Jul 25 02:47 undotbs01.dbf-rw-r----- 1 oracle oinstall 5251072 Jul 25 02:47 users01.dbf |
5 起库到open状态
1 2 | alter database open;select open_mode,database_role from v$database; |
6 检查alert日志，如无报错，则通知业务起应用
7 如果有dg库，请注意修改备库上的convert参数
到此这篇关于Oracle使用backup as copy方式迁移数据文件的流程步骤的文章就介绍到这了,更多相关Oracle backup as copy迁移数据文件内容请搜索IT俱乐部以前的文章或继续浏览下面的相关文章希望大家以后多多支持IT俱乐部！
