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

  • From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
  • To: 'Paul G Parker' <parkerpg@xxxxxxxxx>
  • Date: Tue, 6 Mar 2012 11:12:04 -0600

Paul - I would if I had access to the environment.  That is why I put the 
caveats in the my original email.  I have no idea 1/3 GB per minute is slow, 
average, or good.
From the look of the input I've received so far I think it is probably safe to 
assume that the throughput is faster than that on enterprise systems/enterprise 
storage.

Thanks for the stats on your 2 TB - it gives me yet another data point.


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.

From: Paul G Parker [mailto:parkerpg@xxxxxxxxx]
Sent: Tuesday, March 06, 2012 10:55 AM
To: Taylor, Chris David
Cc: Subodh Deshpande; oracle-l@xxxxxxxxxxxxx
Subject: Re: RMAN convert 5TB db on Linux (Little Endian) to AIX (Big Endian) - 
alternatives?

Chris,
I did a conversion from AIX to Linux using RMAN CONVERT about 2 years ago.
From my notes, it took us about 9 hours to convert about 2TB.
Perhaps you should do a quick benchmark in your environment rather than rely on 
others experiences?

Paul
On Tue, Mar 6, 2012 at 11:22, Taylor, Chris David 
<ChrisDavid.Taylor@xxxxxxxxxxxxxxx<mailto:ChrisDavid.Taylor@xxxxxxxxxxxxxxx>> 
wrote:
Subodh - why do you think I'm asking about alternatives? :)
Again, I don't have the stats for the server in question - I took the 4 GB in 
14 minutes from the web as an example - I have no idea what I/O to expect since 
I've never done a conversion across endians.

Thanks,

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.
From: Subodh Deshpande 
[mailto:deshpande.subodh@xxxxxxxxx<mailto:deshpande.subodh@xxxxxxxxx>]
Sent: Tuesday, March 06, 2012 10:11 AM
To: Taylor, Chris David
Cc: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
Subject: Re: RMAN convert 5TB db on Linux (Little Endian) to AIX (Big Endian) - 
alternatives?

something is wrong..Chris..15000 minutes means nearly 250 hrs..thanks and take 
care..subodh
On 6 March 2012 20:47, Taylor, Chris David 
<ChrisDavid.Taylor@xxxxxxxxxxxxxxx<mailto:ChrisDavid.Taylor@xxxxxxxxxxxxxxx><mailto:ChrisDavid.Taylor@xxxxxxxxxxxxxxx<mailto:ChrisDavid.Taylor@xxxxxxxxxxxxxxx>>>
 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.


--
//www.freelists.org/webpage/oracle-l




--
=============================================
Love me or Hate me both are in my Favour.
Love me, I am in your Heart. Hate me, I am in your Mind.
=============================================

--
//www.freelists.org/webpage/oracle-l



--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2012