https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=164452325508689&parent=DOCUMENT&sourceId=1533057.1&id=1983639.1&_afrWindowMode=0&_adf.ctrl-state=axinrw019_1001 2/12
http://www.oracle.com/technetwork/database/features/availability/maa-wp-11g-platformmigrationtts-129269.pdf
从 11.2.0.4,12c 之后,如果要转换到 Linux x86-64,那么参考如下文档:
Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup [1389592.1]
解决方案
支持的平台
请查询 V$TRANSPORTABLE_PLATFORM 来查看受支持的平台,并确定每个平台的字节序。
SQL> COLUMN PLATFORM_NAME FORMAT A32
SQL> SELECT * FROM V$TRANSPORTABLE_PLATFORM;
PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT
----------- -------------------------------- --------------
1 Solaris[tm] OE (32-bit) Big
2 Solaris[tm] OE (64-bit) Big
7 Microsoft Windows IA (32-bit) Little
10 Linux IA (32-bit) Little
6 AIX-Based Systems (64-bit) Big
3 HP-UX (64-bit) Big
5 HP Tru64 UNIX Little
4 HP-UX IA (64-bit) Big
11 Linux IA (64-bit) Little
15 HP Open VMS Little
8 Microsoft Windows IA (64-bit) Little
9 IBM zSeries Based Linux Big
13 Linux 64-bit for AMD Little
16 Apple Mac OS Big
12 Microsoft Windows 64-bit for AMD Little
17 Solaris Operating System (x86) Little
如果源平台和目标平台是不同的字节序,那么必须在源平台或者目标平台上做一个额外的步骤,来转换被传输的表空间到目标格式。如果它们
是同样的字节序,那么不需要做转换,表空间可以像同平台那样传输。
传输表空间
1.
Installation and
Upgrade/Migration [1351022.2]
Index of Oracle Database
Information Centers
[1568043.2]
インフォメーション・センタ
ー: データベースおよび
Enterprise Manager 日本語ドキ
ュメント [1946305.2]
Information Center: Overview
of Database Security Products
[1548952.2]
Platform as a Service (PaaS)
and Oracle Cloud Infrastructure
(OCI) Information Center
[2048297.2]
Document References
Bug 13001379 - Datapump
transport_tablespaces produces
wrong dictionary metadata
causing errors like ORA-7445
[qeaeMinmax] / ORA-1858
etc... [13001379.8]
ALERT: Corrupt IOT when
using Transportable Tablespace
to HP from different OS
[1334152.1]
ASMCMD Copy to Convert
Endianess using RMAN fails in
11g [1324000.1]
Bug 13636964 - ORA-19563
from RMAN convert on datafile
copy transferred with
DBMS_FILE_TRANSFER
[13636964.8]
Dbms_file_transfer Corrupts
Dbf File When Copying
between endians [1262965.1]
Show More
评论