Re: Zero Downtime Upgrade and Migration

  • From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
  • To: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • Date: Thu, 14 Oct 2010 13:10:47 +0200

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@xxxxxxxx

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info@xxxxxxxx
http://www.10046.ch

=========================


On Wed, Oct 13, 2010 at 7:34 PM, Goulet, Richard <Richard.Goulet@xxxxxxxxxxx
> 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@xxxxxxxxx]
> *Sent:* Wednesday, October 13, 2010 11:17 AM
> *To:* Goulet, Richard; avadhanimys@xxxxxxxxx
> *Cc:* ora-apps-dba; oracle-l; oaugnetdba-on@xxxxxxxx
> *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@xxxxxxxx
>
> 10046 Consulting GmbH
> Schwarzackerstrasse 29
> CH-8304 Wallisellen
> Switzerland
>
> Phone +41-(0)8400-10046
> Cell +41 (0) 79 571 36 27
> info@xxxxxxxx
> http://www.10046.ch
>
> =========================
>
>
> On Wed, Oct 13, 2010 at 4:10 PM, Goulet, Richard <
> Richard.Goulet@xxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:
>> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Avadhani mys
>> *Sent:* Wednesday, October 13, 2010 5:45 AM
>> *To:* ora-apps-dba; oracle-l; oaugnetdba-on@xxxxxxxx
>> *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
>>
>
>

Other related posts: