Re: Zero Downtime Upgrade and Migration
Date: Thu, 14 Oct 2010 13:10:47 +0200
Message-ID: <AANLkTimU_beD4+37E3+nbKGi1Wu+QO4dBh_UMawCnFA9_at_mail.gmail.com>
Interesting -- we've had a windows to linux migration - including version upgrade at the same time - done with it too, and it worked perfectly fine (even though I was skeptical at first as well)
But then, we've had several tests of the entire process done beforehand with identical test systems, which gave us confidence to go ahead with production.
Stefan
Stefan P Knecht
CEO & Founder
s_at_10046.ch
10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland
Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info_at_10046.ch
http://www.10046.ch
On Wed, Oct 13, 2010 at 7:34 PM, Goulet, Richard <Richard.Goulet_at_parexel.com
> wrote:
> Stefan,
>
> We tried that 9.1.0.6 Windows to 10.2.0.4 Linux. Downtime that was
> experienced was much more than expected (8+ hours) and we had data loss as
> well. And we even had a Quest consultant on site. Not on my to-do list
> ever again.
>
>
> Dick Goulet
> Senior Oracle DBA
>
>
> ------------------------------
> *From:* Stefan Knecht [mailto:knecht.stefan_at_gmail.com]
> *Sent:* Wednesday, October 13, 2010 11:17 AM
> *To:* Goulet, Richard; avadhanimys_at_gmail.com
> *Cc:* ora-apps-dba; oracle-l; oaugnetdba-on_at_oaug.com
> *Subject:* Re: Zero Downtime Upgrade and Migration
>
> Quest Shareplex can do 8i -> 11g --
>
> see
> http://www.quest.com/Quest_Site_Assets/PDF/DSD_SharePlex_for_Oracle_2.pdf
>
> With (almost) no downtime.
>
> Stefan
> <http://www.quest.com/Quest_Site_Assets/PDF/DSD_SharePlex_for_Oracle_2.pdf>
> =========================
>
> Stefan P Knecht
> CEO & Founder
> s_at_10046.ch
>
> 10046 Consulting GmbH
> Schwarzackerstrasse 29
> CH-8304 Wallisellen
> Switzerland
>
> Phone +41-(0)8400-10046
> Cell +41 (0) 79 571 36 27
> info_at_10046.ch
> http://www.10046.ch
>
> =========================
>
>
> On Wed, Oct 13, 2010 at 4:10 PM, Goulet, Richard <
> Richard.Goulet_at_parexel.com> wrote:
>
>> Avadhani,
>>
>> What your client is asking for is completely impossible. For
>> starters your direct upgrade part is 8.1.7 (or lower) -> 8.1.7.4 ->
>> 9.2.0.8 -> 11.2 and your moving os platforms which means a transportable
>> database migration. Way too many moving parts. What is the size of the
>> source database? If it's small enough you can go the export/import route
>> which at least minimizes the downtime. But your not going to get to 0 on
>> this one.
>>
>>
>> Dick Goulet
>> Senior Oracle DBA
>>
>>
>> ------------------------------
>> *From:* oracle-l-bounce_at_freelists.org [mailto:
>> oracle-l-bounce_at_freelists.org] *On Behalf Of *Avadhani mys
>> *Sent:* Wednesday, October 13, 2010 5:45 AM
>> *To:* ora-apps-dba; oracle-l; oaugnetdba-on_at_oaug.com
>> *Subject:* Zero Downtime Upgrade and Migration
>>
>> Hello Gurus,
>>
>> Please let me know any suggestions other than
>> Oracle-Golden-gate to achieve Zero downtime migration.the challenge is we
>> need to Upgrade and Migrate Oracle 8i database [Upgrade to 11gR2 and
>> migrate to Sun-Solaris from AIX]. This is very critical application and
>> client needs Zero downtime.
>>
>> Please let me know your valuable suggestions on this. And also please let
>> me know your valuable inputs/links on the documents on using Oralce Golden
>> gate to achieve Zero downtime upgrade and migration
>>
>> Thanks in Advance.
>>
>> Regards,
>> Avadhani
>>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 14 2010 - 06:10:47 CDT