<div>
Thanks johnsone. I did exactly as you mentioned, I export the complete tablespace from the windows machine using the 'exp' tool.<br />
<br />
i.e. 'exp system/password file=exp.dbf full=yes'<br />
<br />
Then on linux machine, I created the user, and imported the data using the 'imp' tool with the username it belongs to. Worked great, thanks.<br />
<br />
Martin
</div>


Thanks johnsone. I did exactly as you mentioned, I export the complete tablespace from the windows machine using the 'exp' tool.

i.e. 'exp system/password file=exp.dbf full=yes'

Then on linux machine, I created the user, and imported the data using the 'imp' tool with the username it belongs to. Worked great, thanks.

Martin

<div>
<div class="content wysiwyg-content">
Hi everyone. Hopefully somebody can help me with Oracle 10g. I'm not a oracle expert at all. <br />
<br />
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.<br />
<br />
I then:<br />
1. rman target /<br />
2. startup mount<br />
3. alter database open;<br />
<br />
The database did not want to start the database for the data files are located somewhere on the 'c:\oracle\product\10.2.0\<wbr />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.<br />
<br />
Any ideas?<br />
Martin
</div>
</div>


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.

I then:
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.

Any ideas?
Martin

Howto restore oracle windows cold backup on linux platform?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.