How to open database even though a datafile is missing
                                                 Last update (2009-02-03 12:31:11)
                                                                                                                   Date added (2008-03-02 01:54:25)

Summary
You try to open the database but it doesn't open because one datafile is missing. For example /filesystem01/datafile11.dbf is missing.
Database Mounted
ORA-01116: Error in opening database file 34
ORA-01110: Datafile 34 : '/filesystem01/datafile11.dbf'
ORA-27041: Unable to open file.
Here is a dirty workaround to open the database. Connect to sqlplus as sysdba.
1. STARTUP NOMOUNT;
2. ALTER DATABASE MOUNT;
3. ALTER DATABASE DATAFILE '/filesystem01/datafile11.dbf' OFFLINE DROP;
4. ALTER DATABASE OPEN;
5. DROP TABLESPACE TEST INCLUDING CONTENTS;
Tip: In case you cannot drop the tablespace then you can try the command without the "INCLUDING CONTENTS" after dropping all the object in the tablespace. So first drop all the objects in the tablespace and second execute:
DROP TABLESPACE TEST;
Reviews
Categories
Oracle DBA-> (147)
  Alertlog (3)
  Archivelog (5)
  Auditing (1)
  Backup - Recovery (19)
  Database files (6)
  Database options (2)
  DB links (2)
  Dependencies (1)
  Dictionary (2)
  Exp-Imp Datapump (6)
  Jobs (2)
  Mview (2)
  Networking (3)
  Objects (7)
  Parameters (2)
  Redologs (6)
  Roles - Grants (2)
  Rollback - Undo (8)
  Segments (3)
  Sequences (2)
  Sessions (14)
  SGA (14)
  Tables (10)
  Tablespaces (10)
  Temp (4)
  Toad (5)
  Transactions (1)
  Upgrade (2)
  Users (3)
Oracle APPS DBA-> (66)
Exadata (1)
Performance Tuning-> (59)
Oracle Real Cases (24)
Oracle Errors (23)
Oracle SQL tricks (32)
Oracle RAC (3)
Oracle Security (8)
Filters
Search