Starting conversion at source at12-AUG-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile conversion
input datafilefilenumber=00005name=/u01/app/oracle/oradata/silent/ttbs1.dbf
converted datafile=/tmp/ttbs1.dbf
channel ORA_DISK_1: datafile conversion complete, elapsed time:00:00:16
Finished conversion at source at12-AUG-12
如果在target端转换,方法如下:
RMAN>CONVERTDATAFILE'/u01/app/oracle/oradata/sun/ttbs1.dbf'TOPLATFORM="Solaris Operating System (x86-64)"FROMPLATFORM="Linux x8664-bit" DB_FILE_NAME_CONVERT="/u01/app/oracle/oradata/sun/","/tmp/";
Starting conversion at target at12-AUG-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile conversion
inputfilename=/u01/app/oracle/oradata/sun/ttbs1.dbf
converted datafile=/tmp/ttbs1.dbf
channel ORA_DISK_1: datafile conversion complete, elapsed time:00:00:14
Finished conversion at target at12-AUG-12
(二):可以使用参数:remap_tablespace=ttbs1:ttbs2,来修改传过来的表空间名字。
心得:
可传输表空间加快了数据迁移的速度,可是使用逻辑导入导出来完成表空间传输需要将该表空间置为read only;虽然使用rman技术来完成��空间传输可以不将该表空间置为read only。但是用rman技术的过程相对非常复杂,这无疑导致该技术在生产环境使用的频率不大。多数人还是选择直接数据泵的方式来完成一个表空间的迁移工作。