Oracle 跨操作系统 迁移 说明.docx

关于跨OS 的DB 迁移,MOS 上有相关的文章说明:[ID ]。
To migrate an existing Oracle database (NOT BINARIES)  from one Operating System platform to another (. Windows to Solaris) ,This can occur as part of an Oracle version upgrade (Oracle 8i .. Oracle 11G) or within the same Oracle version: (Oracle to Oracle ). 
--可以将Oracle DB 从一个操作系统迁移到另一个操作系统,比如从windows到Solaris,注意这里的迁移仅仅是数据的迁移,不包含DB 的安装介质。这个迁移可以是不同DB版本的迁移,比如从8i 到11g,也可以是相同版本的迁移, .
Changes within an Operating System (ie: Linux,Windows or Solaris from 32 bit to 64 bit) are not considered cross platform migrations and are performed as normal version upgrades/wordsize conversions. 
--改变操作系统不用考虑系统的平台,可以按照正常的db version upgrades 和 wordsize 的改变来操作。
1解决方法
There is no migration utility (Script or DBUA) to perform a cross platform migration of an Oracle Database.
--没有迁移工具如脚本或者DBUA来执行跨OS的数据迁移。
Changing platforms requires the database be re-built and / or the data moved using one of the following methods:
--跨平台的迁移需要重建数据库,然后使用如下的一种方法来完成数据的迁移工作。
Export / Import to include the use of Datapump facilities. All versions support Export/Import but for Datapump or higher is required
Transportable Tablespaces 10G or Later
RMAN Convert Database functions. 10G or Later
Streams Replication
Create Table As Select (CTAS)
Dataguard Heterogeneous Primary and Physical Standbys
Oracle Golden Gate
Each available choice w