Restore Db2 databases
When you need to restore data, define a job that restores lost data either to the latest database backup or select an earlier backup copy. Choose to restore data to the original location or to an alternative location, and select more recovery options. If required, you can choose not to define any options and to restore the data immediately.
Before you begin
In the Restore panel, use the Show restore points from all sites menu to filter between Primary or Secondary sites. The default view, shows all restore points from both sites. If you cannot find the database that you need, use the search field to search for a specific database name.
Before you create a restore job for DB2®, ensure that the following items are in place.
- At least one Db2 backup job is set up and running successfully. For instructions on how to set up a backup job, see Backing up Db2 databases.
- IBM Spectrum Protect™ Plus roles and resource groups are assigned to the user who is setting up the restore job. For more information about assigning roles, see Access.
Before you start, ensure that you allowed enough disk space and allocated dedicated volumes for the copying of files. See Db2 Requirements.
Tip: If the local database directory you are restoring to is not empty, the process fails. No other data can share the local database directory as the database to be restored.
To restore Db2 databases:
- From the navigation menu, expand Manage Protection, then expand Applications. Expand Db2, then click Restore.
- In the Restore window, click a Db2 instance from the list in the Instances pane to expand that instance to show the databases.
- Click the database that you want to restore to show the Restore Points available for that database.
- Restore points are listed with the backup timestamp, SLA policy type, and site information.
- Choose a Restore Point to use the latest backup or choose an earlier database backup from the list to restore a specific backup from a date and time listed.
- To restore to the latest backup, click the Add to Restore List
icon beside the database name on the right-hand side of the Restore Points table.
- To choose a Restore Point from a different time, find the backup that you require and add it to the Restore List by clicking the Add to Restore List
icon.
- Tip: To remove the restore point from the list, click the Remove
icon.
- To restore immediately to the original location, click Restore.
- Attention: Selecting Restore always overwrites existing data. The only exception is if you cleared the target instance before you started the restore operation, then there is no data to overwrite.
- Alternatively, click Options to choose a restore Destination, and to specify a Restore Type. For more information about restoring data to the original location, see Restoring to the original location. For more information about restoring your data to an alternate location, see Restoring to an alternate location. Choose one of the following restore types: Test, Production, or Instant Access. Any restore type that you choose overwrites data at the target site.
- - Choose Test to create a new database by using the data files directly from the vSnap volume.
- - Choose Production to restore the Db2 files from the vSnap volume back to primary storage. This data is then spun up to the new database by using the restored files.
- - Choose Instant Access to access the raw data. No further action is taken after IBM Spectrum Protect Plus mounts the share. Use the data for custom recovery from the files in the vSnap volume.
- Or, click Manage Jobs to specify a schedule for a repeated restore operation.
Results
A few moments after you select Restore, the onDemandRestore is added to the Job Sessions panel. When you expand the record that shows the name, status, start time, and duration of progress, the details of the job log is shown for the operation. Expanding the job log shows you the step-by-step details of the operation. You can also download the log file by selecting the download icon icon.
NEXT STEPS:
- Restore a database backup to its original instance on the original host. Choose between restoring to the latest backup or an earlier Db2 database backup version. When you restore an instance or a database to its original location, you cannot rename it. This restore option runs a full production restoration of data, and existing data is overwritten at the target site. See Restoring Db2 Databases to the Original Location.
- Select a Db2 database backup and restore that database to a Db2 instance on an alternate host. You can also choose to restore a database to an instance with a different name, or you can rename the database. This process creates an exact copy of the database on a different host in a different instance. See Restoring Db2 Databases to an Alternate Instance.
IBM Spectrum Protect Plus 10.1.2
Licensed Material - Property of IBM Corp. © IBM Corporation and other(s) 2018. IBM is a registered trademark of the IBM Corporation in the United States, other countries, or both. | 8/23/2018