Re: backup logical-logs

In article <34D6E227.377F1C07@informix.com>, Mark D. Stock <mdstock@informix.com> writes >Steve Leung wrote: >> >> Hi, >> >> Wonder do people in real world actually backup logical logs? > >Of course! That's the whole point of using transactions; so you can >recover back to the point of the failure. > >> Do they use "ontape -c"? What good is "ontape -a"? > >They use both. Use OnTape -c if the logs will fill before a scheduled >backup. Use OnTape -a at scheduled backup times. > Remeber that ontape -a will OVERWRITE the contents of the tape. Hence you need to put in a new tape EVERY time you do an ontape -a. We normally use a ontape -c to a 2G DAT tape or 150Mb QIC-150. Remember that for large loads do a level-0 archive, stop logging, load the data, enable logging and do another level-0 archive. Hence 150Mb or 2GB for a large system should be fine. People rarely type>150Mb in a day!! >> Are third-party backup/restore software popular in Informix >> community? Which are the winners? > >Haven't seen any. > >> Please share your experience. > >Backup your logs as part of a well thought out disaster recover plan. >People never like to think of restoring, but hardware DOES fail >sometimes. :-) > >Cheers, -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care