暂无图片
暂无图片
暂无图片
暂无图片
暂无图片
如何利用 RMAN 可传输表空间迁移数据库到不同字节序的平台 (Doc ID 1983639.1)
1074
12页
11次
2020-03-10
5墨值下载
2020/3/3 Document 1983639.1
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=164452325508689&parent=DOCUMENT&sourceId=1533057.1&id=1983639.1&_afrWindowMode=0&_adf.ctrl-state=axinrw019_1001 1/12
PowerView is Off
(0)
Zhi Yuan (Available) Contact Us Help
Copyright (c) 2020, Oracle. All rights reserved. Oracle Confidential.
适用于:
Oracle Database Cloud Schema Service - 版本 N/A 和更高版本
Oracle Database Exadata Cloud Machine - 版本 N/A 和更高版本
Oracle Cloud Infrastructure - Database Service - 版本 N/A 和更高版本
Oracle Database Cloud Exadata Service - 版本 N/A 和更高版本
Oracle Database Exadata Express Cloud Service - 版本 N/A 和更高版本
本文档所含信息适用于所有平台
******************* 警告 *************
Document 1334152.1 Corrupt IOT when using Transportable Tablespace to HP from different OS
Document 13001379.8 Bug 13001379 - Datapump transport_tablespaces produces wrong dictionary metadata for some tables
目标
Oracle 10g ASM OS
使
1.-
2.-
3.-
4.-
5.- 使 RMAN
6.-
7.-
MAA 白皮书利用表空间传输实现平台迁移请参考:
Was this document helpful?
Document Details
Type:
Status:
Last Major
Update:
Last Update:
Language:
HOWTO
PUBLISHED
04-Aug-2018
22-Feb-2019
简体中文
Related Products
Oracle Database - Enterprise
Edition
Oracle Database Cloud Schema
Service
Gen 1 Exadata Cloud at
Customer (Oracle Exadata
Database Cloud Machine)
Oracle Cloud Infrastructure -
Database Service
Oracle Database Cloud Exadata
Service
Show More
Information Centers
Information Center: Overview
Database Server/Client
如何利用 RMAN 可传输表空间迁移数据库到不同字节序的平台 (Doc ID 1983639.1)
To Bottom
Yes
No
Give Feedback...
2020/3/3 Document 1983639.1
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.412c 之后,如果要转换到 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
of 12
5墨值下载
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文档的来源(墨天轮),文档链接,文档作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论

关注
最新上传
暂无内容,敬请期待...
下载排行榜
Top250 周榜 月榜