Re: porting Oracle from Solaris to AIX

  • From: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
  • To: deryaoktay@xxxxxxxxx
  • Date: Sun, 24 Sep 2006 14:45:32 +0200

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.

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

Other related posts: