使用backup as copy迁移数据文件

全部在rman下操作:
1.backup AS copy datafile 4 format '/u01/app/oracle/oradata/catlogdb_copy/users01.dbf';
2.SQL 'alter database datafile 4 offline';
3.switch datafile 4 TO copy;
4.recover datafile 4;
5.SQL 'alter database datafile 4 online';

RMAN> backup AS copy datafile 4 format '/u01/app/oracle/oradata/catlogdb_copy/users01.dbf';

Starting backup at 10-NOV-18
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u01/app/oracle/oradata/catlogdb/users01.dbf
output file name=/u01/app/oracle/oradata/catlogdb_copy/users01.dbf tag=TAG20181110T034401 RECID=13 STAMP=991799042
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 10-NOV-18

Starting Control File and SPFILE Autobackup at 10-NOV-18
piece handle=/u01/app/oracle/fast_recovery_area/CATLOGDB/autobackup/2018_11_10/o1_mf_s_991799043_fyf6lm83_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 10-NOV-18

RMAN> SQL 'alter database datafile 4 offline';

sql statement: alter database datafile 4 offline

RMAN> switch datafile 4 TO copy;

datafile 4 switched to datafile copy "/u01/app/oracle/oradata/catlogdb_copy/users01.dbf"

RMAN> recover datafile 4;

Starting recover at 10-NOV-18
using channel ORA_DISK_1
using channel ORA_DISK_2

starting media recovery
media recovery complete, elapsed time: 00:00:01

Finished recover at 10-NOV-18

RMAN> SQL 'alter database datafile 4 online';

sql statement: alter database datafile 4 online