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@xxxxxxxxxxx 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@xxxxxxxxxxx x72546 904 727-2546 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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 toLinux.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.2so we can fall back without problems? Any experience?