View Single Post

   
  #2 (permalink)  
Old 02-26-2008, 06:14 AM
fitzjarrell@cox.net
 
Posts: n/a
Default Re: Using db files on another server

Comments embedded.
On Jun 11, 8:42 am, "KrzysztofB" <smu...@gazeta.pl> wrote:
> I have file-copy database backup (*.ctl, *.dbf, and .ora file) and
> need to connect these files to working server.
>


How, exactly, did you take this 'file-copy database backup'? Also,
how did you transfer these files from one server to another? And, are
you transfering these files to a server with the same operating system
as the source server?

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


Until you post the exact steps you used to create this backup and
transfer it to the destination server no one will be able to tell you
much.

>
> -----------------------------
> 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.
>


How did you copy these files?

> 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


Please provide much more information than you have if you want help in
resolving this.


David Fitzjarrell

Reply With Quote