Re: Migration 11gR1 Solaris to Exadata 11gR2
- From: Thomas P S <royxavier@xxxxxxxxx>
- To: 'ORACLE-L' <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 30 Jan 2014 09:13:04 -0800 (PST)
Many thanks to everyone for responding.
Faud, TTS with incremental data - I believe both target and source should be
same version? This doc is only talking about migration between different
Endian formats, not different versions and endian. Not sure I can consider
this option as my version is also different.
Bobby, Yes GG replication and cut over is also actively considered except the
GG $$$ pulling it down.
Hansraj, That is really interesting to see that you have already used
Crossplatform TTS with CONVERT. Will you please share the note number if it
is handy? If Oracle support this migration path, going to be the easiest one.
Mayen, yes full data pump exp/imp is going to be the last option.
Regards,
Thomas
On Thursday, January 30, 2014 7:32 PM, Bobby Curtis <curtisbl@xxxxxxxxx> wrote:
Thomas,
Using GoldenGate and switching over is the approach a lot of people are using.
It doesn’t matter that there are 1000+ tables. Just setup GoldenGate and then
take a consistent export. Then import on the Exadata side and start replicat.
Once everything is in sync, the organization can decided when to switch.
I over simplified the approach, but many companies look at uptime while doing
migrations. GoldenGate is the tool that can minimize downtime and complete the
migration task. The trade off with using GoldenGate is the cost associated
with licensing. Typically, both sides of the replication site has to be
licensed (source and target).
Anyways, I hope this helps.
Thanks
Bobby
From:oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Thomas P S
Sent: Thursday, January 30, 2014 2:24 AM
To: ORACLE-L
Subject: Migration 11gR1 Solaris to Exadata 11gR2
Dear Experts,
We are migrating from Oracle (Solaris) 11gR1 to Exadata 11gR2. Considering the
two differences 1) Os Solaris Vs Linux 2) Version 11gR1 Vs 11gR2 - What is the
best migration method?
1) Transportable Tablespaces - Endian conversion with version upgrade is
recommended option? I did not see this method suggested in oracle upgrade
document. I could observe only same version with Endian CONVERT
2) Expdp / Impdp : Is it wise to use these tools when we have large number
/size of tables. DB size come to more than 4+ TB
3) Build a replicated site using Golden Gate and switch over. Not sure it is
recommended when have 1000+ tables
4) Upgrade the current database to 11gR2 and do a crossplatform TTS. Looks
like suitable option - but time and $$ is a constrain.
Out of above which is the best option? Or is there any other option i haven't
noticed?
Many thanks in advance for taking time to read this and replying. Really
appreciated.
Thanks,
Thomas Saviour
http://ora600tom.wordpress.com
Other related posts:
