DSMSERV RESTORE DB (Restore a database to a point-in-time)
Use this command to restore a database to a point in time. A volume history file and a device configuration file must be available.
- The database backup is stored on virtual volumes
- The connection to the IBM Spectrum Protect server is protected by SSL (Secure Sockets Layer)
You can use full and incremental database backups, or snapshot database backups can be used to restore a database to a point in time.
Syntax
>>-DSMSERV -+----------------------+----------------------------> | (1) | '------- -u--user_name-' (2).- -k--Server1--. >--+-------------------------+------+---------------+-----------> | (1) | '- -k--key_name-' '------- -i--instance_dir-' >--+-------------------+--+---------------+--RESTORE DB---------> '- -o--options_file-' | (1) | '------- -quiet-' .-TOTime--=--23:59:59-. >--TODate--=--date--+---------------------+---------------------> '-TOTime--=--time-----' .-Source--=--DBBackup-------. >--+---------------------------+--------------------------------> '-Source--=--+-DBBackup---+-' '-DBSnapshot-' >--+---------------------------+--------------------------------> '-RECOVerydir--=--directory-' >--+----------------------------+-------------------------------> '-ACTIVELOGDir--=--directory-' .-PReview--=--No------. >--+------------------------------+--+---------------------+----> '-ON--=--target_directory_file-' '-PReview--=--+-Yes-+-' '-No--' .-RESTOREKeys--=--No-------. >--+--------------------------+---------------------------------> '-RESTOREKeys--=--+-No---+-' +-YES--+ '-ONLY-' >--+----------------------------+------------------------------>< '-PASSword--=--password_name-'
- This parameter applies to only AIX® and Linux servers.
- This parameter applies only to Windows servers.
Parameters
- -u user_name
- Specifies a user name to switch to before you initialize the server.
- -i instance_dir
- Specifies an instance directory to use. This becomes the current working directory of the server.
- -k key_name
- Specifies the name of the Windows registry key from which to retrieve information about the server. The default is SERVER1.
- -o options_file
- Specifies an options file to use.
- -quiet
- Specifies that messages to the console are suppressed.
- TODate (Required)
- Specifies the date to which to restore the database. The following
values are possible:
- MM/DD/YYYY
- Specifies that you want to restore a database by using the last backup series that was created before this specified date.
- TODAY
- Specifies that you want to restore a database by using the most recent backup series that was created before today.
- TODAY-numdays or -numdays
- Specifies that you want to restore a database by using the most recent backup series that was created the specified number of days before the current date.
- TOTime
- Specifies the time of day to which to restore the database. This
parameter is optional. The default is the end of the day (23:59:59).
Possible values are:
- HH:MM:SS
- Specifies that you want to restore the database by using the last backup series that is created on or before the specified time on the date that is specified on the TODATE parameter.
- NOW
- Specifies that you want to restore the database by using a backup
series that is created on or before the current time on the date that
is specified on the TODATE parameter.
For example, if you issue the DSMSERV RESTORE DB utility at 9:00 with TOTIME=NOW, the database is restored by using the last backup series that is created on or before 9:00 on the date that is specified on the TODATE parameter.
- NOW-numhours:numminutes or -numhours:numminutes
- Specifies that you want to restore the database by using a backup
series that is created on or before the current time minus a specified
number of hours and, optionally, minutes on the date that is specified
on the TODATE parameter.
For example, if you issue the DSMSERV RESTORE DB utility at 9:00 with TOTIME=NOW-3:30 or TOTIME+-3:30, the database is restored by using the last backup series that is created on or before 5:30 on the date that is specified on the TODATE parameter.
- Source
- Specifies whether the database is restored by using either database
full and incremental backup volumes or snapshot database volumes.
This parameter is optional. The default value is DBBackup. The following
values are possible:
- DBBackup
- Specifies that the database is restored as follows:
- Reads the volume history file to locate the database full and incremental backup volumes that are needed.
- Requests mounts and loads the data from the database full and incremental backup volumes as required to restore the database volume to the specified time.
- DBSnapshot
- Specifies that the database is restored as follows:
- Reads the volume history file to locate the snapshot database volumes that are needed,
- Requests mounts and loads data from snapshot database volumes as required to restore the volume to the specified time.
- RECOVerydir
- Specifies a directory in which to store recovery log information from the database backup media.
This log information is used to establish transaction consistency of the server database as part of
the recovery processing. This directory must have enough space to hold this transaction recovery
information and must be an empty directory. If this parameter is not specified, the default is the
directory that is specified by one of the following parameters in the DSMSERV
FORMAT or DSMSERV LOADFORMAT utility:
- ARCHFAILOVERLOGDIRECTORY, if specified
- ARCHLOGDIRECTORY, if ARCHFAILOVERLOGDIRECTORY is not specified
- ACTIVELOGDir
- Specifies a directory in which to store the log files that are used to track the active database operations. Specify this directory only if the intent is to switch to an active log directory that is different from the one that was already configured.
- On
- Specifies a file that lists the directories to which the database is restored. Specify each
directory on a separate line in the file. For example, the ON parameter specifies the
restorelist.txt file, which contains the following
list:
/tsmdb001 /tsmdb002 /tsmdb003
If this parameter is not specified, the original directories that were recorded in the database backup are used.e:\tsm\db001 f:\tsm\db002 g:\tsm\db003
Tip: If you specify multiple directories, ensure that the underlying file systems are of equal size to ensure a consistent degree of parallelism for database operations. If one or more directories for the database are smaller than the others, they reduce the potential for optimized parallel prefetching and distribution of the database. - PReview
- Specifies that the volume history files be examined and that the database backup volumes from
the volume history file be evaluated.
- Which set of database backup volumes best meets the point-in-time criteria that are specified for restore processing? The volume history information provides details about the backup series ID, the operation ID (full, incremental 1, incremental 2, and so on), the date of the database backup, and the device class. This information and the parameters that are specified in the DSMSERV RESTORE DB command determine what to use to perform the restore. The volume history file is examined to find the best database backup that meets the specified point-in-time criteria and then perform the restore by using that backup.
- Is self-describing data available for the selected set of database backup volumes? Cross-check the volume history information for this backup series. The reconciliation reports what the self-describing data contains compared to what was learned from the volume history entries. The cross-check involves mounting one or more of the volumes that are indicated by the volume history. Then, using the self-describing data that was included in the database backup volumes, that information is reconciled against what is in the volume history for the database backup. If the information from the volume history file is inconsistent with the self-describing data, then messages are issued to identify the problem. For example, not all values are specified and available, and no self-describing data is found.
If the volume history information is consistent with self-describing data from the database backup, a message is issued indicating that the database backup can be used for restore processing.
If the volume history information is inconsistent with the self-describing data from the database backup or if the self-describing data for the backup cannot be found, error messages are issued indicating what was checked and what was missing.
If the PREVIEW parameter is not specified or if it is set to NO, and if the volume history and self-describing data from the database backup are consistent, then the restore proceeds.
If the PREVIEW parameter is not specified or if it is set to NO, and the reconciliation and validation fail, the database restore is not performed. Make extra volumes available and referred to from the volume history file, or remove the incomplete backup series or operation so that the IBM Spectrum Protect server selects a different preferred series or operation and continues processing.
If the PREVIEW parameter is set to YES, the process performs only the evaluation of the volume history file and the reconciliation and validation against the selected database backup.
- RESTOREKeys
- Specifies whether to restore the server master encryption key that is used to encrypt storage
pool data when the database is restored. This parameter is optional and only applies if you are
using encrypted container storage pools in a cloud environment. If the server master key is
protected when the database is restored, the default is YES. If the server
master key is not protected when the database is restored, the default is NO.
You can specify one of the following values:
- No
- Specifies that the server master key is not restored when the database is restored.
- Yes
- Specifies that the server master key is restored when the database is restored. You must specify a password with this parameter.
- Only
- Specifies that only the server master key is restored. The database is not restored.
- PASSword
- Specifies the password that is used to protect the database backup. This parameter only applies if you are using encrypted container storage pools in a cloud environment. If you specify a password for database backup, you must specify the same password on the RESTORE DB command to restore the database. You must use a password if you specify the RESTOREKEYS=YES or RESTOREKEYS=ONLY parameter.
Example: Restore the database to a specific point in time
Restore the database to its state on May 12, 2011 at 2:25 PM. dsmserv restore db todate=05/12/2011 totime=14:45
Example: Restore the server master key without restoring the database
Restore the server master key without restoring the database by issuing the following command:dsmserv restore db restorekeys=only