Re: Migrate from AIX to Linux
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Fri, 11 Dec 2015 20:46:58 -0500
Message-ID: <566B7C92.5090103_at_gmail.com>
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
>
Date: Fri, 11 Dec 2015 20:46:58 -0500
Message-ID: <566B7C92.5090103_at_gmail.com>
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-lReceived on Sat Dec 12 2015 - 02:46:58 CET