ORACLE 跨平臺遷移方法

1.      Export / Import

Note.553337.1 Export/Import DataPump Parameter VERSION - Compatibility of Data Pump Between Different Oracle Versions

2.      Transportable Tablespaces 10G or Later

RMAN's convert function for Transportable Tablespaces will convert from one ENDIAN format to another.

http://blog.itpub.net/15747463/viewspace-758164/

http://blog.itpub.net/15747463/viewspace-758148/

3.      RMAN Convert Database functions. 10G or Later

RMAN Convert Database only works if both source and destination belong to the same ENDIAN format. 

http://blog.itpub.net/15747463/viewspace-772111/

4.      Streams Replication

5.      Create Table As Select (CTAS)

6.      Dataguard Heterogeneous Primary and Physical Standbys

Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration

http://blog.itpub.net/15747463/viewspace-758195/

http://blog.itpub.net/15747463/viewspace-1064644/

7.      Oracle Golden Gate 

PLATFORM_NAME	ENDIAN_FORMAT
Oracle Solaris on SPARC (32-bit & 64-bit)	Big
AIX-Based Systems (64-bit)	Big
HP-UX (64-bit)	Big
HP-UX IA (64-bit)	Big
IBM zSeries Based Linux	Big
Apple Mac OS	Big
IBM Power Based Linux	Big
HP Tru64 UNIX	Little
Linux IA (32-bit & 64-bit)	Little
HP Open VMS	Little
Microsoft Windows IA (32-bit & 64-bit)	Little
Oracle Solaris on x86 & x86-64	Little
Linux 64-bit for AMD	Little
Microsoft Windows 64-bit for AMD	Little