Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP!! Corrupted database, datafiles lost.
Call Oracle support - the only rescue here is DUL - it'll put you back 250$
an hour - even if you lost the system they'll create
sqlloader flatfiles for you (including controlfile).... however because you
lost the system tablespace all tables will now be called
object1 to object9999999 with columnnames like col1 to col9999
If the database is small they'll ask you to put the DB on CD and bring it to
them ....
I'm trying to reverse engineer the datafiles on my own free time and hopefully this will result in my own DUL ... http://sourceforge.net/projects/jdul
"Javier Arregui" <jarregui_at_elasa.siemens.es> wrote in message
news:9tedsp$t9c$1_at_news.mch.sbs.de...
> Hello,
>
> Due to an accident, we have lost the following files from one of our
remote
> clients production database: control*.ctl, rbs01.dbf, redo*.dbf,
> system01.dbf, temp01.dbf, tools01.dbf and users01.dbf. The rest of the
*.dbf
> (our own tablespaces, the real data) are safe.
>
> Of course, there is no backup. A very interesting situation.
>
> Before killing some people, we have tried the following:
>
> 1. Create a new database with EXACTLY the same structure.
> 2. Overwrite our *.dbf with the safe ones.
> 3. Try to create a new control file from the one just created.
> 3.1 SVRMGR> alter database backup controlfile to trace;
> 3.2 Edit the trace and try with 'CREATE CONTROLFILE REUSE DATABASE...'
> Obtain ORA-01159: "File is not from same database as previous
files -
> wrong database id"
> OK: every datafile stores info about the database id, and the one
in
> our safe files is different from the one in the new.
> 3.3 We have discovered that in every datafile header, in the position
> 201C
> of the file, the database id is stored (the one obtained with
> SELECT DBID FROM SYS.V$DATABASE). After change it in one sample
> datafile and try again, we obtain:
> ORA-01210: data file header is media corrupt
>
> And that's all. We don't know what more to do. Is it really possible to
> alter the datafile header for this purpose?
>
> Any help is greatly appreciated.
> Thanks,
>
> Javi
>
>
>
Received on Tue Nov 20 2001 - 14:26:59 CST