how to recover 10G database with missing data file:
After a bad blocks on hard disk that corrupt data file, I ran fsck to repair
the problem, but the datafile been deleted from disk by the fsck.
This data file store User table space (tables, packages, etc…)
The database is 10g Enterprise Edition Release 10.2.0.1.0
The OS is Linux
The data base was running on Archive Mode
I use to make Cold backup's without rman, simply I shutdown the db and then copy the folder that contain the data & control files .
The last two cold backups not worth, it copied the damaged datafile with problem, and take half of it's size.
The last good backup I have is from January and luckily I keep with it all the archive files ( a few hundreds) from backup day until problem date.
Now after fsck delete the corrupt data file The rest of the database with out the missing datafile seems to be fine, I can connect normally to other users.
There are some options to recover the database, I do not know wich and how ?
recover the last backup from January with the archive files
as different database and then:
a) take the missing datafile into the current database ?
b) use the backup archive database as the current database ?
c) any suggestion ?
what is the best way and how to do it ?