Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Using db files on another server

Re: Using db files on another server

From: <fitzjarrell_at_cox.net>
Date: Mon, 11 Jun 2007 07:05:06 -0700
Message-ID: <1181570706.718178.16270@h2g2000hsg.googlegroups.com>


Comments embedded.
On Jun 11, 8:42 am, "KrzysztofB" <smu..._at_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 Received on Mon Jun 11 2007 - 09:05:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US