RE: Recovering data from a raw device....
Posted in 2000
-----Original Message----- From: Chris Hall [mailto:Chris.Hall@OrbisUK.com] Sent: Wednesday, December 13, 2000 5:51 AM Posted To: informix Conversation: Recovering data from a raw device.... Subject: Re: Recovering data from a raw device.... 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? 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 - Scott> Bummer! Perhaps the tables had grown extra extents from the original. Andrew was right, it was too much to hope for. Chris> 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... Scott> Glad to hear it. Let us know if you need help devising an appropriate penalty for whoever dropped the ball on the backups! Chris -- ************************************************************** Chris Hall Email: Chris.Hall@OrbisUK.com Orbis Tel: +44 208 742 1600 http://www.OrbisUK.com Fax: +44 208 742 2649