Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> recovery question - somewhat urgent...

recovery question - somewhat urgent...

From: AK <ak_at_ak.org>
Date: Tue, 04 May 2004 11:32:25 GMT
Message-ID: <dbLlc.1843$IH5.84163@news.optus.net.au>


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 Received on Tue May 04 2004 - 06:32:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US