SEO

#1 (**permalink**) 02-26-2008, 06:14 AM

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

#2 (**permalink**) 02-26-2008, 06:14 AM

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

#3 (**permalink**) 02-26-2008, 06:15 AM

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

#4 (**permalink**) 02-26-2008, 06:15 AM

Dnia Mon, 11 Jun 2007 07:05:06 -0700, "fitzjarrell@cox.net"
<fitzjarrell@cox.net> napisa³:

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

>[..]
>Please provide much more information than you have if you want help in
>resolving this.
>David Fitzjarrell

I don't know and don't have any chance to findout the source OS.
I got hdd with set of data files so I think I have files copied from
data directory and initXXX .ora file
I got also user/pass for source db but I don't know I need it.
And now I have to retrieve data from these files...

KrzysztofB

#5 (**permalink**) 02-26-2008, 06:15 AM

On Mon, 11 Jun 2007 21:59:42 +0200, "KrzysztofB [smuter]"
<smuter@gazeta.pl> wrote:

>Dnia Mon, 11 Jun 2007 07:05:06 -0700, "fitzjarrell@cox.net"
><fitzjarrell@cox.net> napisa?:
>
>>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?
>
>>[..]
>>Please provide much more information than you have if you want help in
>>resolving this.
>>David Fitzjarrell
>
>I don't know and don't have any chance to findout the source OS.
>I got hdd with set of data files so I think I have files copied from
>data directory and initXXX .ora file
>I got also user/pass for source db but I don't know I need it.
>And now I have to retrieve data from these files...
>
>KrzysztofB

I recommend to take a hex editor and start at byte 0.
The information you seem to have is woefully inadequate, so you are
simply out of luck. You should at least have the results of alter
database backup controlfile to trace;

--

Sybrand Bakker
Senior Oracle DBA

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Using db files on another server