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

From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Tue, 6 Mar 2012 21:41:01 +0100
Message-ID: <CALH8A92reAkqKMoOqLBo4Le0GfkCCuW8RnTPC1TKXxz_s9kmRQ_at_mail.gmail.com>



Chris,
You must get valuable tests from any of your systems. As the "CONVERT" command in RMAN can be per datafile, you can run multiple RMANs in parallel. Just find out if you first saturate IOs or CPU. Maybe this can reduce your 15.000 minutes a little bit.

Martin

On Tue, Mar 6, 2012 at 16:17, 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 - 14:41:01 CST

Original text of this message