View Single Post

   
  #1 (permalink)  
Old 02-26-2008, 06:14 AM
KrzysztofB
 
Posts: n/a
Default Using db files on another server

I have file-copy database backup (*.ctl, *.dbf, and .ora file) and
need to connect these files to working server.

My method (described below) failed.
I did it similar way on Windows XP and Fedora Core5
What I'm doing wrong?


-----------------------------
I have oracle 10.2.0.1.0, .ora file has line "compatible=10.1.0.4.0"

I copy data files under oradata/NAME and
.ora file into dbs directory.

and next:

ORACLE_SID=PROPERSID;
export ORACLE_SID;
sqlplus /nolog
connect user/pass as sysdba
startup mount

and result:
ORA-27047 unable to read the header block of file
(on Windows I had ORA-27047 + OSD-04001 wrong block size)
---------------------------------------------

Thanks for all your help
KrzysztofB



Reply With Quote