Trouble opening up a DB after removing a dbf manually

From: bob <bshahali_at_bevertec.com>
Date: 10 Nov 2005 09:06:54 -0800
Message-ID: <1131642414.086053.172920@g49g2000cwa.googlegroups.com>

Dear Oracle Masters,
I have deleted a file through unix (BOBBY_TBSP.dbf ) because it was corrupted and now my oracle instance does not start up, using my username and password:

-bash-3.00$ sqlplus testdb/testdb

SQL*Plus: Release 9.2.0.6.0 - Production on Thu Nov 10 10:48:21 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

when I log in to sql through sysdba and I try to startup the instance these are the error that I get:

SQL> startup
ORACLE instance started.

Total System Global Area 320303288 bytes

Fixed Size                   737464 bytes
Variable Size             285212672 bytes
Database Buffers           33554432 bytes
Redo Buffers                 798720 bytes

Database mounted.
ORA-01157: cannot identify/lock data file 11 - see DBWR trace file ORA-01110: data file 11: '/u01/oracle/oradata/testdb/BOBBY_TBSP.dbf'

Please let me know how can I recover this .dbf file after removing it manually.

Thanks a lot for your time
Bobby Received on Thu Nov 10 2005 - 11:06:54 CST