Restore to Original Server

You can restore IBM Db2 databases from backups stored on Veeam backup repositories in the following ways:

• Restore from a full backup.
• Restore from an incremental backup.
• Restoring to the previous state.
• Restore to a specific point in time.

Restore from Full Backup

To restore a IBM Db2 database from a full backup, use the following command:

where:

• <database_name> is the name of the database you want to restore.
• <timestamp> is the time stamp that IBM Db2 generates for each backup in the yyyymmddhhmmss format. Veeam Plug-In restores database from the backup file created at the time that you specify in the command.

To learn how to get time stamp, see Get Backup Time Stamp.

Restore from Incremental Backup

To restore a IBM Db2 database from an incremental backup, use the following command:

where:

• <database_name> is the name of the database you want to restore.
• <timestamp> is the time stamp that IBM Db2 generates for each backup in the yyyymmddhhmmss format. Veeam Plug-In restores database from the backup file created at the time that you specify in the command.

To learn how to get time stamp, see Get Backup Time Stamp.

Restore to Previous State

You can restore the database to the previous state. To do that, you restore the database from a backup, then apply archive logs that are available in the backup file. With these archive logs, you can restore the database to the exact state when the backup was created.

To restore the database to the previous state, do the following steps:

1. Restore to the previous state requires downtime. Terminate all existing connections and deactivate the database with the following commands:

where <database_name> is the name of the database you want to deactivate.

2. Extract archive logs from the backup file with the following command:

where:

• <database_name> is the name of the database you want to restore.
• <path_to_logs> is the path to the directory to which Veeam Plug-In extracts archive logs.

3. Restore the database to the state recorded in a full online backup with the following command:

where:

• <database_name> is the name of the database you want to restore.
• <timestamp> is the time stamp that IBM Db2 generates for each backup in the yyyymmddhhmmss format. Veeam Plug-In restores the database from the backup file created at the time that you specify in the command.

To learn how to get time stamp, see Get Backup Time Stamp.

4. Apply archive logs to return the database to the exact state when the backup was created with the following command:

where:

• <database_name> is the name of the database you want to restore.
• <path_to_logs> is the path to the directory containing the extracted archive logs.

5. Recover the database with the following command:

where <database_name> is the name of the database you want to restore.

6. Re-activate the database with the following command:

where <database_name> is the name of the database you want to activate.

Restore to Specific Point in Time

You can restore an IBM Db2 database to a specific point in time between two backups. Veeam Plug-In applies archive logs up to the target time, returning the database to the exact time that you specify.

To restore a database to a specific point in time, do the following steps:

1. Restore to a specific point in time requires downtime. Terminate all existing connections and deactivate the database with the following commands:

where <database_name> is the name of the database you want to deactivate.

2. Extract archive logs from the backup file with the following command:

where:

• <database_name> is the name of the database you want to restore.
• <path_to_logs> is the path to the directory to which Veeam Plug-In extracts archive logs.

3. Restore the database to the state recorded in a full online backup with the following command:

where:

• <database_name> is the name of the database you want to restore.
• <timestamp> is the time stamp that IBM Db2 generates for each backup in the yyyymmddhhmmss format. Veeam Plug-In restores the database from the backup file created at the time that you specify in the command.

To learn how to get time stamp, see Get Backup Time Stamp.

4. Apply archive logs up to the target time stamp with the following command:

where:

• <database_name> is the name of the database you want to restore.
• <utc_time> is the UTC time in the YYYY-MM-DD-HH.MM.SS format to which you want to restore the database. The value must be between the time at which the online backup operation completed and the latest extracted archive log.

For details on how to use local time instead of the UTC time, see IBM documentation.

• <path_to_logs> is the path to the directory containing the extracted archive logs.

For details on the rollforward command syntax, see IBM documentation.

5. Re-activate the database with the following command:

where <database_name> is the name of the database you want to activate.