> CommCell Console > Backup and Restore Agents > Databases > DB2 MultiNode > DB2 MultiNode Agent CommCell Console Restore Operations

Restoring a DB2 MultiNode Database to Disk (App Free Restore)

You can restore the backup images of data and logs or multiple backup jobs at a time directly to a location on a disk using CommCell console without the intervention of DB2 application. This is useful for restoring multiplexed data on the same media. The data from different backup jobs are passed back to the client so that all of the interleaved backup jobs can be restored in parallel. You can restore the data associated with a specific backup job such as full, in parallel streams. You can also submit multiple restore jobs from full and incremental backups. Later, you can restore the database from the command line using the backup image from disk without loading the Commvault library.

Use the following steps to perform an app free restore operation:

  1. From the CommCell Browser, expand Client Computers > client > DB2 MultiNode > instance.

  2. Right-click the backup_set, point to All Tasks, and then click Restore to Disk.

  3. On the Restore to Disk dialog box, click OK.

  4. Select the backup jobs to restore to a disk. Right-click the job, and then select Restore to Disk.

    You can select multiple backup jobs at a time and restore them to disk.

  5. In the Restore Options for All Selected Items dialog box, set up the client:

    1. From the Destination Client list, select the client.

    2. In the Destination path box specify where the backup pieces are restored to.

  6. Click OK.

The DB2 Agent creates a new folder with the current restore job ID on the destination directory that you specified during the restore operation. This folder contains the backup images and DB2 archive logs.

Log Files

restore_destination_path/restore_job_id/LOGS/DB2/Node Number/Chain number/Log_files

Example:

cd Restore_Destination_path/Restore_Jobid
Ls –ltr
d rwxrwxr-x 3 db2part5 db2grp1 256 Mar 12 12:11 LOGS
-rwxrwxr-x 1 db2part5 db2grp1 561664000 Mar 12 12:26 HPSNAP1.0.DB2PART5.NODE0001.CATN0000.20130311113930.001
--rwxrwxr-x 1 db2part5 db2grp1 578866640 Mar 12 12:26 HPSNAP1.0.DB2PART5.NODE0000.CATN0000.20130311113921.001

Data 

destination directory Backup_images

You can run a disk restore that uses this backup image at the following location. Make sure that the Commvault services are running on this client.

>cd restore_destination_path/restore_job_id
>db2 restore database db_name taken at backup_image

You can recover the database by reapplying the log files (roll forward).

>db2 rollforward database db_name to end of logs and stop overflow log path (Restore_Destination_path/Restore_Jobid)

The following examples are for restore and roll forward using backup images from the disk of a two-node DB2 MultiNode setup which has only full backup:

Export DB2NODE=0
db2 terminate
db2 restore database Database_Name incremental automatic from Restore_Destination_path/Restore_Jobid taken at Node 0 Backup Image without prompting
Export DB2NODE=1
db2 terminate
db2 restore database Database_Name incremental automatic from Restore_Destination_path/Restore_Jobid taken at Node 1 Backup Image without prompting

For roll forward:

Export DB2NODE=0
db2 terminate
db2 rollforward db Database_Name to end of logs on all nodes overflow log path \ ( \
Restore_Destination_path/Restore_Jobid /LOGS/DB2 Instance/Database Name/NODE0000/Latest Chain Directory,\
Restore_Destination_path/Restore_Jobid /LOGS/DB2 Instance/Database Name/NODE0001/Latest Chain Directory on node 1 \)

Cross Machine Restore:

Consider the following before performing a cross machine restore to the destination disk:

  • You need to restore backup images to a destination computer.

  • The destination computer's DB2 agent must be configured in the CommCell Console.

  • The Commvault path in the destination computer must be the same as the source computer.

  • You must be a DB2 user to run the db2 commands for restoring to disk.

×

Loading...