Hopefully you had multiple control files and you moved one of them to
a differnt disk. (See
Moving a Control File
in my Oracle notes.) If not, then hopefully you have results of doing
a "backup control file to trace", like Don was talking about. If not,
then you have to
recreate the control file
from scratch. I think those are the only three options.
Janine, what do you mean by "recover Oracle from his development
system"? You mean the actual Oracle software?
Dion, since the database is intact, why does it matter whether it was
running in archive log mode or not? Something to do with having to
recreate the control file? I don't remember whether that matters...
