關于跨OS 的DB 遷移，MOS 上有相關的
文章說明：[ID733205.1]。
To migrate anexisting
Oracle database (NOT BINARIES) from one Operating Systemplatform to another (i.e.
Windows to Solaris) ,This can occur as part ofan Oracle version upgrade (Oracle 8i .. Oracle 11G) or within the sameOracle version: (Oracle 10.2 to Oracle 10.2).
--可以將Oracle DB 從一個
操作系統遷移到另一個操作系統，比如從windows到Solaris，注意這里的遷移僅僅是數據的遷移，不包含DB 的安裝介質。這個遷移可以是不同DB版本的遷移，比如從8i 到11g，也可以是相同版本的遷移，比如從10.2 到10.2.
Changes withinan Operating System (ie:
Linux,Windows or Solaris from 32 bit to 64 bit) arenot considered cross platform migrations and are performed as normal versionupgrades/wordsize conversions.
--改變操作系統不用考慮系統的平臺，可以按照正常的db version upgrades 和 wordsize 的改變來操作。
一. 解決方法
There is no migrationutility (Script or DBUA) to perform a cross platform migration of an OracleDatabase.
--沒有遷移工具如腳本或者DBUA來執行跨OS的數據遷移。
Changingplatforms requires the database be re-built and / or the data moved using oneof the following methods:
--跨平臺的遷移需要重建
數據庫，然后使用如下的一種方法來完成數據的遷移
工作。
(1) Export / Import to include theuse of Datapump facilities. All versions support Export/Import but for Datapump10.1.0.2 or higher is required
(2) Transportable Tablespaces 10Gor Later
(3) RMAN Convert Databasefunctions. 10G or Later
(4) Streams Replication
(5) Create Table As Select (CTAS)
(6) Dataguard Heterogeneous Primaryand Physical Standbys
(7) Oracle Golden Gate
Each availablechoice will have strengths and limitations to include data types, time requiredand potential costs.
--每一個可選的方法都有它的優勢和限制，如數據類型，需要的時間和一些潛在的消耗。
The choicesavailable will depend on BOTH the Operating System and Oracle versions on boththe source and destination.
--方法是否可用也取決與Source 和 Destination 兩端的操作系統和Oracle版本。
二. 示例
There areplatform limitations when using Dataguard Heterogeneous Primary and PhysicalStandbys。
--比如使用DG的異構平臺來遷移時，就會有操作系統的限制。 關于這塊內容，之前有詳細的Blog：
Oracle DataGuard 支持的異構平臺 說明
http://blog.csdn.net/tianlesoftware/article/details/7241488
RMAN ConvertDatabase only works if both source and destination belong to the same ENDIANformat.
--RMAN Convert DB 僅在source 和destination 的ENDIAN 格式相同的情況下才可以使用。
RMAN's convertfunction for Transportable Tablespaces will convert from one ENDIAN format toanother.
在ENDIAN 格式不同的情況下，可以使用RMAN convert function 來轉換ENDIAN 從一種格式到另一種格式。如：
RMAN> convert tablespace TBS1 to platform="Linux IA(32-bit)" FORMAT '/tmp/%U';
兩端相同之后，就可以進行Transportabletablespace 的操作。
可以通過v$transportable_platform視圖查看系統的ENDIAN 格式：
SQL> columnplatform_name format a35 SQL> select *from v$transportable_platform order by 1; PLATFORM_IDPLATFORM_NAME ENDIAN_FORMAT ---------------------------------------------- -------------- 1 Solaris[tm] OE (32-bit) Big 2 Solaris[tm] OE (64-bit) Big 3 HP-UX (64-bit) Big 4 HP-UX IA (64-bit) Big 5 HP Tru64 UNIX Little 6 AIX-Based Systems (64-bit) Big 7 Microsoft Windows IA (32-bit) Little 8 Microsoft Windows IA (64-bit) Little 9 IBM zSeries Based Linux Big 10 Linux IA (32-bit) Little 11 Linux IA (64-bit) Little 12 Microsoft Windows x86 64-bit Little 13 Linux x86 64-bit Little 15 HP Open VMS Little 16 Apple Mac OS Big 17 Solaris Operating System (x86) Little 18 IBM Power Based Linux Big 19 HP IA Open VMS Little 20 Solaris Operating System(x86-64) Little 21 Apple Mac OS (x86-64) Little 20 rowsselected. |