Re: Migration 11gR1 Solaris to Exadata 11gR2

You can do Option 1 (Cross platform TTS )without upgrading source database database to 11gR2. We have migrated 10.2.0.4 to 11.2.0.3 directly. After we did I believe oracle is supporting that approach too and there is publish note also.

We migrated 10.2.0.4 HP-UX to exadata.

Thanks
Hansraj

On Thu, Jan 30, 2014 at 9:02 AM, 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