Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using db files on another server
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. >>
>> 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
![]() |
![]() |