Back-ups to Disk?
Posted in 1993
This post is related to an earlier one about logical logs and named pipes. I realize that Informix only supports archives and logical logs going to tape (via tbtape on Rel. 5) at this time. However, I would like the archive and logical logs to go to disk from which they can be backed up to tape via the daily UNIX file system backups. I imagine that if one were to dedicate enough disk space for this purpose, write the appropriate shell scripts, and arrange for this area of disk to be put to tape daily, then one would have a fairly reliable backup strategy in place. Has anyone tried this yet? Has anyone successfully restored (rolled forward) Informix from files on disk? Please reply with any information you have on this subject. Some background on this post: Our computer operations group is moving towards an 'operatorless environment'. There will be no computer operators around at night or on weekends to put tapes into DAT drives so that tbtape can send archives and logical logs to those tapes. We have recently purchased a system called Alexandria (no plug intended) which will completely handle the UNIX back ups - scheduling, library functions to track what is on each tape, control over a 'jukebox' of tape devices so that tapes can be switched in and out automatically as needed, etc. Hence the desire to find some way to perform the Informix reliability backups to disk or (better yet!) to pipe their output into Alexandria. Has anyone out there used Alexandria yet? _____________________________________________________________________________ John Powell HP Corvallis, IJBU CIM Dept. Telnet 750-8389 Phone (503) 750-8389 e-mail: jpowell@cv.hp.com (Internet) ____________________________________________________________________________