missing DBF file

[prav_saras]

You can try out the following
1) Backup the control file to trace (of standby)
2) shutdown the db and copy the missing datafile to its destination
3)Open the controlfile trace and you will find that one the datafile name is given as missing100....
4) Change that name to the name of the datafile you juct copied(with path of course)
5) Recreate the controlfile (backup the original one first )
6) mount the database, do recovery (if needed), open the database.

HTH

Hi,
Thanks to all, the above solution works.

regards,

praveen