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

  • Question

  • User531855817 posted

    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????

    Tuesday, November 17, 2015 7:01 AM

Answers

  • User146715808 posted

    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 Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, November 19, 2015 8:17 AM

All replies

  • User269602965 posted

    Do you have ORACLE ARCHIVE LOGGING enabled?

    If so, rebuilding the data file can be done with SYS DBA level access from the REDO logs and archived REDO logs.

    Tuesday, November 17, 2015 11:05 AM
  • Thursday, November 19, 2015 8:15 AM
  • User146715808 posted

    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 Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, November 19, 2015 8:17 AM
  • User531855817 posted

    Thank you guys for your feedback and help. Sorry, that long time did not respond. This is because the issue was solved and I forgot to tell.) Thank you!

    Sunday, November 29, 2015 9:06 PM