Migrating an Oracle E-Business Suite Database to Sun Oracle Database Machine(Exadata)
為配合工作需要,提前在普通的環境上(非EXADATA)做了一個簡單測試,
理論上平臺遷移要比EBS 升級簡單的N多,只要技術上不會問題,功能上應該關聯不大,但可能會出現效能問題..
迄今為止:EBS 11i or R12 ,不跨平臺就基本上沒多大問題了,方法也很多,但跨平臺遷移還是有一定的限制的,如:Transportable Tablespaces 還沒有對R12 on DBMS11.2 的環境上認證,
個人的經驗,可以使用的遷移方法很多,不區分跨不跨平臺的話:
- Storage Flash copy
- Storage Shadow - immage
- Veritas/TSM or Other backup to tape(RMAN)
- 直接tar ,cp -iH,cpio ,NFS等等
- 物理DG
- exp/imp, expdp/impdp
- Transportable Database
-Transportable Tablespaces (Only 11i, R12 on DBMS11.2 not certified)
- 其他非正規方法等等(ASM...DISK. 呵呵.)
測試環境:
IBM AIX6.1 + EBS R12.1.1(64bit)(11.1.0.7 DB)
Oracle Linux EE5.5 (64bit)
移植方向:
1.遷移AIX 上只是EBS DB 遷移到LINUX
2. 遷移AIX 上全部(DB+AP)EBS 遷移到Linux
只是採用了expdp/impdp 的方式進行了測試,採用這個方式整體來說問題還不是很多,但會在前期準備環境和檢查環境以及後來建庫,配置EBS 相關的時候會出現問題...
[@more@]來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7318139/viewspace-1039777/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle Exadata Database MachineOracleDatabaseMac
- 【轉Exadata】Exadata V2 Oracle-Sun Database Machine資料庫一體機OracleDatabaseMac資料庫
- HP ORACLE DATABASE MACHINEOracleDatabaseMac
- 11gR2 11.2.0.2 Database Certified with E-Business SuiteDatabaseUI
- Oracle推出了硬體產品——HP ORACLE DATABASE MACHINEOracleDatabaseMac
- Oracle Database, Application Server, and Collaboration Suite DocumentationOracleDatabaseAPPServerUI
- Mini版Exadata釋出——Oracle Database ApplianceOracleDatabaseAPP
- Migrating Oracle10g Database to Automatic Storage management (ASM)OracleDatabaseASM
- Tuning the Oracle E-Business Suite R12OracleUI
- Oracle Database Cloud - Database as a Service Quick StartOracleDatabaseCloudUI
- Types of Oracle Database Users : Database Users (6)OracleDatabase
- Oracle clone databaseOracleDatabase
- ORACLE database vaultOracleDatabase
- Oracle Database HistoryOracleDatabase
- Oracle Database ReplayOracleDatabase
- alter database in OracleDatabaseOracle
- Oracle Database ScriptOracleDatabase
- Oracle Database ServiceOracleDatabase
- Step By Step Instructions on Migrating Oracle10g Database to Automatic Storage management (ASM)StructOracleDatabaseASM
- Oracle Physical Database LimitsOracleDatabaseMIT
- Oracle sharding databaseOracleDatabase
- Oracle Database Resource ManagerOracleDatabase
- Oracle Database Scheduler整理OracleDatabase
- oracle full database backupOracleDatabase
- Oracle Active database duplicationOracleDatabase
- Oracle Database Memory StructuresOracleDatabaseStruct
- Oracle database buffer cacheOracleDatabase
- Oracle Database In-MemoryOracleDatabase
- oracle rat database replayOracleDatabase
- Oracle database instanceOracleDatabase
- Oracle Database Internals FAQOracleDatabase
- oracle database linkOracleDatabase
- oracle 重建EM databaseOracleDatabase
- float datatype in Oracle databaseOracleDatabase
- Types of Oracle Database Users : Database Administrators (1)OracleDatabase
- 掌控 Oracle E-Business Suite 資料,驅動業務成果OracleUI
- Oracle Database Cardinality FeedbackOracleDatabase
- Secrets of the Oracle Database筆記OracleDatabase筆記