DomainKey-Signature: a=rsa-sha1; c=nofws;        d=gmail.com; s=gamma;        h=mime-version:in-reply-to:references:date:message-id:subject:from:to         :cc:content-type;        b=SlX69a1QhnAAgvOxFsr5kG/nKTCStNvovb7ZA1yI3fz3FqQo58dXap/esHRNLbabNf         mIHNT9PIST/Q/67zy9IjaWVX8BjdkdK6CsIcKU4UlmiVruxIhdU1uzo07iGn/6dfyZS3         HRcVmHy+AIpwGfKVtYVZVa8c9zMcP+PAClh4I=
MIME-Version: 1.0
In-Reply-To: <AANLkTilVd4UGVtgt1jw1v48sbDZI5q99yITvvDhO2d5Q@mail.gmail.com>
References: <AANLkTilVd4UGVtgt1jw1v48sbDZI5q99yITvvDhO2d5Q@mail.gmail.com>
Date: Wed, 7 Jul 2010 10:58:00 -0500
Message-ID: <AANLkTikGxbfvxnpk3My3N1gX0Nq5uU7_sSgxXr_LCIg0@mail.gmail.com>
Subject: Re: Cross platform migration from 10.2.0.4 to 11gR2
From: John Thompson <jhthomp@gmail.com>
To: dbmangler@gmail.com
Cc: oracle-l@freelists.org
Content-Type: multipart/alternative; boundary=0015176f1426ecd753048ace3bbe
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: jhthomp@gmail.com
--0015176f1426ecd753048ace3bbe
Content-Type: text/plain; charset=ISO-8859-1

We faced almost the exact dilema but had a shorter downtime window of 6
hrs.  Because of that, we had to use streams.  Using this method, downtime
was less than 30 mins. during the switchover.

On Thu, Jul 1, 2010 at 2:47 PM, Jeff Thomas <dbmangler@gmail.com> wrote:

> List -
>
> We are in the process of planning a migration of all RAC databases from
> 10.2.0.4 on Solaris SPARC 64-bit to RHEL x86-64 running 11gR2.
>
> Obviously we have an endianess difference which constrains the methods that
> can be used to perform the migration.     Furthermore,
> it will be an ASM to ASM migration, which may take the cross-platform
> transportable tablespace feature out of play as my understanding
> is that we would have to use something like DBMS_FILE_TRANSFER over a
> database link to move the datafiles and I'm skeptical
> that we'd get the performance required to meet our (still undefined) SLAs
> (but we'll test this of course.)
>
> So it is starting to look as though data pump is about the only reasonable
> option that we have.   Am I wrong?
>
> I'm not sufficiently familiar with say Oracle Streams or Goldengate to
> understand whether these are viable alternatives.
>
> I would appreciate any comments from someone who's been through a similar
> implementation.
>
> Best,
> Jeff
>

--0015176f1426ecd753048ace3bbe
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

We faced almost the exact dilema but had a shorter downtime window of 6 hrs=
.=A0 Because of that, we had to use streams.=A0 Using this method, downtime=
 was less than 30 mins. during the switchover.<br><br>
<div class=3D"gmail_quote">On Thu, Jul 1, 2010 at 2:47 PM, Jeff Thomas <spa=
n dir=3D"ltr">&lt;<a href=3D"mailto:dbmangler@gmail.com">dbmangler@gmail.co=
m</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex; MARGIN: 0px 0=
px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">List -<br><br>We are in the proc=
ess of planning a migration of all RAC databases from 10.2.0.4 on Solaris S=
PARC 64-bit to RHEL x86-64 running 11gR2.<br>
<br>Obviously we have an endianess difference which constrains the methods =
that can be used to perform the migration.=A0=A0=A0=A0 Furthermore,<br>it w=
ill be an ASM to ASM migration, which may take the cross-platform transport=
able tablespace feature out of play as my understanding<br>
is that we would have to use something like DBMS_FILE_TRANSFER over a datab=
ase link to move the datafiles and I&#39;m skeptical<br>that we&#39;d get t=
he performance required to meet our (still undefined) SLAs (but we&#39;ll t=
est this of course.)<br>
<br>So it is starting to look as though data pump is about the only reasona=
ble option that we have.=A0=A0 Am I wrong?=A0 =A0 <br><br>I&#39;m not suffi=
ciently familiar with say Oracle Streams or Goldengate to understand whethe=
r these are viable alternatives.=A0=A0 <br>
<br>I would appreciate any comments from someone who&#39;s been through a s=
imilar implementation.<br><br>Best,<br><font color=3D"#888888">Jeff<br><fon=
t color=3D"#888888"></font></font></blockquote></div><br>

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