Chat now with support
Chat with Support

NetVault Plug-in for DB2 12.0 - User Guide

Restoring from Incremental Backups

Figure 1. Example of steps necessary to perform recovery using Incremental Backups

1
Restore the most recent Incremental Backup.
Use the following table to select the correct items on the Create Selection Set page and the Options tab.
 
Create Selection Set page
Options tab

Selected

Cleared

Selected

Cleared

Tablespaces only

None necessary

Incremental Restore
•
Rollforward Archived Logs
•
Delete Existing Logs
2
Restore the last Full Backup.
Use the following table to select the correct items on the Create Selection Set page and the Options tab.
 
Create Selection Set page
Options tab

Selected

Cleared

Selected

Cleared

Tablespaces only

Archived Logs

Incremental Restore
•
Rollforward Archived Logs
•
Delete Existing Logs
3
Restore the most recent Incremental Backup a second time.
Use the following table to select the correct items on the Create Selection Set page and the Options tab. In this step, the plug-in applies the Archived Logs to perform a Soft or Hard Recovery.
 
Create Selection Set page
Options tab

Selected

Cleared

Selected

Cleared

•
Tablespaces only
•
Archived Logs

None necessary
•
Incremental Restore
•
Rollforward Archived Logs
•
Soft Recovery or Hard Recovery, as applicable
•
Delete Existing Logs

None necessary

Restoring from Delta Backups

Figure 2. Example of steps necessary to perform recovery using Delta Backups

1
Restore the last Delta Backup.
2
Restore the last Full Backup.
3
Restore the first Delta Backup.
4
Restore the subsequent Delta Backups.
For the preceding steps, use the following table to select the correct items on the Create Selection Set page and the Options tab.
 
Create Selection Set page
Options tab

Selected

Cleared

Selected

Cleared

Tablespaces only
•
Full Database
•
Archived Logs

Incremental Restore
•
Rollforward Archived Logs
•
Delete Existing Logs
5
Restore the last Delta Backup a second time.
Use the following table to select the correct items on the Create Selection Set page and the Options tab. In this step, the plug-in applies the Archived Logs to perform a Soft or Hard Recovery.
 
Create Selection Set page
Options tab

Selected

Cleared

Selected

Cleared

•
Tablespaces only
•
Archived Logs

None necessary
•
Incremental Restore
•
Rollforward Archived Logs
•
Soft Recovery or Hard Recovery, as applicable
•
Delete Existing Logs

None necessary

 
* 
NOTE: You can mix the different types of Incremental Backups, for example, restoring both Delta and Incremental Backups, in a recovery scheme to achieve the required result. However, if you use a combination, the restore order and the data items included in each phase are crucial to achieving the wanted result.

Advanced restore procedures

This topic describes the steps outlined in the following topics:

•
Renaming or relocating a database during a restore
•
Restoring a database to an alternate server
•
Working with dropped DB2 tables

Renaming or relocating a database during a restore

During a restore, you can rename a database or relocate all or individual tablespaces to a specified directory. This option lets you create a copy of the database instead of overwriting the existing version.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating