Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question
    
Sarith, I know you have accepted an answer but is your system using ASM, Managed file names or provied manually. I have done this the otherway without any archivelogs for a test system –  OilyRag Jun 20 '09 at 20:02

2 Answers 2

up vote 3 down vote accepted

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.

share|improve this answer
1  
See download.oracle.com/docs/cd/B19306_01/backup.102/b14191/… for an RMAN/transportable tablespaces guide. –  crb Jun 12 '09 at 20:31
    
Lots of good info in that link. –  DCookie Jun 12 '09 at 21:59
1  
Be careful about CLOBs/BLOBs, if you have them! –  slovon Jun 15 '09 at 18:42

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.

share|improve this answer
1  
export/import (including datapump) does this faster and doesn't miss anything like constratints, triggers, indexes, synonyms, grants, etc. –  DCookie Jun 12 '09 at 18:21

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.