《Oracle 跨操作系统 迁移 说明》由会员分享,可在线阅读,更多相关《Oracle 跨操作系统 迁移 说明(5页珍藏版)》请在金锄头文库上搜索。
1、David Dai 学习 Oracle Blog: http:/ 群:62697716(满); DBA2 群:62697977(满); DBA3 群:62697850; DBA 超级群:63306533(满) DBA4 群:83829929 DBA5 群:142216823关于跨 OS 的 DB 迁移,MOS 上有相关的文章说明:ID 733205.1。To migrate an existing Oracle database (NOT BINARIES) from one Operating System platform to another (i.e. Windows to Solar
2、is) ,This can occur as part of an Oracle version upgrade (Oracle 8i . Oracle 11G) or within the same Oracle version: (Oracle 10.2 to Oracle 10.2). -可以将 Oracle DB 从一个操作系统迁移到另一个操作系统,比如从 windows 到 Solaris,注意这里的迁移仅仅是数据的迁移,不包含 DB 的安装介 质。这个迁移可以是不同 DB 版本的迁移,比如从 8i 到 11g,也可以是相同版 本的迁移,比如从 10.2 到 10.2.Changes
3、 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
4、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: -跨平台的迁移需要重建数据库,然后使用如下的一种方法来完成数据的迁 移工作。 (1) Export / Import to include the use of Data
5、pump facilities. All versions support Export/Import but for Datapump 10.1.0.2 or higher is required (2) Transportable Tablespaces 10G or Later (3) RMAN Convert Database functions. 10G or Later (4) Streams Replication (5) Create Table As Select (CTAS) (6) Dataguard Heterogeneous Primary and Physical
6、Standbys (7) Oracle Golden GateEach available choice will have strengths and limitations to include data types, time required and potential costs. -每一个可选的方法都有它的优势和限制,如数据类型,需要的时间和一些 潜在的消耗。The choices available will depend on BOTH the Operating System and Oracle versions on both the source and destina
7、tion. David Dai 学习 Oracle Blog: http:/ 群:62697716(满); DBA2 群:62697977(满); DBA3 群:62697850; DBA 超级群:63306533(满) DBA4 群:83829929 DBA5 群:142216823-方法是否可用也取决与 Source 和 Destination 两端的操作系统和 Oracle 版本。2 示例There are platform limitations when using Dataguard Heterogeneous Primary and Physical Standbys。 -比如使
8、用 DG 的异构平台来迁移时,就会有操作系统的限制。 关于这块 内容,之前有详细的 Blog: Oracle Data Guard 支持的异构平台 说明 http:/ Convert Database only works if both source and destination belong to the same ENDIAN format. -RMAN Convert DB 仅在 source 和 destination 的 ENDIAN 格式相同的情 况下才可以使用。 RMANs convert function for Transportable Tablespaces will
9、 convert from one ENDIAN format to another. 在 ENDIAN 格式不同的情况下,可以使用 RMAN convert function 来转换 ENDIAN 从一种格式到另一种格式。如:RMAN convert tablespace TBS1 to platform=“Linux IA (32-bit)“ FORMAT /tmp/%U;两端相同之后,就可以进行 Transportable tablespace 的操作。可以通过 v$transportable_platform 视图查看系统的 ENDIAN 格式: SQL column platform
10、_name format a35 SQL select * from v$transportable_platform order by 1;PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT - - -1 Solaristm OE (32-bit) Big2 Solaristm OE (64-bit) Big3 HP-UX (64-bit) Big4 HP-UX IA (64-bit) Big5 HP Tru64 UNIX Little6 AIX-Based Systems (64-bit) Big7 Microsoft Windows IA (32-bit) L
11、ittle8 Microsoft Windows IA (64-bit) Little9 IBM zSeries Based Linux Big10 Linux IA (32-bit) Little11 Linux IA (64-bit) LittleDavid Dai 学习 Oracle Blog: http:/ 群:62697716(满); DBA2 群:62697977(满); DBA3 群:62697850; DBA 超级群:63306533(满) DBA4 群:83829929 DBA5 群:14221682312 Microsoft Windows x86 64-bit Littl
12、e13 Linux x86 64-bit Little15 HP Open VMS Little16 Apple Mac OS Big17 Solaris Operating System (x86) Little18 IBM Power Based Linux Big19 HP IA Open VMS Little20 Solaris Operating System (x86-64) Little21 Apple Mac OS (x86-64) Little20 rows selected.1.2.1 The following is the basic information for u
13、sing Transportable Tablespaces: -使用 Transport Tablespace 的步骤: (1) Create an “empty“ database in the new environment (2) Plug in all data tablespaces from source to target database (3) SYSTEM+SYSAUX tablespaces cant be transported (4) Additional steps necessary to move views, synonyms etc. (5) Possib
14、ly very fast upgrade (6) Complexity could be constraining (7) Works cross-platform and cross-Endianness since Oracle Database 10g1.2.2 The following is the basic information for using Oracle Streams in an upgrade: -使用 Oracle Streams 的步骤: (1) Build up a copy of your database and upgrade it (2) Synchronize it with the source database (3) Minimal downtime: Just reconnecting the clients (4) Works Across platforms (5) Cross version since Oracle 9iR2 (6) Some effort necessa