Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

[Urgent] Recover data from oracle datafile partially overwritten

FabrizioFrigerioMay 4 2009 — edited May 5 2009
We have a big problem, we stopped a backup/restore process from production to test database because we found some code SP/Package in development was not backed up from previous test DB. Now we have oracle datafile partially overwritten and I suppose/hope the compiled code was stored at the end section of the datafile, there is a way to recover data from this datafile? I'm planning to use an exadecimal editor as last resource hoping data was not encripted but if there is a more usefull tool could be better. There are other storage location like achive logs/redo logs where we can try to find the lost code? The machine was not under a backup protocol so we can't count on this.

Help, please

Fabrizio
This post has been answered by LKBrwn_DBA on May 4 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 2 2009
Added on May 4 2009
10 comments
820 views