Re: Help with full logical logs

In article <36432D24.779F@bloomberg.net>, Art S. Kagel <kagel@bloomberg.net> writes >Joachim Scherer wrote: >> >> Hi: >> my logical logs are full. ontape -a doesn't work anymore. How can free >> the logs without loosing my data. And hopefully without doing a restore. > >Right, ontape -a will not work if the last log is full because it >cannot log the fact of the log backup. I guess you have LBU_PRESERVE >set to 0 or not present in your ONCONFIG. The only option is to change >LTAPEDEV to /dev/null in onmonitor (changing it in the file is not >enough it has to be changed in memory unlike TAPEDEV so you need to use >onmonitor). > >This will cause all logs to be wiped clean without saving them. For But this gets logged. Also notice CKPT REQ hence a latch is held which manes you are stuck. Informix will need to dial in and use tbszero to fix. Nasty but you are stuck... Changing LTAPDEV=config change which surely gets logged... >safety IMMEDIATELY after the logs clear up run ontape -s -L 0 to get >a FULL backup since you have just thrown your log files away (you can >probably get away with a -L 1 or -L 2 if the level 0 is very recent but >I like to be safe and use -L0 after a near disaster). After that >change LBU_PRESERVE to 1 in your ONCONFIG file so that the last log >file cannot fill up then you will be able to us ontape -a to recover >next time. Don't forget to change LTAPEDEV back and to bounce the >server when the archive is complete to get the new LBU_PRESERVE value >activated. > >Art S. Kagel > >PS- Be thankful you are not using Sybase where this problem means doing >a full restore to recover. -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care