Restoring the database

Edit online

If you have the disaster recovery manager (DRM) function enabled and you followed the procedure to prepare for a disaster, you can restore the database after a disaster. If you do not have DRM configured, you can still restore the database, provided that you have the required backup files. If you do not have the required backup files, you can potentially restore the database by recreating the required backup files.

Before you begin

Restrictions:
  • To restore the database to its latest version, you must locate the archive log directory. If you cannot locate the directory, you can restore the database only to a point in time.
  • If the database and recovery log directories are lost, you can re-create the directories. However, you must first re-create the server instance. For detailed instructions about re-creating files and directories that are required to restore a server instance, see Restoring a server when files are missing.
  • If the release level of the database backup is different from the release level of the server that is being restored, you cannot restore the server database. For example, if you are using a version 8.1 server and you try to restore a version 7.1 database, an error occurs.

About this task

You can restore the database to its most current state or to a specified point in time. To recover the database to the time when the database was lost, recover the database to its latest version.
Restrictions:
  • To restore the database to its latest version, you must locate the archive log directory. If you cannot locate the directory, you can restore the database only to a point in time.
  • If the release level of the database backup is different from the release level of the server that is being restored, you cannot restore the server database. For example, if you are using a Version 8.1 server and you try to restore a V7.1 database, an error occurs.

Procedure

Use the DSMSERV RESTORE DB server utility to restore the database. Depending on the version of the database that you want to restore, choose one of the following methods:
  • Restore a database to its latest version. For example, use the following command: 
    dsmserv restore db
  • Restore a database to a point in time. For example, to restore the database to a backup series that was created on 19 April 2022, use the following command:
    dsmserv restore db todate=04/19/2022