EBS R12的11g庫從AIX遷移到Linux不能採用 Cross Platform Incremental Backup 的原因

      詳見紅色字型部分，估計是EBS中一些特殊的object不適用這種方式，普通資料庫可以採用。所以目前EBS還只能是傳統的XTTS (跨平臺傳輸表空間) 及 EXPDP/IMPDP+OGG兩種方法 。 

 

Known Issues and Limitations of XTTS    

1. Built-in Limitations 
   Built-in limitations are documented in the . One important limitation outlined in this document that is relevant for EBS is that the source and target databases must have the same character set and national character set.
2. Column Encryption Using TDE 
   Transportable Tablespaces migration is not supported for tables that have columns encrypted using the Transparent Data Encryption (TDE) functionality of Oracle Database 11g (see My Oracle Support Document 732764.1). Tables that have encrypted columns must be de-crypted prior to following the transportable tablespaces migration and then encrypted in the target database after migration.
3. Mixing RDBMS and EBS Schemas in the same Tablespace 
   The use of RDBMS and EBS Schemas in the same tablespace is not supported as tablespaces with RDBMS schemas are disregarded in the creation of the transportable set. It is recommended that RDBMS schemas (such as CTXSYS) be in separate tablespaces (for example, SYSAUX).
4. Cross Platform Incremental Backup (跨平臺增量備份方式)
   Cross Platform Incremental Backup is not certified to work with an EBS database.

 

參考Oracle文件 ：  Using Transportable Tablespaces for EBS Release 12.0 or 12.1 Using Database 11gR2 (文件 ID 1311487.1)