Here's the need:

- Upgrade a large (near 1TB) database from 8.1.7 to 9i
- Move from 32 bit oracle, to 64 bit oracle
- Move from Solaris to AIX
- Move from Sun to RS6000
- Do it in a small outage window

So, here is my idea:

I would like to minimize the down time when switching production from Sun to RS6000. So my approach is to see if I can run the 8.1.7 production, and use some method to keep a 9i database on the AIX boxes in sync with the data changes occuring on the sun 8.1.7 boxes. This way each will be running in parallel until the time comes to switch the application servers to point to the new AIX boxes. I'm trying to avoid having to, the night of the switch over, perform and ENTIRE extract from 8.1.7 and a full import into 9i. There is just too much data to do this in a relatively small outage window, even if things were flawlessly.

So - what options do I have to take daily (or smaller time span) data changes from an 8.1.7 32 bit database on Sun, and push those changes into a 9i 64 bit database running on AIX?

Oh - and the estimated I/O rates in the database during peak times is two 150MB redo logs per minute.

Thanks!