Setting restore type and other restore options
On the Create Selection Set page, click Edit Plugin Options, and configure the following parameters on the Options tab:
|
• |
Restore Type: Select one of the following: |
|
• |
Restore all table spaces in the database: To restore all tablespaces in a selected database, select this option. |
|
• |
Restore only table space-level backup images: When performing a restore of one or more selected tablespaces, select this option. |
|
• |
Restore Mode: Select one of the following: |
|
• |
Offline: To prevent other applications and users from connecting to the database during a restore, select this option. |
|
• |
Online: This option is applicable only when performing a tablespace-level restore. It allows other users and applications to connect to the database, and read or modify the data in other tablespaces while the specified tablespaces are being restored. |
|
• |
Incremental Restore: To alert NetVault Backup that a Full Backup being recovered is a portion of an incremental sequence, rather than a standalone Full Backup recovery, select this option. For more information, see Restoring from Incremental Backups and Advanced restore procedures. |
|
• |
Archived Logs Options: Select the applicable options: |
|
• |
Rollforward Archived Logs: To apply the Archived Logs, select this check box. |
|
• |
Soft Recovery: To restore the existing logs to their most up-to-date state, select this option. |
|
• |
Hard Recovery: To restore the logs to the point at which the backup was performed, thus overwriting the existing archived logs files, select this option. |
|
• |
Delete existing logs: To delete all existing log files, select this check box. |
|
• |
Rollforward Only (will not Restore any Files): To perform only a roll-forward recovery without restoring any files, select this check box. |
|
• |
DB2 Buffers Setting: Configure the following parameters: |
|
• |
Number of Buffers: If you are using multiple buffers and I/O channels, specify at least twice as many buffers as channels to ensure that the channels do not have to wait for data. Increasing the number of buffers results in the backup operation completing faster. |
|
• |
Buffer Size: To change the buffer size, enter the value here. The value must be a multiple of the tablespace extent size. The default value for this parameter is 1024 KB. |
|
• |
Number of Sessions: This parameter determines the number of tablespaces that are restored in parallel. Each session is assigned one tablespace at a time until all tablespaces are restored. This parameter is read-only. It is set to the number of sessions used to create the selected backup. |
|
• |
Heap Size: By default, the plug-in uses 4096 pages for Heap Size. If you want to use a different value for the database heap configuration parameter, dbheap, enter it in this field. |
|
IMPORTANT: If you do not want the plug-in to update dbheap, and you want it to use the current dbheap value configured for the database, use the Plug‑in for DB2 configuration parameter to indicate whether the dbheap setting can be updated during the roll-forward phase of a restore job.
To use this configuration parameter, add the following stanza to the “nvdb2.cfg” file. This file is located in <NetVault Backup installation directory>\config on the NetVault Backup Client: If you set the parameter to FALSE, the database heap is not updated by the plug-in during the roll-forward phase, and the value entered in the Heap Size field is ignored. If you omit the parameter or set it to TRUE, the database heap is updated by the plug-in during the roll-forward phase by using the value entered in the Heap Size field. |
Configuring Destination Details
To restore the data to a different DB2 instance, click the Destination Details tab, and configure the following parameters:
|
• |
DB2 Instance Name: Enter the name of the instance to which you want to restore the data. |
|
• |
DB2 Instance Admin Account Name: Enter the account name for the DB2 Instance Administrator. |
|
• |
DB2 Instance Admin Password: Enter the password for the configured user account. |
Viewing backup information
To view the contents of various backup pieces in the selected backup set, click the Backup Information tab. This tab provides the following details:
|
• |
Backup done with: The plug-in version number |
|
• |
Backup Type: Full, Incremental, or Delta |
|
• |
Backup Mode: Online or Offline |
|
• |
Backup Includes Tables from the following Databases: This table includes the following columns: |
|
• |
Backup Includes Archived Logs from the following Databases: This table includes the following columns: |
Finalizing and submitting the job
The final steps include setting additional options on the Schedule, Source Options, and Advanced Options pages, submitting the job, and monitoring the progress through the Job Status and View Logs pages. These pages and options are common to all NetVault Backup Plug-ins. For more information, see the Quest NetVault Backup Administrator’s Guide.
|
1 |
|
2 |
In Job Name, specify a name for the job if you do not want to use the default setting. |
|
3 |
In the Target Client list, select the machine on which you want to restore the data. |
|
TIP: You can also click Choose, and then locate and select the applicable client in the Choose the Target Client dialog box. |
|
4 |
Use the Schedule, Source Options, and Advanced Options lists to configure any additional required options. |
|
5 |