This project is read-only.

Database mounted. ORA-01113: file 1 needs media recovery -- system01.dbf

Topics: General
Nov 10, 2015 at 12:17 PM
Database mounted. ORA-01113: file 1 needs media recovery -- system01.dbf
The only way to recover is from media backup? I know I cannot "rebuild" system datafile, but if I don't have a backup - I know shame on me!!! - Is there anyway to recover database????
Nov 12, 2015 at 11:38 AM
Edited Nov 12, 2015 at 11:42 AM
I know this might work some times if all the log files are present and not overwritten.
Just try using
"Recover datafile < >;" from sqlplus. Some times the file is marked as recovery needed, and this command removes the flag. I remember using this command when my online backup failed (system crashed while backup is in progress).
If that does not work try these:
recover database until cancel;
Then cancel the recovery.
If that does not work then try recover database until cancel using backup controlfile;
If that doesn't work, then I think you can still use the utility DBF Recovery Toolbox. From my experience I can say that it is a good helper. Maybe it somehow will save your file. http://www.oemailrecovery.com/dbf_recovery.html
If this does not work and you have no backup, I do not think of any way to recover the database otherthan rebuilding.
Marked as answer by Batehh on 11/15/2015 at 5:05 AM
Nov 12, 2015 at 11:46 AM
Marked as answer by Batehh on 11/15/2015 at 5:05 AM
Nov 15, 2015 at 1:06 PM
You've been very kind in your efforts to help. Thanks for that. Solved!