Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01110 ORA-27041

381879Mar 19 2004 — edited Mar 23 2004
I accidently deleted some datafiles that were part of a tablespace. I don't care about the data because I had not yet used these datafiles. But when my database won't startup because it has the following error in the trace file.

I dont have a back up of these files.

How do I solve this problem.

Thanks
Venkat


ORA-01157: cannot identify/lock data file 54 - see DBWR trace file
ORA-01110: data file 54: 'E:\ORACLE\ORADATA\INDEXTABLESPACE\INDEXTABLESPACE2.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-01157: cannot identify/lock data file 55 - see DBWR trace file
ORA-01110: data file 55: 'E:\ORACLE\ORADATA\INDEXTABLESPACE\INDEXTABLESPACE3.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-01157: cannot identify/lock data file 56 - see DBWR trace file
ORA-01110: data file 56: 'E:\ORACLE\ORADATA\INDEXTABLESPACE\INDEXTABLESPACE4.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-01157: cannot identify/lock data file 57 - see DBWR trace file
ORA-01110: data file 57: 'E:\ORACLE\ORADATA\INDEXTABLESPACE\INDEXTABLESPACE5.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-01157: cannot identify/lock data file 58 - see DBWR trace file
ORA-01110: data file 58: 'E:\ORACLE\ORADATA\INDEXTABLESPACE\INDEXTABLESPACE6.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 20 2004
Added on Mar 19 2004
3 comments
1,572 views