Hi!

Today when I started our development server, oracle failed to open a datafile giving error ora - 01157 'cannot identify/lock datafile'.

We don't have backup of datafiles, so can some thing be done or will I have to created the new database and imort from the latest dump.

Also can somebody tell the possible reasons for why this happened so as to avoid such problem in future.

Thanks.

Shruti