Howto restore oracle windows cold backup on linux platform?
Posted on 2008-09-29
Hi everyone. Hopefully somebody can help me with Oracle 10g. I'm not a oracle expert at all.
I want to take a cold oracle backup, and restore it on a linux (fedora 9) platform. From the windows oracle base, I shutdown the database, and copied all directories (orcl) underneath the oradata directory. I then stepped over to my linux machine, and dumped all the data into the corresponding 'oradata' directory.
1. rman target /
2. startup mount
3. alter database open;
The database did not want to start the database for the data files are located somewhere on the 'c:\oracle\product\10.2.0\oradata' folder. What do I need to change for oracle to point to the /u01/oracle/...' files? I tried the 'alter database rename file x to y', but it needs the original filename to be existing.