关于Oracle可传输表空间的总结(5)

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技术的过程相对非常复杂,这无疑导致该技术在生产环境使用的频率不大。多数人还是选择直接数据泵的方式来完成一个表空间的迁移工作。

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/b402c6b96ee0d2d847ab411febb8041e.html