RE: Migrate from AIX to Linux

From: Dimensional DBA <dimensional.dba_at_comcast.net>
Date: Tue, 15 Dec 2015 22:26:20 -0800
Message-ID: <001201d137ca$bffe71a0$3ffb54e0$_at_comcast.net>

Does any of your application tables have longs, clobs or blobs in them?  

Matthew Parker

Chief Technologist

425-891-7934 (cell)

Dimensional.dba_at_comcast.net

 <http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew Parker's profile on LinkedIn  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Deepak Sharma (Redacted sender "sharmakdeep_oracle" for DMARC) Sent: Tuesday, December 15, 2015 9:53 PM To: Dimensional DBA; kylelf_at_gmail.com; 'Andrew Kerber' Cc: 'ORACLE-L'
Subject: Re: Migrate from AIX to Linux  

We are still trying to see what the options are, but I would say about 48hrs (over a weekend).  

-thanks
   

On Tuesday, December 15, 2015 1:49 AM, Dimensional DBA <dimensional.dba_at_comcast.net> wrote:  

Seems like extra unnecessary work Kyle, than just using the standard rman methodology proposed.  

Deepak, what is your outage window allowed for this database?      

Matthew Parker

Chief Technologist

425-891-7934 (cell)

Dimensional.dba_at_comcast.net

 <http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew Parker's profile on LinkedIn  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of kyle Hailey Sent: Monday, December 14, 2015 2:30 PM
To: Andrew Kerber
Cc: Deepak Sharma; ORACLE-L
Subject: Re: Migrate from AIX to Linux    

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.  

https://danielstolf.wordpress.com/2015/12/09/migrating-oracle-from-unix-to-linux-on-the-cloud-the-easy-way-3/  

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-l Received on Wed Dec 16 2015 - 07:26:20 CET