Re: Logical log back-ups

In article <341E4A8C.49D7@netcomuk.co.uk>, Neil Truby <ntruby@netcomuk.co.uk> writes >I think this question is mainly applicable to version 5 of OnLine. > >Suppose I have a logical log backup created with tbtape -c. It's (say) >100MBytes long, and represents the back-up of 10 x 10MByte logs. >Suppose further that, because of application error, I need to restore to >the state at the end of (say) the fourth log. > >What will be the effect if I create a truncated log back-up file of >40MBytes, then do a restore and use this truncated log to effect a >"point-in-time" roll-forward? Anyone tried it? > >Thanks > >Neil Truby >Chase Manhattan Bank >Bournemouth, UK Nope but the method Informix UK Tech Support recommend (UNOFFICIALLY) is to eject the tape. The moethd I used successfully to restore from an tbtape -c logical log tape (after ONE of my COLLEGUES WHO SHALL REMAIN NAMELESS (A!) dropped a table containing ~200,000 rows on a LIVE system) is - Make sure someone is next to the tape device and on the phone next to you. - Start the restore and get the pid of tbtape. - Run onstat -l repeatedly. - Once it gets close to where you want to stop it - get the person on the phone to eject the tape - if tbtape does not die (which it didn't) - kill -9 tbtape - wait for online to recover - tbmode -c - tbmode -l - tbmode -ky - tbinit - tbcheck -cre - tbcheck -ccID <database> Evetything was consistent A bit drastic but it worked for us (got back to the state at ~1:30pm when the table was dropped at 1:45pm). REMEMBER TAKE A LEVEL-0 ARCHIVE FIRST TO YOU CAN GET BACK TO WHERE YOU ARE NOW IF IT ALL FAILS!! -- David Williams