Re: Totally confused - head crash with oracle HD

hi simone,

you could make a copy of the controlfile, and view with a fileviewer on your <unspecified> Operatingsystem if and where your database aspect your datafiles. the controlfile is binary, but you may identify the strings for the filelocations.

check your alertlog (if any) in what state the database was. with a litle luck you may recover (i doubt that)

hth.

s.kapitza

simone.stoiber_at_jku.at (Simone Stoiber) wrote in message news:<6f9cc1b8.0201160701.334ca4be_at_posting.google.com>...
> Hi,
>
> I'm in great trouble - the ORACLE database for our website and the
> DBMS are lost because of a head crash. All I could find "as backup"
> was
> 1. ctl1.ora
> 2. ctl2.ora
> 3. indx.ora
> 4. log1.ora
> 5. log2.ora
> 6. rbs1..
> 7. sys1..
> 8. usr1..
> 9. tmp1..
> 10. init...
> AND a 160 MB file called Institut without file extension, that
> contains data from the website.
> Unfortunately, I don't know when and how these files were created but
> the file Institut seems to be "young".
>
> Now I face following problems: I installed ORACLE on another machine,
> created a database and tried to attach the file Institut as ora data
> file to the USR tablespace.... nothing happened. I've read some
> messages in this newsgroup concerning recovering, mounting and so on
> and I must admit that I'm totally helpless :-(
>
> I depend on your help!
>
> Many thanks in advance,
>
> Simone
Received on Thu Jan 17 2002 - 01:49:33 CST