Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: corrupt datafile
Hanne
email me directly and I can give you some contact details for a UK company I have used to recover two customers databases. They gave prompt service at a reasonable cost and only charge if they can recover the data.
Regards
Tony
"Hanne Iren Midttun" <hannem_at_tihlde.org> wrote in message
news:Pine.LNX.4.21.0301030823210.27999-100000_at_colargol.tihlde.org...
> On Thu, 2 Jan 2003, ronia wrote:
>
> > Supose I have only a datafile data.dbf
> > I not have system.dbf, redologs.dbf temp.dbf etc.
> >
> > Are anyway to recover the data. At least manualy???
> > I heard that Oracle Consulting can do it.
>
> If it's only a tiny amount of data and all the data are varchars (text),
> you can read the data in unix this way:
> cat <your database file> | strings | <and then a more or a less>
>
> This is only if you are desperate :) I recomand calling Oracle.
>
> (I learned this when a worked with a really clever Unix type. One day he
> told me that his name was not in the database. I asked how the heck he
> know - he could no oracle commands, and then he showed me this. The sad
> thing - from his point of view - is that you can't read numbers, blobs,
> dates.. and so on...)
>
> regards Hanne
>
Received on Fri Jan 03 2003 - 08:24:02 CST