Unable to open database - needs media recovery
Last week we had disk failure. Unfortunetly I have lost arch logs and trc files. When we were trying to start the database, we starting getting the following error:
ORA-01113 file 8 needs media recovery.
After reading arround we tried the followings:
recover database until cancel;
alter database open resetlogs;
When we tried again, we started getting new error:
ORA-01194: file 1 needs more recovery to be consistent;
It is complaining onSYSTEM01.DBF file now. Please guide me how can open the database without latest logs and Tracefiles;
Thanks in Advance.
Click Here to Expand Forum to Full Width