Re: Oracle streams between 9i and 10g
Date: Tue, 07 Oct 2008 08:06:00 +0200
I read you document and it was just what the doctor ordered.
I will post my experience later.
> 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
> 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.
>> 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
>> 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?