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!

manually deleted some of the data files.

817257Nov 16 2011 — edited Nov 16 2011
there was some issue in the AIX server regarding space, resolving it i manually deleted some of the datafiles from the server.now i can neither shutdown nor restart the database.

ORA-01116: error in opening database file 41
ORA-01110: data file 41: '/data2/oradata/PULSEU02/pulse_st_idx_hgh_002.dbf'
ORA-27041: unable to open file
IBM AIX RISC System/6000 Error: 2: No such file or directory

How can i solve this problem. Since this is a dev performance server so there is no backup.
This post has been answered by Think_dba on Nov 16 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 14 2011
Added on Nov 16 2011
11 comments
3,992 views