Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Restore backup from Windows to Linux scenario

677921Jan 2 2009 — edited Jan 3 2009
I have a database flash_recovery_area structure from a Windows host with Oracle 10g. Now i want to restore a given date backup to a Linux host with Oracle 11g.
Important: I DONT have access to the original Windows host, just to the backup files and my Linux host.

I am an oracle newbbie, and so i have a couple of doubts about thing i've read somewhere on the web.

1) It is possible to do that? I mean, restore a Windows oracle db to a Linux host? I read somewhere about incompatible bigendian, little endian, etc.

2) I ve tried the restore operation following instructions from diverse sources on the net, and i reach the point where the controlfile is restored, but i cant rename the datafiles (located under c:\Oracle\ ..... on the original host as i can see when i do select * from v$datafile;), cause when i try to do

ALTER DATABASE RENAME FILE 1 TO '/u01/ ..... /system01.dbf'

oracle says cant locate 'c:\Oracle\ ... \system01.dbf'

Please, i need help!!

The URL's i've read are:

http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/dfiles005.htm
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/recov004.htm#CFABADJC
http://arjudba.blogspot.com/2008/05/restore-and-recover-database-to-new.html

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 31 2009
Added on Jan 2 2009
9 comments
614 views