Informix

 View Only
  • 1.  Logicallog Backup Retention

    Posted Thu December 09, 2021 01:54 AM
    Edited by Josef Albert Thu December 09, 2021 01:54 AM

    Hi,

    i've set up a logical log backup with ids 14.10 fc7 (windows) like i did it with all versions before:

    onconfig:

    LTAPEDEV=PATH_TO_A_FOLDER


    alarmprogram:

    SET BACKUPLOGS=Y
    set BACKUP_CMD=ontape -a -d


    The llog backup is workin as expected, but old llog backups are not removed from the disk.

    I do a full backup with ontape -s -L 0 every night but i still have 10 days old logical log backups on the disk.

    Am i missing something or is there a new way to setup the retention of the llog backup?

    Thank you guys.

    Joe



    ------------------------------
    Josef Albert
    ------------------------------


  • 2.  RE: Logicallog Backup Retention

    Posted Thu December 09, 2021 02:25 AM

    Sry, my fault. ;)

    I was missing something in my script.

    LLog backups were delete from my script all the time....

    Shame on me, but i can't find the delete button for my post.

    Pls close / delete it.



    ------------------------------
    Josef Albert
    ------------------------------



  • 3.  RE: Logicallog Backup Retention

    Posted Tue December 21, 2021 04:26 AM
    Ontape programs are not smart enough

    You cannot automatically delete previous logical log backups after ontape backups are completed

    ------------------------------
    ZhiWei Cui
    GBASE
    ShiJiaZhuang
    ------------------------------



  • 4.  RE: Logicallog Backup Retention

    Posted Tue December 21, 2021 06:41 AM
    You are correct, ontape cannot delete old log backups, but your archive script that launches ontape, either for the server archive or log backup, can, once the archive completes, delete any older log backups as well as older archives. I think that is what Josef is referring to.

    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 5.  RE: Logicallog Backup Retention

    Posted Thu December 09, 2021 06:17 AM
    Joe:

    The best way to manage cleaning up older logical log backup files is to do that as part of the archive processing when you are using ontape since ontape never did that for you (your storage manager will take care of that if you are using onbar). You need to keep all of the logical log backups made after the oldest full archive that you are keeping around in case a later archive becomes corrupted and you have to restore and roll forward from an older one. Therefore, it makes sense that the archive cron script (or whatever) takes care of aging out log backups older than that oldest retained archive.

    Art

    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------