HELP!! Corrupted database, datafiles lost.

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:19:35 CST