资讯

精准传达 • 有效沟通

从品牌网站建设到网络营销策划,从策略到执行的一站式服务

Oracle官方推荐的数据迁移方式评估

Migration Of An Oracle Database Across OS Platforms (Generic Platform) (文档 ID 733205.1)

APPLIES TO:

Oracle Database - Enterprise Edition - Version 8.1.7.4 and later
Information in this document applies to any platform.

GOAL

成都创新互联公司-成都网站建设公司,专注网站制作、成都网站制作、网站营销推广,空间域名,网络空间,网站改版维护有关企业网站制作方案、改版、费用等问题,请联系成都创新互联公司

To migrate an existing Oracle database (NOT BINARIES)  from one Operating System platform to another (i.e. Windows to Solaris) 
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). 

Changes 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. 

For details please refer to the appropriate migration manual or 

NOTE:62290.1" alt="62290.1" title="62290.1" target="_blank">62290.1> - Changing between 32-bit and 64-bit Word Sizes 

SOLUTION

There is no migration utility (Script or DBUA) to perform a cross platform migration of an Oracle Database.

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 Datapump 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. RMAN Duplicate
  5. Streams Replication
  6. Create Table As Select (CTAS)
  7. Dataguard Heterogeneous Primary and Physical Standbys
  8. Oracle Golden Gate (For assistance with Oracle Golden Gate, an SR needs opened with the correct team)

Each 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 destination.

For example: 

There are platform limitations when using Dataguard Heterogeneous Primary and Physical Standbys

For more information please refer to Note: 413484.1 Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration

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

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

          For more infomaiton on RMAn Duplicate please refer to Note: 1079563.1 RMAN DUPLICATE/RESTORE/RECOVER Mixed Platform Support 1079563.1

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

These two commands ARE NOT the same.  Please refer to the notes at the end of the document for the correct note needed.

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

The following is the basic information for using Transportable Tablespaces:

  • Create an "empty" database in the new environment
  • Plug in all data tablespaces from source to target database
  • SYSTEM+SYSAUX tablespaces can't be transported
  • Additional steps necessary to move views, synonyms etc.
  • Possibly very fast upgrade
  • Complexity could be constraining
  • Works cross-platform and cross-Endianness since Oracle Database 10g


The following is the basic information for using Oracle Streams in an upgrade:

  • Build up a copy of your database and upgrade it
  • Synchronize it with the source database
  • Minimal downtime:  Just reconnecting the clients
  • Works Across platforms
  • Cross version since Oracle 9iR2
  • Some effort necessary to set it up
  • Fallback possible since source untouched
  • Potential Issues include:
  1. Datatype Restrictions
  2. Performance


The following are a list of notes to assist users in deciding which process will work best for them.

Notes:

Note.553337.1 Export/Import DataPump Parameter VERSION - Compatibility of Data Pump Between Different Oracle Versions 
Note.556636.1 Oracle Server - Export Data Pump and Import DataPump FAQ 
Note.351598.1 Export/Import DataPump The Minimum Requirements to Use Export DataPump and Import DataPump (System Privileges) 

Note.243304.1 10g : Transportable Tablespaces Across Different Platforms 
Note:371556.1  How move tablespaces across platforms using Transportable Tablespaces with RMAN
Note: 413484.1 Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration
Oracle Streams Concepts and Administration: Appendix D 
http://download.oracle.com/docs/cd/E11882_01/server.112/e17069/ap_strmnt.htm#CIHJBIAA

REFERENCES

NOTE:62290.1 - Changing between 32-bit and 64-bit Word Sizes
NOTE:1401921.1 - Cross-Platform Database Migration (across same endian) using RMAN Transportable Database
NOTE:1389592.1 - 11G - Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup
NOTE:243304.1 - 10g+: Transportable Tablespaces Across Different Platforms
NOTE:351598.1 - Export/Import DataPump: The Minimum Requirements to Use Export DataPump and Import DataPump (System Privileges)
NOTE:371556.1 - How to Migrate to different Endian Platform Using Transportable Tablespaces With RMAN
NOTE:413484.1 - Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration
NOTE:553337.1 - Export/Import DataPump Parameter VERSION - Compatibility of Data Pump Between Different Oracle Versions [Video]
NOTE:556636.1 - Oracle Server - Export DataPump and Import DataPump FAQ
NOTE:1377213.1 - R11i / R12: Oracle E-Business Suite Upgrades and Platform Migration
NOTE:1133355.1 - Migrating an Oracle E-Business Suite Database to Oracle Exadata Database Machine
NOTE:1079563.1 - RMAN DUPLICATE/RESTORE/RECOVER Mixed Platform Support
分享标题:Oracle官方推荐的数据迁移方式评估
文章源于:http://www.cdkjz.cn/article/joeiii.html
多年建站经验

多一份参考,总有益处

联系快上网,免费获得专属《策划方案》及报价

咨询相关问题或预约面谈,可以通过以下方式与我们联系

大客户专线   成都:13518219792   座机:028-86922220