-
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:
Startup nomount;
recover database until cancel;
[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.
V.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|