Forum Discussion

prasannad's avatar
prasannad
Level 3
6 years ago

Unable to do Point in Time Recovery in DB2

We need to restore and recover the DB2 environment to a specific time. We used VENDOR Archive method to backup transaction logs.

As we tried to do point in time recovery(using GUI & Command line); log file restoration did not stopped at the specified time on both occasions. Therefore we are unable to recover the database for a point in time.

We are using NetBacku 8.1

Need your help on this..

  • Thank you 

2 Replies

  • I am not a DB2 expert, but I know this about NetBackup:
    It will restore whatever is requested. Nothing more, nothing less. 

    The NBU utilities certainly have limitations. 
    We see this in NBU for DB2 manual:

    The NetBackup for DB2 database wizards can create backup and
    recovery templates. You can launch the backup wizard and the
    recovery wizard from the Backup, Archive, and Restore interface.
    The wizards generate platform-independent templates containing
    configuration information the software uses during backups and
    restores. Before you can create, modify, delete, or rename
    templates on the master server, the client must exist in a policy or
    in the NetBackup image catalog. Because the wizard-generated
    templates do not support all the features native to DB2, you may
    want to write a customized backup or restore script. You should
    use an operating-system defined scripting language to create the
    scripts and use a template as the base for a script. 

    And:

    Because recovery can be a complex process, it might be necessary to perform
    manual steps as part of the operation. For more information, see your DB2
    documentation.

    So, for point in time recovery, best to use DB2 documentation for RECOVER commands/options.

    This looks like a good starting point:

    https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/ugref/src/tpc/db2z_pointintimerecovery.html

    • prasannad's avatar
      prasannad
      Level 3

      Thank you