RE: Customer dropped important large table....

Hmmmmmmm. Isn't there something in the IIUG archives that allows a single table extraction from an ontape archive? If I remember correctly, the only limitation is that it can't be a fragmented table. John Carlson Informix DBA EDS - WHSmith USA 3200 Windy Hill Road, Suite 1500 West Atlanta, GA 30330 > -----Original Message----- > From: Rudy Fernandes [mailto:rferdy@americasm01.nt.com] > Sent: Thursday, October 19, 2000 8:00 AM > To: informix-list@iiug.org > Subject: Re: Customer dropped important large table.... > > > Sally Woolrich wrote: > > > On Wed, 18 Oct 2000 20:20:28 +0100, Rudy Fernandes > > <rferdy@americasm01.nt.com> wrote: > > > > >You should be able to carry out a dbspace restore to > current using Monday > > >night's Level 0 and all subsequent logical log backups. > > > > > >Rudy > > > > Surely this would include dropping the table - database changes get > > included in the logs for IDS? > > > > That's right. A dbspace restore would not work as it always > get done to > current. Looks like a Level 0 restore to the point in time > just before the > drop is one way to go. > > Alternatively, if you need the table and need to stay current, the > point-in-time restore to just-before-drop could be done on a > different box > (identical chunks, etc), and the table copied over to Production. > > Rudy >

In article <8sn4tu$esd$1@news.xmission.com>, John Carlson <John_Carlson@whsmithusa.com> writes > >Hmmmmmmm. Isn't there something in the IIUG archives that allows a single >table extraction from an ontape archive? If I remember correctly, the only >limitation is that it can't be a fragmented table. > >John Carlson >Informix DBA >EDS - WHSmith USA >3200 Windy Hill Road, Suite 1500 West >Atlanta, GA 30330 > > > >> -----Original Message----- >> From: Rudy Fernandes [mailto:rferdy@americasm01.nt.com] >> Sent: Thursday, October 19, 2000 8:00 AM >> To: informix-list@iiug.org >> Subject: Re: Customer dropped important large table.... >> >> >> Sally Woolrich wrote: >> >> > On Wed, 18 Oct 2000 20:20:28 +0100, Rudy Fernandes >> > <rferdy@americasm01.nt.com> wrote: >> > >> > >You should be able to carry out a dbspace restore to >> current using Monday >> > >night's Level 0 and all subsequent logical log backups. >> > > >> > >Rudy >> > >> > Surely this would include dropping the table - database changes get >> > included in the logs for IDS? >> > >> >> That's right. A dbspace restore would not work as it always >> get done to >> current. Looks like a Level 0 restore to the point in time >> just before the >> drop is one way to go. >> >> Alternatively, if you need the table and need to stay current, the >> point-in-time restore to just-before-drop could be done on a >> different box >> (identical chunks, etc), and the table copied over to Production. >> >> Rudy >> In the end they decided to lose the mornings work. Hopefully all will be well soon. Nasty! The culprit is probably in deep hiding. -- Surfer!