Re: Cross-platform (different endianness) Migration Experiences

From: Paul G Parker <>
Date: Wed, 28 Apr 2010 21:58:24 -0400
Message-ID: <>


I've just (this past weekend) migrated a 1.8TB database from AIX (big) to Linux (little) from (32-bit) to (64-bit). We used RMAN CONVERT / transportable tablespaces and the main migration piece took about 9 hours. The tablespaces need to be in read-only mode during the migration, but since we could afford the downtime, that method worked for us. It was fairly easy to setup, but we practiced the migration a few times before implementation, so it went smoothly.

We ran into a nasty bug "Bug 7251049 - Corruption in bitmap index introduced when using transportable tablespaces [ID 7251049.8]" - with the work-around being to drop and re-create the bitmap indexes - so factor that in if using bitmap indexes.

Hope this helps

On Thu, Apr 22, 2010 at 10:40 AM, fmhabash <> wrote:
> Just wanted to tap into this group resources for real-life experiences
> migrating large databases across OS platform and across different
> endianness. I'm looking for ...
> - What approach did you use (rman conversion (transportable ts / database),
> oracle streams, 3rd patry tools).
> - Timing (size of database) and elapsed migration time
> - How was the overall experience using streams?
> Thank you.
> --

Received on Wed Apr 28 2010 - 20:58:24 CDT

Original text of this message