Re: backup logical-logs

Neil Truby wrote in message <34D632EE.AAE@netcomuk.co.uk>... >Steve Leung wrote: >> >> Hi, >> >> Wonder do people in real world actually backup logical logs? Yes. >> Do they use "ontape -c"? What good is "ontape -a"? "ontape -a" will work fine as long as you are sure that you will not fill your logs in between backups. "ontape -c" works well as long as you have someone (operator) to watch a dedicated console and change tapes when it fills. >> Are third-party backup/restore software popular in Informix >> community? Which are the winners? IMHO, OnBar is the choice solution. After your first installation it is not that difficult to set-up or use. You must have a 3rd party storage manager (like Legato Networker). When a logical log fills it sends alarm 23 to the ALARMPROGRAM script set in ONCONFIG. You simply set it to call "onbar -l" and OnBar will connect to the storage manager and back up the log. It works very well. >> >> Please share your experience. >> >> /steveleung > >My experience is this people use ontape -c. Onarchive is a pile of >crap. I've not used onbar, but those who have seem to think it's OK. Onarchive is not a pile of crap, it actually works well. The 'interface' to Onarchive is a pile of crap. ;-) > >ontape -a is OK for freeing up logs in an emergency, but not much use>for regular admin. > >Neil Truby >Chase Manhattan Bank >Bournemouth, UK >neil.truby@chase.com Whatever you choose it really depends on how much data you are talking about. ============================================== James Larned Database Administrator The Money Store james_larned@themoneystore.com ==============================================