Re: Recovery Question

On Jul 23, 7:25 am, Paul <paulwragg2..._at_hotmail.com> wrote:
> 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

I expect that since Windows Server 2003 is a 32-bit 'operating system' you will have problems with files greater than 2 GB in size. Possibly you won't have this restriction with raw partitions.

Was this database ever running?

David Fitzjarrell Received on Mon Jul 23 2007 - 07:41:11 CDT