Accidentally Deleted Datafile

Once upon a time i Ramadhan, there were an introduction session to oracle structure conducted by Boss. In that session, Boss keep remind us.

"Don't you ever delete the datafile through operating system level because it will make your database cannot start. The reason is the user in the database is tagged with particular datafile"

Something magic was happened that night where we - Boss and Me (read Boss) proudly deleted by typed this bloody command in Linux AS Server.

rm -rf datafile01.dbf

Hahahahaha... that's the magic.

The final solution is to ask Mr Tom, "To Tom...we have a little bit problem here. Our Oracle 10G cannot start because we accidentally deleted the datafile"

Mr Tom didn't respond to our problem.

Ok let's go to Mr Google. The same question to Mr Google. And Mr Google reply please visit this page.

To whom it may concern:

1. Don't delete datafile by OS level.
2. Don't delete datafile by OS level.
3. Don't delete datafile by OS level.
4. Always keep in mind Mr Tom is your friend in Oracle
5. Mr Tom is not Mr Google's friend