12c跨平台源或目标转换压缩传输表空间

郑全

环境：
     源端：Linux x86 64-bit
     目标端：Microsoft Windows x86 64-bit


源端：
1.1.源端转换：
rman >backup as compressed backupset to platform 'Microsoft Windows x86 64-bit'
format '/home/oracle/tsp_test01.bak'
datapump format '/home/oracle/tts.dmp' tablespace tsp_test;


1.2 目标端转换
rman> backup as compressed backupset for transport format '/home/oracle/tsp_test01.bak'
datapump format '/home/oracle/tts.dmp' tablespace tsp_test;



目标端：
2.1 源端转换的恢复：
RMAN> restore foreign tablespace tsp_test
2>    format 'd:\oracle\tsp_test01.dbf'
3>    from backupset 'd:\oracle\tsp_test01.bak'
4>    dump file from backupset 'd:\oracle\tts.dmp'


2.2 目标端转换的恢复：
RMAN> restore from platform 'Linux x86 64-bit'
2>   foreign tablespace tsp_test format 'd:\oracle\tsp_test01.dbf'
3>   from backupset 'd:\oracle\tsp_test01.bak'
4> dump file from backupset 'd:\oracle\tts.dmp'
5> ;