Restore Oracle database backup from Windows 2000 server to Linux

Question

I'm currently using Oracle 11g on Windows 2000 Server. I make a full database backup (e.g. backup database plus archivelog) and I want to restore this backup on Linux. What are the appropriate steps to restore this backup to Linux?

Note: I have configured controlfile autobackup on;

Best Regards,

Sarith

Answer 1

Short answer: You can't. If your windows system is dead, you'll need to restore to another windows system. From there you must migrate your database using Oracle utilities:

Metalink indicates the following:

There is no Migration utility (Script or DBUA) to perform a cross platform migration.

To change platforms require the database instance be re-built and / or the data moved using one of the following methods:

1. Export / Import to include the use of Datapump facilities. all versions support Export/Import but for Datapump 10.1.0.2 or higher is required
2. Transportable Tablespaces 10G or Later
3. RMAN Convert Database functions. 10G or Later

The choices available will depend on BOTH the OS and Oracle versions of both the source and destination.

For example RMAN Convert Database only works if both source and destination belong to same ENDIAN format.

Transportable Tablespaces has a convert function to convert from one ENDIAN format to another.

HTH.

Answer 2

What I would do is create a db link from the new Linux Oracle server to the existing Windows Oracle server. Then, you can create the schema and copy the data over the data link.