Re: Migrate from AIX to Linux

From: Deepak Sharma <"Deepak>
Date: Sat, 12 Dec 2015 05:24:04 +0000 (UTC)
Message-ID: <777984936.105214.1449897844642.JavaMail.yahoo_at_mail.yahoo.com>

It's about 200TB active data-warehouse with 8B rows loaded and 5-6TB arch generated a day.

We'll try to look into the "Cross Platform Incremental Backup" that Andrew mentioned. -thanks

    On Friday, December 11, 2015 7:47 PM, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:  

  On 12/11/2015 04:20 PM, Deepak Sharma (Redacted sender sharmakdeep_oracle for DMARC) wrote:   

  We have a 11.2.0.4 DB on AIX and want to move it to HP Intel Redhat Linux.   The new Linux server also has a new storage.   Currently we use RMAN Image Copy backups on the AIX server, do incrementals every day and then merge those incrementals with the previous Image, thereby moving the Image Copy current.   Question:  Can we move the RMAN Image copy backup to the Linux server, and convert it (endian conversion) using some RMAN command?   What I understand is that the RMAN "CONVERT TABLESPACE" on source (AIX) and "CONVERT DATAFILE" on target (Linux), are the standard method, but would require downtime on the source system (AIX).   I was wondering if the RMAN Image copy could somehow be used (as described above), so we can still have the production system on AIX up and running.   -thanks         

 How much data is there to migrate? There are several methods to choose from:     

• Transportable tablespaces. This method requires the source tablespaces to be put into the read only state.
• Replication, usually GG, but there are others. SymmetricDS is a popular open source solution, but not as robust as GG. Attunity is another commercial product that I've encountered, but I have never played with it, so I can't say anything about it.
• Export/import Depending on your downtime requirements and the amount of data to transfer, you can chose any of those methods.  Transportable tablespaces are the fastest method, which requires the most downtime. Replication is the slowest of the 3 but doesn't require any downtime. Export/import  in "data pump" version are quite fast, and if you have an appropriate downtime, can be rather convenient.

 --
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com     

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

Received on Sat Dec 12 2015 - 06:24:04 CET