RE: AIX to Linux

From: Dimensional DBA <dimensional.dba_at_comcast.net>
Date: Wed, 28 Oct 2015 09:37:27 -0700
Message-ID: <032701d1119e$ef2b6ac0$cd824040$_at_comcast.net>

Depending on the data types in your tables and the version of your database, we used materialized views to migrate databases at Amazon with less than an hour downtime and the shortest time being 2 minutes regardless of the physical size of the database. The problem at the time was tables that still had longs in them instead of clobs/blobs that either you moved completely during the outage window or used incremental move methodologies and porting the final phases of Multi-Master Replicated databases.    

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 Mladen Gogala Sent: Wednesday, October 28, 2015 4:06 AM To: oracle-l_at_freelists.org
Subject: Re: AIX to Linux  

On 10/28/2015 02:03 AM, Dimensional DBA wrote:

If you own enough GoldenGate core licenses for source and target, then it is fairly straight forward as in the end it is really only data movement. If you don’t own the licenses then it is a spendy proposition.

You can also mix and match the different movement methodologies to port from AIX to Linux.

I ported a 50TB database 2 years ago AIX to Linux with Materialized Views and expdp/imdp for certain of the tables across a single weekend ($0 cost for any extra technology Golden Gate or Delphix).  

Hi Matt,
While I do agree that your method is cheaper, it does require considerable downtime. If that is not an option, some kind of replication technology like Golden Gate can help. Of course, there will an extra cost for that. Regards

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


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

Received on Wed Oct 28 2015 - 17:37:27 CET