Hi!
i try to migrate database from windows to linux, and i have multiple unsuccessful migrations
1. exp\imp - multiple errors
2. expdp \ impdp as system - multiple errors
3. backup on windows & restore on linux - procedure can't finish
rman restore SPFILE /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/spfileXE.ora
with lines like this:
<code>
*.audit_file_dest='D:\oraclexe\app\oracle\admin\XE\adump'
*.background_dump_dest='D:\oraclexe\app\oracle\admin\XE\bdump'
*.compatible='10.2.0.1.0'
*.control_files='D:\oraclexe\oradata\XE\control.dbf'
*.core_dump_dest='D:\oraclexe\app\oracle\admin\XE\cdump'
</code>
and can't startup database
if i make file spfileXE.ora unchangeable rman restore bases as
<code>
restoring datafile 00001 to D:\ORACLEXE\ORADATA\XE\SYSTEM.DBF
restoring datafile 00002 to D:\ORACLEXE\ORADATA\XE\UNDO.DBF
restoring datafile 00003 to D:\ORACLEXE\ORADATA\XE\SYSAUX.DBF
restoring datafile 00004 to D:\ORACLEXE\ORADATA\XE\USERS.DBF
</code>
this files look like
<code>
-rw-r----- 1 oracle dba 597696512 Июл 3 18:11 D:ORACLEXEORADATAXESYSAUX.DBF
-rw-r----- 1 oracle dba 367009792 Июл 3 18:11 D:ORACLEXEORADATAXESYSTEM.DBF
-rw-r----- 1 oracle dba 94380032 Июл 3 18:11 D:ORACLEXEORADATAXEUNDO.DBF
-rw-r----- 1 oracle dba 104865792 Июл 3 18:11 D:ORACLEXEORADATAXEUSERS.DBF
</code>
and can't finish w\o errors
full restore log
How can i migrate database w\o errors ?