Re: Moving 7.2.3 from AIX to Sun-Solaris.

Hans,

Oracle datafiles are specific to the OS/hardware platform they are created on and can only be copied successfully to binary compatible systems. The only way to move Oracle databases between different Unix platforms is via export (or SQL*Loader if you want to go to that much trouble). You will need to create the target database on your Sun box (using raw devices if you feel you must), do a full (or several partial) export(s) of the database on your RS/6000 and then import (everything but the data dictionary (i.e. user SYS))into the target database.

Hope that helps

Best regards.
Chuck

Charles N. Wolfe
Manager, Database Administration
PsiNet
wolfec_at_psi.com
Hans Tore Bråten wrote:
>
> Hi!
> I'm going to move a huge Oracle 7.2.3 db from AIX to 4.1.4.0
> Sun Solaris 2,6.
> The old db contains only Oracle raw disks (including the control files)
>
> Is it possible to take a full backup of all the raw devices from the
> old db, and then create the oracle disk volume on the Sun machine
> and restore the raw data files into the Sun machine?
>
> I have used this method to create a test db, but that was on the same
> Unix plattform.
>
> Please give me some feedback!
>
> Best regards,
>
> Hans
Received on Tue Aug 04 1998 - 15:04:33 CDT