Oracle cross-operating systems migration with minimal down time

Greetings morsy.  This is a post dated 12/2010, with the title:Oracle/HP-UX migration to Vblock that may help.  As you can see, there is no easy way. You can read the threads by searchin on the title.

Nick

Sep 13, 2011 9:46 PM (in response to Sam Lucido)

  Re: Oracle/HP-UX migration to Vblock     

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)
6. 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.

FYI: Informatica has acquired Wisdomforce who have a similar tool as Golden Gate (probably much less expensive).

http://www.wisdomforce.com/products-DatabaseSync.html

Not sure where the differences are but people who have to deal with migration issues might want to check it out.

Hi Morsy,

If your customer is using EMC Symm system, you could consider using Open Replicator with Transportable Tablespaces to migrate your existing data.

Here is the whitepaper for your reference. https://community.emc.com/docs/DOC-11895

Thanks,

Eddy