Restore Oracle9i Database from Windows to Linux

[LGTObug]

Hello All,

How can i Restore a Oracle9i Database from Windows to Linux?
I have an RMAN Backup.

I´ve tried it serveral times but i can´t to the Restore. I stuck at the beginning with the Controlfile.
When i ran:
"restore controlfile to 'xxx' from 'bckcontrolxsdf';
i get this error below?
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/10/2008 18:27:00
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece


How can i solve this Problem?
Any help would ge greatly appreciated.

Thanks in advance.
Regards

 

[SantaMufasa]

LGTOBug,

I am not an RMAN user (I do my physical backups the old-fashioned way), but I cannot imagine that RMAN would allow restoration of physical backups to dissimilar file systems (e.g., Windows to Linux).

If you want to migrate across file-system boundaries, then you must export from Windows and import to Linux. This works because export/import are logical transfers that are not inhibited by physical filesystem idiosyncracies.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[Thargy]

LGTO,

Dave is right, there are restrictions on what files can be transferred, even using EXP and IMP. For example, you can't move from a 32 to 64 bit OS.

Is there any reason why you can't create a blank database on Linux, then create a DB Link to the windows system, and bring everything across via the link?

Regards

T

Grinding away at things Oracular