Boy, I'll bet you're gonna be a lot better about knowing how to recover a database after this little fiasco is over and done with. Don't any of your personal reference books mention how to do a recovery in this type of situation? All of mine do. Do you have a little black notebook with step-by-step instructions for what to do in a loss of an important file?

Aside from that, have you looked on MetaLink (if you have access to that)? There's, what, about 20 articles on how to do a recovery.

Have you looked at Oracle docs? They're free, and they're even correct sometimes.
http://download-west.oracle.com/docs...o.htm#BRUMG004

What a great learning opportunity you have before you. Take advantage of it.