Re: porting Oracle from Solaris to AIX

Hi Deray

It appears to be pretty rare that all data is updated continuously in a database. Only s small part is used/changed on a daily database, the rest is historical data. So, my approach in situations like these is:

1. Identify 'stable' tables (normally lookup tables with codes, messages and so on)
2. Identify 'stable' parts of changing tables (often to be identified by timestamps, sequence based keys, invoice status fields and so on)
3. Export data found under 1 and 2 from the originating database, and import in the newly setup 10g database on AIX
4. At the cutover weekend, export the remaining data, and import this in the new database.

The QUERY clause of the exp utility is your friend on this matter. Advantages are that you can carry out a lot of the work during office hours. You can easily test the cutover in one weekend, and find out how much time is needed for each step. After the first test, a functional test of completeness of the migration should be carried out carefully. If all works fine, the final cutover can be scheduled.

Another approach could be: upgrade to 10g on Solaris, and use datapump to transport the tablespaces cross-platform to AIX.

HTH,
Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===

On Sun, 2006-09-24 at 14:43 +0300, Derya Oktay wrote:

> Hi,
> We have Oracle 9.2 running on Solaris, we want to port it to AIX 5.3.
> We have got 100G data and our clients do not work at weekends, thus we
> have 1 day to do this.
> What is the easiest way to this? We also plan to upgrade that
> database to 10g.
> Regards
> Derya Oktay

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