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

Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration [ID 413484.1] Data Guard Support for Heterogeneous Primary and Logical Standbys in Same Data Guard Configuration [ID 1085687.1]

HTH Michael Dinh
Disparity Breaks Automation (DBA)

Great minds discuss ideas; average minds discuss events; small minds discuss people - Eleanor Roosevelt  Confidence comes not from always being right but from not fearing to be wrong - Peter T Mcintyre  
-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Taylor, Chris David Sent: Tuesday, March 06, 2012 11:35 AM
To: 'rodrigo_at_mufalani.com.br'
Cc: 'oracle-l_at_freelists.org'
Subject: RE: RMAN convert 5TB db on Linux (Little Endian) to AIX (Big Endian) - alternatives?

That would be interesting if that would have worked, but AIX is one of the platforms where that won't work it appears. Thanks again though

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: Rodrigo Mufalani [mailto:rodrigo_at_mufalani.com.br] Sent: Tuesday, March 06, 2012 11:05 AM
To: Taylor, Chris David
Cc: 'oracle-l_at_freelists.org'
Subject: Re: RMAN convert 5TB db on Linux (Little Endian) to AIX (Big Endian) - alternatives?

Hi Chris,

  Did you thougth about heterogeneous dataguard? Please check the Mike Dietrich's blog post at https://blogs.oracle.com/UPGRADE/entry/cross-platform_migration_using

  Check MOSC Note ID 413484.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=BULLETIN&idA3484.1

Best Regards,

Rodrigo Mufalani
Oracle Ace Member
http://www.mufalani.com.br
[http://mufalani.com.br/site/wp-content/uploads/2012/01/logo.png]

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Mar 06 2012 - 14:41:31 CST