Restoring selected table spaces

Use the Table spaces page of the restore notebook to specify that you want to restore a subset of the table spaces in the database or database partition.

Notes:

1. If time considerations dictate that you must restore a subset of the table spaces when you would prefer to restore all of them, you can restore only those table spaces required to make the database or database partition functional, then, when you have the time, you can restore the remaining table spaces.

2. In a partitioned database environment, you restore at the database partition level.

Fields and controls

Authorities and privileges

To restore selected table spaces:

1. Open the restore notebook:
   • Open the Restore Database notebook.
   • Open the Restore Database Partition notebook.
   • Open the Restore notebook from the Journal.

2. On the Backup Image page, specify the backup image that you want to use for the restore operation:

   • To use one of the backup images that are displayed, click on Select an entry from the list, then select the backup image that you want to use.

     If you have already created a backup image of the database or database partition from this administrative client, Select an entry from the list is preselected because the recovery history file indicates that a backup image is available.

     If you know that the media type that is displayed for the backup image is not correct, then use the fields that are displayed under Change the media information if necessary to specify the correct media type for the backup image.

   • To use a backup image that is not displayed, click on Manually enter the backup image information. Use the fields that are displayed with Manually enter the backup image information to specify the backup image that you want to use.

     If you have not already created a backup image of the database or database partition from this administrative client, Manually enter the backup image information is preselected because the recovery history file for the database or database partition does not contain any backup history.

3. On the Table spaces page, specify the table spaces that you want to restore by ensuring that they are listed in the Use table spaces box. Use the >>, >, <, << controls to build the list of table spaces that you want to restore.

4. On the Options page, select one of the Process while radio buttons, either Online or Offline. Offline is the default.

5. Click on OK to begin the restore operation.

After table spaces are restored, they will be in the roll-forward pending state. If you restore more than one table space, use the Roll--Forward Database notebook to roll forward the set of table spaces. If you restore only one table space, use the Roll-Forward Table Space notebook to roll it forward. The following considerations apply to the partitioned database environment:

Notes:

1. In a partitioned database system, if you intend to roll forward a table space (or table spaces) to the end of the logs, you do not have to restore it at each database partition. You only need to restore it at the database partitions that require recovery.

2. In a partitioned database environment, if you want to roll forward a table space to a point in time, you must restore the table space partition at each database partition that contains a portion of the table space, and roll forward each table space partition individually to the same point in time. This ensures that the table space is consistent at each node.

Related information

• Restore Database -- Overview