Restoring a server database from cloud storage

Edit online

A server database can be restored from a database copy on cloud object storage. For example, if a disaster occurs at an onsite data center, you can restore the database from the cloud copy. The server database can be restored either to its most recent state or to a point in time.

About this task

During database backup operations, critical files such as device configuration and volume history files are saved for restore operations. If the device configuration or volume history files are not available locally because of an onsite disaster, you can obtain the files from cloud object storage by providing cloud credentials on the DSMSERV RESTORE DB command. These cloud credentials are typically the same as those used for the database backup operation. Connection information such as the cloud URL is stored in the device configuration file.

The master key files (dsmkeydb.kdb and dsmkeydb.st) are located in the instance home directory.

Procedure

To restore the server database from cloud object storage, complete the following steps:

  1. Halt the server.
  2. Issue the DSMSERV RESTORE DB command.
    If the key location changed and no longer matches the location that was specified in the original device configuration file, change the Google Cloud Storage key file to the location that is specified in the device configuration file. Then, retry the restore operation.

Example

Restore the database from cloud object storage to a specified point in time. Use the DSMSERV RESTORE DB utility to issue a point-in-time restore command and verify that the database is restored to that point in time. 
dsmserv restore db prompt=no 
password=proTect&8991 todate=12/12/2019 totime=14:45