Deleted Database recovery
572889May 7 2007 — edited May 7 2007The Scenario is one of my client , here on main server(Microsoft Windows Server 2003 Sp2) there are 6 instance running. Someone has deleted the one database named HBDMS. So now there were no database files on disk i.e no datafiles, no archivelog files, no control file and spfile. Since they have no backup of this database they have send the Disk for Os level recovery so that deleted files can be recovered.
Now till present they have recoved all the files. I have placed all the files in correct location by taking database in mount state and seeing information from control files but when i am trying to recover the database it is saying that files header are corrupt.
I have queried the v$DATAFILE_HEADER for the header and file recovery information there it is showing that WRONG FILE TYPE of the datafiles recovered.
SELECT NAME,RECOVER,ERROR,CHECKPOINT_CHANGE# FROM V$DATAFILE_HEADER;
D:\ORACLE\ORADATA\HBDMS\SYSTEM01.DBF WRONGFIILETYPE 0
.....
......
.....
And when i try to recover...
SQL> recover database
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\HBDMS\SYSTEM01.DBF'
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\HBDMS\SYSTEM01.DBF'
ORA-01251: Unknown File Header Version read for file number 1
SQL> recover database until cancel
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\HBDMS\SYSTEM01.DBF'
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\HBDMS\SYSTEM01.DBF'
ORA-01251: Unknown File Header Version read for file number 1
I think the files they have recovered are of no use for oracle since it can read it.
Please help me out..
Pankaj