Re: Migrate from AIX to Linux

  • From: "Deepak Sharma" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "sharmakdeep_oracle" for DMARC)
  • To: Dimensional DBA <dimensional.dba@xxxxxxxxxxx>, "kylelf@xxxxxxxxx" <kylelf@xxxxxxxxx>, 'Andrew Kerber' <andrew.kerber@xxxxxxxxx>
  • Date: Wed, 16 Dec 2015 05:52:43 +0000 (UTC)

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@xxxxxxxxxxx> wrote:


#yiv8107411027 #yiv8107411027 -- _filtered #yiv8107411027
{font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv8107411027
{font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv8107411027
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv8107411027
{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv8107411027
#yiv8107411027 p.yiv8107411027MsoNormal, #yiv8107411027
li.yiv8107411027MsoNormal, #yiv8107411027 div.yiv8107411027MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv8107411027 a:link,
#yiv8107411027 span.yiv8107411027MsoHyperlink
{color:blue;text-decoration:underline;}#yiv8107411027 a:visited, #yiv8107411027
span.yiv8107411027MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv8107411027
span.yiv8107411027EmailStyle17 {color:#1F497D;}#yiv8107411027
.yiv8107411027MsoChpDefault {} _filtered #yiv8107411027 {margin:1.0in 1.0in
1.0in 1.0in;}#yiv8107411027 div.yiv8107411027WordSection1 {}#yiv8107411027
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 ParkerChief Technologist425-891-7934
(cell)Dimensional.dba@comcast.netView Matthew Parker's profile on LinkedIn  
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.  BestKyle        
On Sat, Dec 12, 2015 at 7:39 AM, Andrew Kerber <andrew.kerber@xxxxxxxxx>
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@xxxxxxxxx>
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@xxxxxxxxx> 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@xxxxxxxxxxxxx>
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.'  
 

Other related posts: