Salesforce

How to restore a progress database backup using the prorest utility?

« Go Back

Information

 
TitleHow to restore a progress database backup using the prorest utility?
URL NameP18487
Article Number000133932
EnvironmentProduct: Progress
Version: 8.x, 9.x
Product: OpenEdge
Version: All Supported Versions
OS: All Supported Platforms
Question/Problem Description
How to restore a progress database backup using the prorest utility?
How to use PROREST ?
How to verify a Progress backup?
How to prorest a database?
How to run a partial verify of a database backup?

 
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution

The PROREST Utility can be used to restore a full or incremental backup of a database, or to verify the integrity of a database backup.

Command Syntax:
              prorest <db-name> <device-or-file-name> {-vp | -vf | -list}

For Example:

Step 1. Database "test" is in C:\OpenEdge\WRK directory which was backed up as "test.bck" in the same directory using the following command 
            probkup test test.bck

Step 2. Now  "test.bck" is restored  in a different, empty directory.
            Go to that directory and restore the backup using the following command.
            prorest test  C:\OpenEdge\WRK\test.bck


Before restoring a database, verify that the backup does not contain any corrupted blocks. Use the PROREST utility to verify the integrity of a full or incremental backup of a database by using the Partial Verify or Full Verify parameters. The Partial Verify or Full Verify parameters do not restore or alter the database. The PROREST utility must be run separately to restore the database. 

Note: The best way to restore a database in an empty directory, is by placing the .st file (with correct extent paths) in the same directory. It will set the database block size and create the structure automatically prior to the restore.

Note: If the date listed in the restore is not the date expected, make sure the backup file is the correct backup file?
Example of message at the beginning of the prorest output:
This is a full backup of sports2000.db. (6759)
This backup was taken Wed Jun  1 10:18:22 2022. (6760)

If the expected data of the backup was Jun 2 then the backup file might not be the correct backup file.
 

Workaround
Notes
References to Other Documentation:

Progress Article(s):
 Considerations when upgrading from OpenEdge 11 to a later OpenEdge 11 version.

Progress Information Hub > Back Up and Restore a Database > Restoring a database > Using PROREST to restore a database:
https://docs.progress.com/bundle/dba-backup-and-restore/page/Using-PROREST-to-restore-a-database.html

Progress OpenEdge --> Database Administration --> Protecting Your Data --> Backing Up a Database --> Restoring a database --> Using the PROREST utility to restore a database:
https://documentation.progress.com/output/ua/OpenEdge_latest/index.html#page/dmadm/using-the-prorest-utility-to-restore-a-database.html

For detailed information on the command and optional parameters, consult the OpenEdge Database Guide and Reference documentation for the version being used.

Prorest will perform a block by block copy of the data in the backup file and restore the blocks to the areas defined in the backup file.
In version 9 or higher, if there is an ST file (dbname.st) in the directory the prorest command is given then the structure definition in the ST file will be used to create the database and the blocks of the backup file will be written into the new structure.

If a database exists with the same name as the name given in the prorest command the user will be prompted to overwrite the existing database y/n?

If the backup is a full backup then the prorest will restore a full copy of the database.
If the backup is part of a set of backup files (e.g. 1 of 10 or 1 of 100) then each backup file in the set must be restored for the database to be whole.

If an incremental backup is restored without the full backup being in place the incremental will fail (unless the incremental was the first backup command give, or the incremental backup used the -io option which was large enough to encompass the full backup).
Keyword Phrase
Last Modified Date6/1/2022 2:26 PM

Powered by