Shulou(Shulou.com)06/01 Report--

Migration Of An Oracle Database Across OS Platforms (Generic Platform) (document 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 SizesSOLUTION

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:

Export / Import to include the use of Datapump facilities. All versions support Export/Import but for Datapump 10.1.0.2 or higher is requiredTransportable Tablespaces 10G or LaterRMAN Convert Database functions. 10G or LaterRMAN DuplicateStreams ReplicationCreate Table As Select (CTAS) Dataguard Heterogeneous Primary and Physical StandbysOracle 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_NAMEENDIAN_FORMATOracle Solaris on SPARC (32-bit & 64-bit) BigAIX-Based Systems (64-bit) BigHP-UX (64-bit) BigHP-UX IA (64-bit) BigIBM zSeries Based LinuxBigApple Mac OSBigIBM Power Based LinuxBigHP Tru64 UNIXLittleLinux IA (32-bit & 64-bit) LittleHP Open VMSLittleMicrosoft Windows IA (32-bit & 64-bit) LittleOracle Solaris on x86 & x86-64LittleLinux 64-bit for AMDLittleMicrosoft Windows 64-bit for AMDLittleThe following is the basic information for using Transportable Tablespaces:

Create an "empty" database in the new environmentPlug in all data tablespaces from source to target databaseSYSTEM+SYSAUX tablespaces can't be transportedAdditional steps necessary to move views, synonyms etc.Possibly very fast upgradeComplexity could be constrainingWorks 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 itSynchronize it with the source databaseMinimal downtime: Just reconnecting the clientsWorks Across platformsCross version since Oracle 9iR2Some effort necessary to set it upFallback possible since source untouchedPotential Issues include:Datatype RestrictionsPerformance

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 DataPump Between Different Oracle Versions

Note.556636.1 Oracle Server-Export DataPump 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#CIHJBIAAREFERENCESNOTE: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 DataPump 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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.