Recovering data from a raw device....
Posted in 2000
I find myself in an odd situation:
Someone (no, not me) has just dropped all the tables from a database
which, for reasons unknown, hasn't been backed-up for some time (i.e.
months). To compound the error, new definitions of those tables were
then added, for example:
drop table table1;...
drop table tableN;
create table table1 (
<columns>
);
create table table2 (
<columns>
);
I'll find the reason for the backup failures and arrange for the
appropriate penalty to be exacted, but in the meantime, all I have is a
"dd"'d image of the raw partition where the data resided. I can see with
"od" that there is some meaningful data left, and it seems to be in
fairly large table-related contiguous chunks (the tables were originally
created with sensible extent sizes).
Are there any tools, official or otherwise, which will allow me to
extract anything meaningful from this mess?
I'd be grateful for any straws to clutch at...
Chris
--
**************************************************************
Chris Hall Email: Chris.Hall@OrbisUK.com
Orbis Tel: +44 208 742 1600
http://www.OrbisUK.com Fax: +44 208 742 2649