Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Back to discussions
Expand all | Collapse all

External backups/restores and logical restoring of logs passed last Level-0 backup

  • 1.  External backups/restores and logical restoring of logs passed last Level-0 backup

    Posted Tue September 23, 2025 04:36 AM
    Edited by Jose Manuel Ruiz Gallud Tue September 23, 2025 05:49 AM

    Hi,

    We are considering doing disk snap-shots with external backups which are very fast, and still continue doing daily onbar level-0 and, of course, keep doing onbar logical log backups.

    One doubt we had, and could not find clear doc about this, is if it is possible to restore an older Level-0 or external backup, and still roll-forward logs to the latest point-in-time. For example:

    1. At 7:00AM: perform an external backup
    2. At 20:00PM, do an onbar L-0 (standard no Whole) backup 
    3. At 22:00PM could i perform an external restore (of the backup made at 7:00AM) and still restore all logs to the latest point in time (22:00PM) taking into account an onbar L0 backup happened at 20:00PM ?

    -- Of course, we backup logical logs all the time and everytime we fill a log we back it up.

    Thanks!

    Jose



    ------------------------------
    Jose
    ------------------------------



  • 2.  RE: External backups/restores and logical restoring of logs passed last Level-0 backup

    Posted Wed September 24, 2025 08:59 PM

    Jose:

    Yes you can perform logical log rollforward using older external or onbar archives to a point in time following a later archive.

    Art



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

    Original Message


  • 3.  RE: External backups/restores and logical restoring of logs passed last Level-0 backup

    Posted 28 days ago

    Thanks Art.

    Yes, indeed it works.

    We have tested it with ontape, onbar and external backups. Logical logs are independant and you can restore older backups, or external backups, and restore logs passing other backups.

    Best regards,



    ------------------------------
    Jose
    ------------------------------

    Original Message


Related Content