Re: Migrate from AIX to Linux
Date: Mon, 14 Dec 2015 14:30:27 -0800
Message-ID: <CADsdiQj3vxi3yu1ybbJz1L+YTka9rSncQ7E9FKb03xQ0eJ5i_g_at_mail.gmail.com>
Here is a blog post from last week of someone doing an AIX to Linux conversion as well as migrating the database to the cloud.
They used a free version of Delphix to do the conversion:
http://datavirtualizer.com/delphix-express-installation/
Delphix only has minimal impact on the time for conversion but does save the original and converted database in about 1/3 the size of the original database. For example if you had a 3 TB database, a copy of the original AIX database along with the converted LINUX database together would table up about 1 TB.
Best
Kyle
On Sat, Dec 12, 2015 at 7:39 AM, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:
> Sounds like it would work. I don't know how much time you have, but I
> would start with a small instance, even create one if necessary, and run
> through the initial, incremental, and final steps a few times to rehearse
> it before I tried it on your large instance. I have never found rehearsal
> time wasted on this type of project.
>
> Sent from my iPad
>
> On Dec 11, 2015, at 11:53 PM, Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
> wrote:
>
> As I mentioned initially, we already do an RMAN IMAGE Copy backup on
> regular basis. Fyi, the last time we may have done a fresh Level-0 was a
> few years ago. Since then we've been applying the daily incrementals to
> that Level-0, and moving it forward. So, what that means is that the
> current Level-0 is a good Image Copy backup that we can potentially use to
> create a brand new database someplace else.
>
> I looked at the FastXTTS method briefly (Doc 1389592.1) and it says to
> take Image Copy backups of the Datafiles on the source system.
>
> So, seems like the following would be possible in our case:
>
> 1. Copy the RMAN Image Copy backup (latest) from Source to Dest server's
> staging location (backup filesystems) - *stageondest location*
>
> 2. Use the RMAN Convert command to convert all the datafiles. The
> converted files would be copied to the real datafile locations on
> destination server - *storageondest location*
>
> "The convert datafiles step converts the datafiles copies in the
> *stageondest* location to the endian format of the destination system.
> The converted datafile copies are written in the location specified by the
> xtt.properties parameter *storageondest*. This is the final location
> where datafiles will be accessed when they are used by the destination
> database."
>
> Thoughts?
>
>
>
> On Friday, December 11, 2015 3:38 PM, Andrew Kerber <
> andrew.kerber_at_gmail.com> wrote:
>
>
> Nope. There is an endian conversion issue. However, Oracle does now have
> a cross platform incremental backup option that you can use, and if you
> have the licenses, you can do this with golden gate also. Here is some
> information on the cross platform incremental backup:
> http://houseofbrick.com/fast-xtts-with-cross-platform-incremental-backup/
>
> On Fri, Dec 11, 2015 at 3:20 PM, Deepak Sharma <
> dmarc-noreply_at_freelists.org> 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
>
>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Dec 14 2015 - 23:30:27 CET