oracle使用backup as copy方式迁移数据文件

1 基础环境

--确认数据文件路径 set line 200 col name for a75 select 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 0 drwxrwxr-x 2 oracle oinstall 6 Jul 25 02:37 ORCL 

2 重新起库到mount状态

SQL> shu immediate SQL> startup mount; 

3 backup as copy 方式改路径

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 确认文件路径是否是目标路径

SQL> set line 200 SQL> col name for a75 SQL> 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]$ ll total 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状态

alter database open; select open_mode,database_role from v$database; 

6 检查alert日志，如无报错，则通知业务起应用

7 如果有dg库，请注意修改备库上的convert参数