Last post Nov 29, 2015 09:06 PM by ingivaldimarsson
Nov 17, 2015 07:01 AM|ingivaldimarsson|LINK
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 17, 2015 11:05 AM|Lannie|LINK
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.
Nov 19, 2015 08:15 AM|andrzejturek|LINK
Maybe you should read the recommendations on this resource.
Nov 19, 2015 08:17 AM|andrzejturek|LINK
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.
If this does not work and you have no backup, I do not think of any way to recover the database otherthan rebuilding.
Nov 29, 2015 09:06 PM|ingivaldimarsson|LINK
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!