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@xxxxxxxxxxx
<http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew Parker's
profile on LinkedIn
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Mladen Gogala
Sent: Wednesday, October 28, 2015 4:06 AM
To: oracle-l@xxxxxxxxxxxxx
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
