Re: HELP : All logical logs are FULL

On 10/15/06, Torben Hansen <abrtha@almbrand.dk> wrote: > All my logical logs are full and I have a long running job that have filled > the logs. > I tried to do a backup of the logs with "onbar -b -l", but that gave my the > following error : > > 2006-10-15 23:50:13 1270002 1343726 (-43381) The logical logs are full. > ON-Bar may encounter errors writing to > the sysutils database. > > Then I tried to change the LTAPEDEV in my onconfig to "LTAPEDEV > /dev/null" and tried a backup of the > loggs again but now get the following error : > > 2006-10-16 04:56:42 1056802 942238 ERROR: Logical Logs will not be backed > up / salvaged because > LTAPEDEV value is /dev/null . Normal backup (onbar -b) cannot be done > without logical logs being backed up, > because restore of such backups requires a logical log restore. > 2006-10-16 04:56:42 1056802 942238 > /software/informix/10.00.fc4/bin/onbar_d co > mplete, returning 156 (0x9c) > > Please HELP You seem to be running IDS 10.00; it probably doesn't matter, but which platform are you running on? Since IDS 10.00 can add logical logs on the fly (for situations such as this), I suppose we must assume that you have the feature disabled? Try using ON-Tape to back up the logical logs instead of ON-Bar. However, after doing that, you will need to do a whole system backup or otherwise re-establish your recovery point. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/