Re: Oracle streams between 9i and 10g

Thanks Joel.
I read you document and it was just what the doctor ordered.

I will post my experience later.

Adar Yechiel
Rechovot, Israel

Joel.Patterson_at_crowley.com wrote:
> I have attached an interesting concept "Upgrading Oracle 9i database to
> oracle 10g database with near-Zero downtime" -- Using Streams. Not sure
> if you are interested, but thought I put it out there. Chances are
> that there will be one or more things present that will prevent you from
> succeeding such as 'Long datatypes' that have not been converted to
> CLOBs yet. (just and example).
>
> Surely it works for his example... but I have not had the chance to make
> it work for a 'real' database.
>
> Joel Patterson
> Database Administrator
> joel.patterson_at_crowley.com
> x72546
> 904 727-2546
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Yechiel Adar
> Sent: Monday, October 06, 2008 9:07 AM
> Cc: ORACLE-L
> Subject: Re: Oracle streams between 9i and 10g
>
> I am aware of the difference between 9 and 10.
> We plan to do the move twice.
> One full move and then test the application, including stress test with
> load runner.
> After we get the OK we clean the new database and do the copy again,
> this time as production.
>
> I am asking about the feasibility of using streams from RAC 9.2 on
> windows to RAC 10.2 on Linux for the copy,
> and the other way to keep the old database in sync, after we move to
> production, in case we need to fall back.
>
> Adar Yechiel
> Rechovot, Israel
>
>
>
> Bort, Guillermo wrote:
>
>> I'd go with Export/Import and statistics recollection for the tables
>> migrated. Also, be advised that moving from 9i to 10g is not always
>> simple, and usually execution plans change. So I'd say quiet a lot of
>> testing should be done before moving the production environment.
>>
>> Remember, 10G does not have RBO.
>>
>> HTH.
>>
>> Guillermo Alan Bort
>> EDS - ITO DBA Main Group
>>
>> -----Original Message-----
>> From: oracle-l-bounce_at_freelists.org
>> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Yechiel Adar
>> Sent: Sunday, October 05, 2008 12:54 PM
>> To: ORACLE-L
>> Subject: Oracle streams between 9i and 10g
>>
>> I have a 9.2 database on windows, rac, and we want to move it to
>>
> Linux.
>
>> I have a Linux rac, 10.2.0.3 ready.
>>
>> Can I use streams for this?
>>
>> Is it possible, in a simple way, to stream also from Linux 10.2 to 9.2
>>
>
>
>> so we can fall back without problems?
>>
>> Any experience?
>>
>>
>>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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