Re: RMAN convert 5TB db on Linux (Little Endian) to AIX (Big Endian) - alternatives?

From: Guenadi Jilevski <gjilevski_at_gmail.com>
Date: Tue, 6 Mar 2012 17:29:29 +0200
Message-ID: <CADFytLj9qw0goQ3qV=ji1jJZ1Nb=WZ94BP5X_29vTMbF=O3M0A_at_mail.gmail.com>



Hi,
You can have a data pump solution as well.

http://download.oracle.com/otndocs/products/database/enterprise_edition/utilities/pdf/oow2011_dp_mastering.pdf

Best Regards,

Guenadi Jilvski

On Tue, Mar 6, 2012 at 5:17 PM, Taylor, Chris David < ChrisDavid.Taylor_at_ingrambarge.com> wrote:

> I was asked about converting a 5 TB 10.2 database on RHEL to a 11.2
> database on AIX.
> As I was thinking through this, I understand that to do the conversion
> from Linux to AIX the database would have to be at the same version. So,
> I'd either have to upgrade prior to moving, or after. Then I was thinking
> about the RMAN conversion speed to convert from little endian to big endian
> and I think I would have a problem due to the time required.
>
> I don't have access to the exact I/O throughput on the system but if I can
> convert 4 GB in 14 minutes (stats taken from a white paper) through RMAN,
> that's close to 1/3 GB per minute. So I could do 1 GB = 3 minutes. (Should
> I expect more than 1/3 GB per minute?)
>
> So, if I have 1 TB (approx. 1000GB) that would 3000 minutes. Now if I
> have 5 TB, that's 15,000 MINUTES (!) to convert through RMAN.
>
> Is that really my only option (or best option anyway)?
>
> What other options should I explore?
>
>
>
> Chris Taylor
>
> "Quality is never an accident; it is always the result of intelligent
> effort."
> -- John Ruskin (English Writer 1819-1900)
>
> Any views and/or opinions expressed herein are my own and do not
> necessarily reflect the views of Ingram Industries, its affiliates, its
> subsidiaries or its employees.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 06 2012 - 09:29:29 CST

Original text of this message