Last saturday while taking backup (export) via TOAD i got an error like "there is no enough space in the output dumpfile specified location (E drive)".
There is no enough space in the E: drive to a full DB backup so my export session terminated.
In that E: i have three datafiles.
My problem is, yesterday i cant start my database it gives error like
"cant read datafile header 13
I/O datablock corruption error" the datafile which is in the E drive is corrupted.
my question is, Did the export which i took last saturday caused this? plz give me some sugesstions. am in a critical situ...
It doesn't matter what corrupted your datafile; just hope you have a real backup and not an export.
By the way, still amazes me yet, it doesn't surprises me anymore how people insist to put the words "backup" and "export" in the same phrase. If you do not have a real backup you are going to learn now "export is not a backup"
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
As PAVB said, if you do not have real backup, then recreate the database, import last good dump and let the people reenter all the data since the last dump
Reply With Quote
Bookmarks