Skip to main content
Start a Conversation

This post is more than 5 years old

Solved!

Go to Solution

Broche1

3 Posts

1456

September 13th, 2011 02:00

Oracle/HP-UX migration to Vblock

Hi Oracle Community,

Does anyone out there have experience of migrating HP/UX Oracle on itanium to an x86 environment with Linux/Windows?

Anything experience / information would be greatly appreciated.

Cheers,

Brian

slucido

109 Posts

September 13th, 2011 07:00

Brian,

"Cross-Platform Oracle Database Migration Using Transportable Tablespaces and EMC Open Replicator for Symmetrix" is an excellent use case by EMC that was created in 2008. Use this link for the use case:

https://community.emc.com/search.jspa?resultTypes=&dateRange=all&peopleEnabled=true&q=_1_oracle_solutions+transportable&containerType=14&container=2857&containerName=Everything+Oracle+at+EMC&username=&rankBy=relevance&numResults=30

Hope that helps!

Anonymous

5 Practitioner

 • 

274.2K Posts

September 13th, 2011 18:00

Hi Sam,

please see guidance from metalink (733205.1):

There is no Migration utility (Script or DBUA) to perform a cross platform migration.

To change platforms require the database instance 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. Streams Replication
  5. Create Table As Select (CTAS)
  1. Oracle Golden Gate

I’ve used tts, rman convert (in conjunction with tts), materialized views, CTAS and a whole bunch of scripts depending on how big the db is, what’s the downtime window allowed, what version and environment for the source and destination.

For the CTAS or even the insert/update with parallel hints approach, this may require some tuning to attain the performance you needed and of course, you need to factor in some items as index rebuilds, clean up of transient data etc.

I even tried using shareplex before but it didn’t quite work out as expected. We had issues with the replicating throughput being unable to catch up at that time with the incoming transactions. so we reverted with the old fashion scripting using MV, ctas etc.

Since this is a cross platform, you’re practically left with options 1,2,4,5 and of course 6 (or some similar CDC software).

Hope I was able to help a bit.

zhaos2

643 Posts

September 14th, 2011 00:00

Hello Sam

The below link of the document from CISCO is a real case of Migrating Oracle & SAP from HP-UX (Itanium) to CISCO UCS (x86). 

http://www.cisco.com/web/about/ciscoitatwork/data_center/docs/Cisco_IT_Case_Study_OracleMigrationtoUCS.pdf

Source Environment:

3000 users on SAP/Oracle RAC 10g

HP-UX Itanium server

Target Environment:

Oracle RAC 11g

Cisco UCS 5700

The document described general process and some guidelines of:

  • Migrating & upgrading Oracle from HP-UX to Cisco UCS
  • Migrating SAP ERP from HP-UX to UCS

Hope it will be also helpful for Vblock migration. 

Regards!

Simon Zhao

View More

View All

No Events found!

Top