Re: recover data
Date: Mon, 10 Nov 2008 15:02:42 -0800 (PST)
On Nov 10, 1:30 pm, Palooka <nob..._at_nowhere.com> wrote:
> joel garry wrote:
> > On Nov 8, 12:35 am, paolo <NOSS..._at_gmail.com> wrote:
> >> hi all,
> >> i'm running in a trouble because the raid container where my /oradata
> >> (windows 2003 with oracle 126.96.36.199) was installed failed (of corse no
> >> backup, n odump, nothing at all..it 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?".
I don't know what they paid, but just recovering some files off a Windows software raid... a few thousand dollars? Once Oracle DUL gets involved, we're talking tens of thousands of dollars, arent' we? I don't disagree with you or Sybrand, the OP just needs to know options. Maybe they have enough to do something without DUL. Then again, there's some Polish place where you just upload your data files there... and some guy in China... yeesh.
I find the "we lost our db" posts highly entertaining, and sometimes even educational. Backups are the most basic thing! Recovery is the Only Thing!
To Paulo: Sybrand gave you a clue, you might be able to use your new db to generate an editable controlfile (alter database backup controlfile to trace;), then you might be able to edit it to use all your recovered files. Or not. But you can't use the dbid changing utility with those screwy datafiles, so don't bother trying to use the new db with the old data.
-- @home.com is bogus. “You have the same rights – you can marry who I can marry.” - 'Isi Mataele, Mormon schoolteacher, to about 30 really upset gay-rights protesters. 40% of $30M Yes on Proposition 8 campaign funds were estimated to come from Mormons. There are approximately 750K Mormons in California. http://wiki.answers.com/Q/How_many_gays_live_in_CaliforniaReceived on Mon Nov 10 2008 - 17:02:42 CST