Migration Of An Oracle Database Across OS Platforms [ID 733205.1]
In this Document
Applies to:
Oracle Server - Enterprise Edition - Version 8.1.7.4 to 11.2.0.3 [Release 8.1.7 to 11.2]Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 8.1.7.4 to 11.2.0.3
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
Fix
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 required
- Transportable Tablespaces 10G or Later
- RMAN Convert Database functions. 10G or Later
- Streams Replication
- Create Table As Select (CTAS)
- Dataguard Heterogeneous Primary and Physical Standbys
- 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'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:
- Datatype Restrictions
- Performance
The following are a list of notes to assist users in deciding which process will work best for them.
Notes:
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 SizesNOTE:1401921.1 - Cross-Platform. Database Migration (across same endian) using RMAN Transportable Database
NOTE:1389592.1 - Reduce Transportable Tablespace Downtime using Cross Platform. Incremental Backups
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 Data Pump and Import DataPump FAQ
|
|
- Oracle Database Products > Oracle Database > Oracle Database > Oracle Database - Enterprise Edition > Transportable Tablespaces
- Oracle Database Products > Oracle Database > Oracle Database > Oracle Database - Enterprise Edition > Export
- Oracle Database Products > Oracle Database > Oracle Database > Oracle Database - Enterprise Edition > Migration issues
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-753212/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 10g : Transportable Tablespaces Across Different Platforms [ID 243304.1]ROSPlatform
- 10g+: Transportable Tablespaces Across Different Platforms [ID 243304.1]ROSPlatform
- How to Move Tablespaces Across Platforms Using Transportable Tablespaces With RMAN [ID 371556.1]ROSPlatform
- Guide to Database Migration from Microsoft SQL Server using MySQL WorkbenchGUIIDEDatabaseROSServerMySql
- Supported Platforms: MySQL Database MySQL安裝支援的平臺PlatformMySqlDatabase
- Master Note of Linux OS Requirements for Database Server [ID 851598.1]ASTLinuxUIREMDatabaseServer
- Oracle identifiers :Database NameOracleIDEDatabase
- Master Note of Linux OS Requirements for Database Server (Doc ID 851598.1)ASTLinuxUIREMDatabaseServer
- How to move progress database to different OSDatabase
- Oracle identifiers :Global database nameOracleIDEDatabase
- Oracle Recommended Patches -- Oracle Database [ID 756671.1]OracleDatabase
- Oracle RAC Technologies Certification Matrix for Microsoft Windows PlatformsOracleROSWindowsPlatform
- new feature ——>mysql to oracle MigrationMySqlOracle
- How to Copy ASM Files Across Nodes [ID 1147859.1]ASMROS
- oracle database VLDB and pratitioning guideOracleDatabaseGUIIDE
- Oracle Migration Workbench - Part Two(轉載)Oracle
- oracle10g_rman_cross os_同位元組序_convert databaseOracleROSDatabase
- What is the Impact on the Database When Modifying the OS DateDatabase
- 用匯入匯出誇平臺遷移所有資料( Move a Database Between Platforms)DatabasePlatform
- Oracle DataGuard Standby database ID mismatch錯誤OracleDatabase
- Administrative User Accounts Provided by Oracle DatabaseIDEOracleDatabase
- Identifying Your Oracle Database Software Release (21)IDEOracleDatabase
- Transportable Tablespaces (TTS) for Oracle Database [ID 1461278.2]TTSOracleDatabase
- [Database Migration] 記一次未達預期的資料庫遷移Database資料庫
- Oracle Database Compression 3 - Hybrid Columnar CompressionOracleDatabase
- Oracle10G RMAN Database Duplication (Doc ID 259694.1)OracleDatabase
- oracle database backup and recovery user's guide part IVOracleDatabaseGUIIDE
- oracle database backup and recovery user's guide part IIIOracleDatabaseGUIIDE
- Oracle Database Upgrade Path Reference List [ID 730365.1]OracleDatabase
- PSU下載 - Oracle Recommended Patches -- Oracle Database (文件 ID 756671.1)OracleDatabase
- oracle效能診斷例項-row migration and row chainOracleAI
- Oracle Database Cloud - Database as a Service Quick StartOracleDatabaseCloudUI
- Types of Oracle Database Users : Database Users (6)OracleDatabase
- The database owner SID recorded in the master database differs from the database owner SID recorded in database 'DB_NAME'DatabaseAST
- Oracle clone databaseOracleDatabase
- ORACLE database vaultOracleDatabase
- Oracle Database HistoryOracleDatabase
- Oracle Database ReplayOracleDatabase