Is it possible to make a homogenious copy

[Former Member]

Is it possible to make a SAP homogeneous copy from the backup of Oracle DB on HPUX (64 bit) to Oracle on Windows (32 bit) ?

I am planning to make a sand box system on windows from the database backup of ORACLE/HPUX.

Your reply will be highly appreciated

Al Mamun

[fidel_vales · Accepted solution]

Hi,

I'd like to clarify a little.

You <b>cannot </b>restore directly an Oracle backup from HPUX to Windows.

As it is a different OS it is called "Heterogeneus" system copy.

If you want to create a sand box, then ( not knwing your DB version ) you will have to export the data with R3load and import it on the new system.

You can find the guide on

http://service.sap.com/instguides

The exact location depends on the SAP Version.

If you are already on Oracle 10, perhaps you can take a look at the note <a href="http://service.sap.com/sap/support/notes/1003028">1003028: Enhanced support for system copy in BR*Tools</a> as it explain a method to use transportable tablespaces for the heterogeneus system copy.

[Former Member · Accepted solution]

Thanks for your reply.

I will take care as you advised,

Regards,

- Al mamun

[Former Member]

It is possible to make the oracle copy( hetergenous) bcos you are changing either the OS or database? So you will require the migration key from sap.

[Former Member]

Copy from the backup of Oracle DB on HPUX (64 bit) to Oracle on Windows (32 bit) - should be a heterogeneous copy..