Thanks to all of those who responded to my question. The answer was that
I need to use the DELETE VOLHISTORY command to get rid of old db backups.
Not the most intuitive approach (and not discussed much in the db backup
section of the Admin Guide), but effective!
I decided to schedule only a monthly db backup to 3590 tape for disaster
recovery (it'll join our monthly offsite storage backup tapes). For more
frequent db backups (as protection against goof-ups, server hardware failure,
and other Bad Things), I've setup a daily db backup to AFS filespace. We
now have scheduled daily incremental and weekly full db backups, and a weekly
DELETE VOLHISTORY for any backups older than 35 days. Hopefully this will
cover most/all contingencies...
Thanks again for the helpful responses!!
--Judy Warren
Cornell Theory Center
> Subject: BACKUP DB question
> To: adsm-l AT vm.marist DOT edu
> Date: Wed, 20 Dec 1995 16:17:19 -0500 (EST)
>
> Folks,
>
> I'd like to setup a daily scheduled full backup of our ADSM server
> database; I'd planned to use 3590 tapes in a 3494 tape robot for the
> backups. Given the capacity and speed of the 3590 tapes and drives,
> I didn't see any reason to do incremental backups.
>
> But I also don't want to allocate an indefinite number of tapes to
> the DB backups; I figured that a tape rotation of 4-5 tapes would
> be adequate.
>
> The problem that I'm running into is that once a tape has been used
> for a DB backup, I don't seem to be able to find a way to make it
> re-usable for another DB backup some number of days later. The tape
> volume is marked "Private, DBbackup" according to a "query libvol".
> I've tried changing it to just "Private" or even to "Scratch" (with
> an "update libvol" command), but when I try to backup my database
> to that tape again, I'm told that:
>
> ANR4583E Database backup terminated - output media full
> and scratch media could not be mounted.
>
> How do folks out there manage regular automatic or scheduled DB backups?
> Do you just use some other kind of device (eg DEVCLASS=FILE) and manually
> erase some of the files when too many backups have accumulated, or is there
> some trick to getting a DB (tape?) backup rotation in place?
>
> Thanks,
> Judy
>
> --
> Judy Warren jsw AT tc.cornell DOT edu
> Cornell Theory Center (607) 254-8792
>
|
