Recovery Question

Hi,

I am using Oracle 10.2.0.2.0 on Windows Server 2003. We had a machine die on us whilst the Oracle instance was not running. We have no backups (the data isn't really critical, and it is customer data so we cannot back it up anyway).

Anyway, the machine died. It has been rebuilt with different drive letters. We have all of the data files, control files etc and so I think it is probably possible to sort this out. I tried recreating the instance, backing up control file to trace, starting it in NOMOUNT mode, then editing the create control file statement to include the data files etc.
I kept getting errors about sizes not being correct, and it appeared that for a particular size of 7GB, it just would not work!

What I want to know is how people would approach this problem in order to recover. The instance was not running, I have all the files, so it should be relatively easy. But I have never done this before, and I cannot really find any info out about it.If anybody can suggest anything or point me to an article on how to do this then that would be appreciated.

Please don't remind me of the importance of backups - the data is a customer database with confidential data so we cannot back it up.

Many Thanks in advance!

Paul Received on Mon Jul 23 2007 - 07:25:05 CDT