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

  • From: Upendra N <nupendra@xxxxxxxxxxx>
  • To: <chrisdavid.taylor@xxxxxxxxxxxxxxx>, <oracle@xxxxxxxxxxxxxxx>, Oracle-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 6 Mar 2012 16:10:36 -0500



Chris,
Sometime ago I upgraded a database from 10g to 11g migrating from Sparc to 
Intel. Because the database needed HA, we picked up Oracle Streams as the 
choice, the entire downtime for the hardware/OS/Oracle version migration was 
<30 mins.

We used datapump to migrate the initial data and to keep up with the changes 
Oracle Streams was used. You may want to check out the datatype exclusions in 
Streams and understand the amount of redo generated in the 10g environment to 
see if your network could handle pushing it to the 11g environment. Streams is 
very delicate, so we had to change some of our internal processes to eliminate 
most of the temporary processing (creating temp tables etc) in the schema that 
are replicated, monitoring batch jobs etc.
 
In this solution you could use the 11g database for most of the read only 
testing. And a couple of times, we stopped Streams and let QA teams write to 
the database as well.

If you can afford to buy Oracle GoldenGate that is worth considering.

-Upendra


> From: ChrisDavid.Taylor@xxxxxxxxxxxxxxx
> To: oracle@xxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> Date: Tue, 6 Mar 2012 11:16:04 -0600
> Subject: RE: RMAN convert 5TB db on Linux (Little Endian) to AIX (Big Endian) 
> - alternatives?
> 
> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
> Behalf Of Norman Dunbar
> Sent: Tuesday, March 06, 2012 11:11 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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
> --
> //www.freelists.org/webpage/oracle-l
> 
> 
> 
> 
> --
> //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