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.