Re: Migration 11gR1 Solaris to Exadata 11gR2

Here is note:

Using Transportable Tablespaces for EBS 11i Using Database 11gR2 (Doc ID 1366265.1)

They have included 11gR1 and 10g as source too. it is for EBS database but if your's is not EBS then you leave step needed for EBS database.

Thanks
Hansraj

On Thu, Jan 30, 2014 at 12:13 PM, Thomas P S <royxavier_at_yahoo.com> wrote:

> 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_at_gmail.com>
> 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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *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
>
>
>

-- 
Thanks,
Hansraj

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