Re: recover data

From: Palooka <>
Date: Mon, 10 Nov 2008 21:30:54 +0000
Message-ID: <iK1Sk.50186$HK.33281@newsfe10.ams2>

joel garry wrote:

> On Nov 8, 12:35 am, paolo <> wrote:

>> hi all,
>> i'm running in a trouble because the raid container where my /oradata
>> (windows 2003 with oracle was installed failed (of corse no
>> backup, n odump, nothing at was too easy).
>> We sent the disks to a recover company and they sent me back 12 files
>> (called from file00.dbf to file11.dbf).
>> At this point i don't know how (and if this is possible) reimport my
>> data in the DB we recreate from scatch
>> dbv is able to verify the files but is i try to replace the users01.dbf
>> i0ve got an error like " dbid is different"
>> Could you please help me?
>> thanks a lot and best regards
>> Paolo


They have gone to all the time and expense of involving the data recovery company, so the data must be important. I wouldn't be trying to   save a few pennies at this stage by not involving Oracle, which in fact I would have done anyway from the outset of the problem, had I been called in at the point of loss.

But then of course, had any DBA with even an eighth of a brain been involved, there would have been backups from which to restore and recover. Sorry if I sound like Mr. Angry, but it is difficult to sympathise with people who say "We lost our database; we weren't in archivelog mode and we never bothered with backups. How do we recover?".

Palooka Received on Mon Nov 10 2008 - 15:30:54 CST

Original text of this message