1 Reply Latest reply: Jul 4, 2013 2:33 AM by jsqfel RSS

    migrate oracle xe 10g win ->linux

    33b4dd93-818d-44ca-9a82-8bb879189a55

      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 ?