标题: 12c跨平台源或目标转换压缩传输表空间 [打印本页] 作者: 郑全 时间: 2019-9-26 11:01 标题: 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> ;