Oracle Database Discussions

Oracle 10g on windows.I shutdown the database. deleted the datafile and tried starting the database again.

SQL> startup open
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup open;
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1247900 bytes
Variable Size 79693156 bytes
Database Buffers 83886080 bytes
Redo Buffers 2945024 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\PERFSTAT.DBF'


SQL> alter tablespace perfstat offline;
alter tablespace perfstat offline
*
ERROR at line 1:
ORA-01109: database not open


SQL> drop tablespace perfstat;
drop tablespace perfstat
*
ERROR at line 1:
ORA-01109: database not open


SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\PERFSTAT.DBF'

Responses are appreciated.

null