RE: ontape -l roll-forward of many logs

We had quite an interesting setup once between our PRD and hotsite which was located too far away and the pipe was too small to use Informix HDR (or whatever they call it these days). We used an EXPECT script on the hotsite..... it would "sit and spin" until a logical log bundled was ftp'd into place by the PRD script (this script was called from Informix by $ONCONFIG setting that acts when a log fills up (forgot the parameter)). On the PRD side the script would only backup the logs when 5 of them were full. Then log backup would create a bundle and then fire a script that would ftp it to the hotsite. The hotsite was in constant logical recovery mode and the expect script would, as I said, sit and spin, looking for a new log bundle to show up in the right directory and then it would pick it up and feed to the DB..... It was really slick. This was when we used Onarchive (yes!), now we use onbar and our hotsite is designed differently ..... but you could probably design something quite similar. I don't really know perl or expect, but expect was pretty easy to pick up/hack the existing infrastructure. Have fun with it :) Norma Jean -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Neil Truby Sent: Saturday, September 02, 2006 2:03 PM To: informix-list@iiug.org Subject: Re: ontape -l roll-forward of many logs "Paul Watson" <paul@oninit.com> wrote in message news:1e0801c6cea1$4c7db0c0$5583390a@arnold... > You are kidding, of course it's trivial > > mkfifo /tmp/mypipe > chmod 666 /tmp/mypipe > ontape -l < /tmp/mypipe > /tmp/ontape.out &> > Then write a simple awk script that reads the file /tmp/ontape.out via > tail -f Doesn't work for me. The script ends staright away, leaving an zero-length file /tmp/ontape.out (on Solaris). Where do you put the name of the restore file? _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================