RE: Recovering data from a raw device....

-----Original Message----- From: Andrew Hamm [mailto:ahamm@sanderson.net.au] Sent: Monday, December 11, 2000 6:42 PM Posted To: informix Conversation: Recovering data from a raw device.... Subject: Re: Recovering data from a raw device.... Scott Black wrote in message <913g4s$j57$1@news.xmission.com>... > >Actually re-creating the tables is the first step, [clipped] Andrew> Excepting that the plan will most likely fail unless the table partitions land in EXACTLY the right place, [clipped] That's pretty much the point. If his tables were created with a properly sized first extent originally, and if he re-creates them in the same order, then they will land in EXACTLY the right place. A long shot perhaps, but he did ask for "any straws to clutch at"

Scott Black wrote in message <915fdo$9jo$1@news.xmission.com>... > >Andrew> Excepting that the plan will most likely fail unless the table >partitions >land in EXACTLY the right place, > >[clipped] > >That's pretty much the point. If his tables were created with a properly >sized first extent originally, and if he re-creates them in the same order, >then they will land in EXACTLY the right place. A long shot perhaps, but he >did ask for "any straws to clutch at" A fair call, and a fair reply! I wonder if it works? Can you satisfy our curiosity if you try this, Chris?

Andrew Hamm wrote: > > Scott Black wrote in message <915fdo$9jo$1@news.xmission.com>... > > > >Andrew> Excepting that the plan will most likely fail unless the table > >partitions > >land in EXACTLY the right place, > > > >[clipped] > > > >That's pretty much the point. If his tables were created with a properly > >sized first extent originally, and if he re-creates them in the same order, > >then they will land in EXACTLY the right place. A long shot perhaps, but > he > >did ask for "any straws to clutch at" > > A fair call, and a fair reply! I wonder if it works? Can you satisfy our > curiosity if you try this, Chris? The tables were all put back in the same places, but obviously this doesn't really help, because the server is absolutely convinced that there are no rows in those tables - I guess you'd have to do some deeply magical and very accurate hacking of systables etc. to convince it otherwise... "dd"ing the disk image, and then using "strings" (it was names and addresses I was after) and a fairly nifty bit of Tcl proved surprisingly successful... Chris -- ************************************************************** Chris Hall Email: Chris.Hall@OrbisUK.com Orbis Tel: +44 208 742 1600 http://www.OrbisUK.com Fax: +44 208 742 2649