Full backup restore example

The Database Administrator of Company X's Development department wants to restore the devel.db database that was previously backed up.

To restore devel.db to a new database from a full backup:

  1. Use PROREST.

    Enter the following command:

    prorest newdev /dev/rrm/0m

    The newdev.db database is an empty database. The 9-track tape drive (/dev/rrm/0m) specifies the device from which the full backup is being restored.

    As the restore begins, the following report appears:

    This is a full backup of /usr1/develop/devel.db. (6759)
This backup was taken Tue Oct 14 11:28:04 2022. (6760)
This backup was compressed using ZSTD compression. (20281)
The compression level used in the backup is 3. (20282)
The blocksize is 4096. (6994)
Start of extending target DB to needed size... (9432)
It will require a minimum of 1082 blocks to restore. (6763)
Start of restoring the target DB... (9433)
Restore the backup file with 4 worker threads. (20649)
Read buffer factor (-rbf): 8192 (20707)
Write buffer factor (-wbf): 4096 (20786)
Restore has spawned 4 worker threads (20648)
Read 1076 db blocks in 00:00:02

    This command restores the database devel.db from a tape to newdev.db. The report indicates that volume 1 is being processed.

  2. Connect to newdev.db once the restore is complete.