Re: Help with full logical logs

>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 >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 >Art S. Kagel > >PS- Be thankful you are not using Sybase where this problem means doing >a full restore to recover. Hi, As a matter of fact I've had the same problem many times,but we use OnLine 5.08UD1 and on this version I couldn't find LBU_PRESERVE to set it to 0,but after lots of troubles I found out a trick.I couldn't to backup my logical logs to even /dev/null and this was because of a long transaction.I put my restore tape in tape drive and after reading first block of tape and when it prompts "Restoring data..." I interrupted it by interrupt key and all my logical logs was clean and never lost any data. bye --babak ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com