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

From: Taylor, Chris David <ChrisDavid.Taylor_at_ingrambarge.com>
Date: Tue, 6 Mar 2012 11:16:04 -0600
Message-ID: <C5533BD628A9524496D63801704AE56D6ADD51C341_at_SPOBMEXC14.adprod.directory>



RMAN conversion *can* do little to big - you have to build the shell database on the target server first. I had researched that part already in blogs and in the Oracle Database Backup and Recovery Advanced Users Guide (I believe it was).

Thanks Norman - much appreciated!

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.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Norman Dunbar Sent: Tuesday, March 06, 2012 11:11 AM
To: oracle-l_at_freelists.org
Subject: Re: RMAN convert 5TB db on Linux (Little Endian) to AIX (Big Endian) - alternatives?

Hi Chris,

On 06/03/12 15:17, Taylor, Chris David wrote:
> I was asked about converting a 5 TB 10.2 database on RHEL to a 11.2 database on AIX.
I've just completed a conversion of a 6.5 Tb database on HPuX to Linux using transportable tablespaces. Worked fine for me. However, are your servers the same endienness? Mine were, but I'm not sure you can do TTs across different endians. (Note to self, check the manual!)

> 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 got a conversion rate, using RMAN on the destination server, of 2 GB every 20 seconds.

if you can't do little->big endian conversions, you may well be resorting to data pump or exp/imp I'm afraid. Good luck with that for the size of your database.

Cheers,
Norm.

--
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767
--
http://www.freelists.org/webpage/oracle-l




--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 06 2012 - 11:16:04 CST

Original text of this message