参考mos文档:
V4 Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup (Doc ID 2471245.1)
最新版的tts包下载链接:
链接:https://pan.baidu.com/s/1k-hXP1tUlIWlbuuHNLrKwg
提取码:sjz1
1、确认源端和目标端的平台ID
line 200
col PLATFORM_NAME for a40
select a.PLATFORM_ID,a.PLATFORM_NAME,a.ENDIAN_FORMAT from v$transportable_platform a, v$database b where a.PLATFORM_NAME=b.PLATFORM_NAME;
2、源端和目标端的字符集要相同
SET LINESIZE 200
COL PARAMETER FOR A40
COL VALUE FOR A40
select * from nls_database_parameters where parameter like '%CHARACT%';
3、配置tns
oldtns =
(description =
(address = (protocol = tcp)(host = 192.168.10.71)(port = 1521))
(connect_data =
(server = dedicated)
(service_name = orcl)
)
)
newtns =
(description =
(a