Wednesday, October 30, 2013

Recovering Database after manual delete of DBF files

Issue after deleting

When we try to shutdown the DB

ORA-01116: error in opening database file 41
ORA-01110: data file 41: '/data2/dbfname.dbf'
ORA-27041: unable to open file


 Solution

Shutdown abort


exit

sqlplus sys/xxx as sysdba

Alter database mount

alter database datafile '' offline drop;

Alter database open

No comments: