Re: Unattended online archival

jlumbley@netcom.com (Joe Lumbley) writes: > Daniel Wood (daniel@starsight.com) wrote: > : psampat@cronkite.ocis.temple.edu (Pragnesh Sampat) writes: > : > Hi, I would like some information on the best way to set up unattended > : > (through cron) Informix database achival. > : > > : [...] > : Here are the last few lines of our fullback script that is run by cron > : each night. The system is a SS/10 running Solaris 2.3 . Several notes: > > : 1. We are backing up all our filesystems and the informix > : database to one tape by using a norewind tape. > > Have you tried to recover using these tapes? OnLine emphatically > DOES NOT SUPPORT no-rewind devices. I think it looks for some > physical headers. We were able to take the stuff of to no-rewind > tapes with no problems, but they would not reload. > Yes, I have tried it; with Sun OS, Solaris 2.3, AIX, Ultrix, Altos, SCO. I've even been able to put the logs and DB on the same tape which frees the logs for the next days activity. I was just trying to answer the question of how to do a unattended backup, and in doing so I mentioned the fact that our solution happens to use a no-rewind tape device. I was not suggesting that Pragnesh do this, because if I were suggesting this, I would also be giving the details of how to do the restore. > : [...] > : 4. The pipe'ing of the output through mail allows the sysadmin > : to check the results each day. > > You can also redirect the output of the tbtape to a file. Since the > tbtape output is curses-based, it will include various screen control > characters, but you can tail -c 50 (or so) to get just the ongoing > status of the archive (50% full , etc). > WOW! Can you really redirect the output of a command to a file!?!? :-) We use mail because our contract sysadmin is off-site most of the time and he monitors the backups through mail to his netcom account.(Not my idea) > : [...] > : su - informix -c "/usr/5bin/echo '\\n0' | tbtape -s | mailx -s 'Informix Backup' > : root" > : mt -f $DEVICE offline -- Daniel Wood daniel@starsight.com The opinions expressed herein are those of myself, my employers, the carriers of this news message or any other messages for that matter, you the reader and any of your relations(whether by birth or chromosome count), all life forms and all inanimate objects.