The only mode that you can transfer datafiles is with tablespace
"transportable" mode.
I don't really think that you can transfer entire database files to another
server..
> 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 - 13:42:34 CDT
