ORA-01219: database not open

[osman7king]

I am working on Oracle database 10G. My database was working fine till last night but today when i tryed to connect, it was showing me following error:
ORA-01219: database not open: queries allowed on fixed tables/views only

So I did the following steps from command prompt:

C:\>sqlplus
 
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Jul 7 10:49:58 2011
 
Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.
 
Enter user-name: / as sysdba
 
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
 
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
 
Total System Global Area  251658240 bytes
Fixed Size                  1289964 bytes
Variable Size             163578132 bytes
Database Buffers           79691776 bytes
Redo Buffers                7098368 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: 'C:\ORACLE\TABLE_SPACES\SWT_TBLSPC'
 
 
 
SQL> select * from dba_users;
select * from dba_users
              *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
 
 
SQL> select open_mode from v$database;
 
OPEN_MODE
----------
MOUNTED
 
 

Then I tried to open the database but I got errors:

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: 'C:\ORACLE\TABLE_SPACES\SWT_TBLSPC'
 
 
 

I checked this path but it is not available physically

SQL> recover database until cancel;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 7: 'C:\ORACLE\TABLE_SPACES\SWT_TBLSPC'
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: 'C:\ORACLE\TABLE_SPACES\SWT_TBLSPC'
 

So, what is the problem?
may someone explaine and fix this problem?

regards
Osman

[rski]

What changed since the last time oracle started successfuly?
Did you remove manually or rename any oracle files?
Does the file C:\ORACLE\TABLE_SPACES\SWT_TBLSPC exist?


If you or somebody removed that file a dn you are sure it is not needed you can try below

alter database datafile 7 offline drop;
alter database open;
 

[osman7king]

I'm not sure if there is any changes for oracle files.
The file C:\ORACLE\TABLE_SPACES\SWT_TBLSPC does not exist.

this file was not important
So I executed the statements above, and the problem has been solved.

But I have a question, what is the solution for this problem if I need the deleted file?

THANKS.

[rski]

If you need the deleted file you will have to recover data backup.

[osman7king]

Thanks alot rski for your help.

osman.