Types of server database restores

Point-in-time restores are typically used for situations such as disaster recovery or to remove the effects of errors that can cause inconsistencies in the database. If you want to recover the database to the time when the database was lost, recover the database to its current state.

Point-in-time restore
  • Removes and re-creates the active log directory and archive log directory that is specified in dsmserv.opt file
  • Restores the database image from backup volumes to the database directories recorded in a database backup or to new directories
  • Restores archive logs from backup volumes to the overflow directory
  • Applies logs from the overflow directory up to specified point in time
Database restores that use snapshot backups are a form of point-in-time restore.
Most current restore
  • Does not remove and re-create the active log directory or archive log directory.
  • Restores a database image from the backup volumes to the database directories recorded in a database backup or to new directories.
  • Restores archive logs from backup volumes to the overflow directory.
  • Applies logs from overflow directory and archive logs from archive log directory.