Re: recovery question - somewhat urgent...

AK wrote:

> Hi,
>
> You'll be telling this one to your dba mates in the pub...I'm sure of it.
>
> I have a development database which lost an unmirrored and not backed up
> disk. This disk happens to have held the system, users, rbs datafiles
> (amongst a couple more that I dont care about).
>
> No I do not have a tape backup of the system datafile. No I did not
> design this incredibly silly setup. However, I am now responsible for it.
>
> I have rebuilt the host (TRU64 4.0G - yes it is an old version :), and
> have things to a point where I have an instance running, database
> mounted and I cannot open the database (obviously). I have all the
> datafiles used by the development team online and available. The disks
> that did not get fried still have 'usable' datafiles on them.
>
> In this 'closed' state can I grab the data from these datafiles? I have
> one in particular that I would like to recover the data from.
>
> Without media recovery as an option can I rebuild a system datafile? Not
> sure about this and I have been going at it for a while so I cant focus
> on the screen very well.... :|
>
> Please help.
>
> -A

With no backup, you can't get the surviving database files back into use at all, I'm afraid, as I sense you kind of guessed.

Oracle Corporation have tools to extract data out of orphaned data files, but they are not cheap, and you'd need to contact them directly in any case.

Short of those disaster recovery tools, there is nothing you can do.

Regards
HJR Received on Tue May 04 2004 - 06:36:38 CDT