Moving an Oracle Database from Solaris to AIX

[boobboo]

Hi all,

I have been asked to move an SAP system using an Oracle database from

Solaris to AIX (on an IBM P590).

Most of the move is straightforward, except the Oracle database

transfer. It would make my life so much easier if I could simply

restore the Oracle datafiles from an off-line backup of the Solaris

system and then link it to a clean install of the Oracle binaries on

the AIX system, rather than have to do an export and import.

Is this possible, after all the AIX Oracle binaries would be the same

patch level as the Solaris binaries and the file systems would be the

same. Also as it would be an offline backup we would not have to do

any recovery, so the archive logs and the original redo logs would not

be required.

Does anyone know if this is possible or has actually executed it

successfully, any hints and tips on the gotchas would be greatly

appreciated.

TIA

Chris aka BoobBoo

[stefan_koehler]

Hello Chris,

unfortunately you didn't write anything about your oracle version or your backup mechanism like RMAN,etc..

I think you will use Solaris on a SPARC architecture and not on x86? (same endian)

If you have RMAN and 10gR2 then you can use the "Database Transport Across Same Endian Platforms":

http://download-uk.oracle.com/docs/cd/B19306_01/backup.102/b14191/wnbradv.htm

> RMAN now supports the CONVERT DATABASE command, which can prepare a whole database for transport to a new platform that uses the same endian format. Database transport across platforms provides a faster and easier way to move databases from one platform to another than previous solutions requiring the use of Data Pump.

Metalinknote #413586.1 has a FAQ and a step on step guide.

If you have created your tablespaces under Oracle 10g (no oracle upgrade from previous releases!!) you can use the "Transportable tablespace feature" and copy the database files. SAP has published note #1035051 for that.

Regards

Stefan

[fidel_vales]

Hello,

Unfortunately, backup/restore from different platforms is not supported by oracle.

There could be an option, it is transportable tablespaces, but I do not have much information about it. It is only valid if you have Oracle 10g

it is not mentioned on the note 89188 "R/3 System copy", but on the note 1003028 "Enhanced support for system copy in BR*Tools"

I advise you to open a message on SAP to check if more information is available.

[Former Member]

Hello Chris,

would this maybe help you?

[https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f022aa7d-0c01-0010-20a5-c247330d47fa]

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/200ebc93-dabe-2910-c1a6-c4ec30b2...

Bye

Frank