Re: Logical Log Backups.

If you are using continuous backup(ontape -c) and it fills up, and you catch it in time(before the logical logs fill up), you can simply swap the tapes and you'll be fine after restarting the continuous backup. You would probably want to add some logical logs though. If you are using automatic backup(ontape -a) and it fills up without freeing enough logical logs, then you should add more logical logs(onparams -a -d dbspace [-s <size>]) and try again. Don't forget to do a level 0 archive after add logical logs, otherwise they won't be used. -- Regards, Robert p.s. Many small logical logs a better than a few large ones. Timothy Batchelor <tim@blackbird.net> wrote in article <73cq9t$qoa$1@news.xmission.com>... > > I'm having trouble finding a solution to a rather simple question. > If you are backing up logical logs to tape, what happens when the tape > fills up? Obviously you would not want to write over transactions. Do > you need to guess how fast the tape will fill up and swap them out once > in a while? If a archive is made I understand that the logical logs > before the archive are not necessary to restore, but what happens if the > tape fills up before an archive occurs? > > Thanks for any advice, > > Tim > >