Re: Logical log restore question

If you don't mind tying up a window on a PC or the console screen, why not use ontape -c ?? Stop it each evening when you do your level 0 then re-start it in the morning ( ensuring you have enough logical logs to cope with evening activity ). An alternative would be to use onbar instead. ontape -a will only write what logs are complete to the file indicated byLTAPEDEV in $ONCONFIG - if you sent it to a tape device each time, the tape would rewind and overwrite whatever logs are there. Again, you are also correct in assuming that when you came to restore, you would have to rename each log file to the LTAPEDEV file name as and when each log had restored bit messy ). onbar -l will add the logs to a tape device without rewinding the tape soyou can keep adding each log as and when it fills. The storage manager takes care of where it stores the logs and on which tape. To backup the entire instance use onbar -b -w ( parallel onbar archives can cause problems ). The only tricky bit is configuring the storage manager to write to a disk device. Hope this helps. Sean Gabor Heppes wrote in message <366DCE52.836D559B@westpac.com.au>... >Hi, > >I am trying to set up the backing up of logical logs using an alarm >script. I use ontape -a in the script to backup to a disk file, then >rename it using the number of the logical log that was backed up (or the >number of the first if multiple logs were backed up, although this would >rarely happen) as part of the file name. > >What do I do at restore time? I was hoping that I could just concatenate >the backed up logs and restore them in one go, but that does not seem to >be happening. Informix will just restore the first one -- I suspect >there's a record at the end of each log file that tells ontape that it >has reached the end. > >The alternative is to copy the log files one by one every time ontape >asks if I want to restore another log tape. The problem is I can >accumulate > 100 logs within a day (level 0 archives are taken daily). > >Has anyone used a (semi-)automated script to restore a large number of >logical logs? > >Any suggestions appreciated. > >TIA > >Gabor Heppes