Re: Migration 11gR1 Solaris to Exadata 11gR2
From: Thomas P S <royxavier_at_yahoo.com>
Date: Thu, 30 Jan 2014 09:13:04 -0800 (PST)
Message-ID: <1391101984.57042.YahooMailNeo_at_web162402.mail.bf1.yahoo.com>
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
Date: Thu, 30 Jan 2014 09:13:04 -0800 (PST)
Message-ID: <1391101984.57042.YahooMailNeo_at_web162402.mail.bf1.yahoo.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 30 2014 - 18:13:04 CET