Try OpenEdge Now
skip to main content
Database Administration
Reference : Other Database Administration Utilities : PROREST utility
 

PROREST utility

Verifies the integrity of a database backup or restores a full or incremental backup of a database.

Syntax

prorest db-namedevice-name{ -vp | -vf | -list | -keeptargetlfe }
           [ -dbrestrict restrict-type][-verbose]

Parameters

db-name
Specifies the database where you want to restore the backups.
device-name
Identifies the directory pathname of the input device (for example, a tape drive) or a standard file from which you are restoring the data. If device-name identifies a block or character special device, PROREST assumes the device has removable media, such as a tape or a floppy diskette.
-vp
Specifies that the restore utility reads the backup volumes and computes and compares the backup block cyclic redundancy checks (CRCs) with those in the block headers. To recover any data from a bad block, you must have specified a redundancy factor when you performed the database backup. See Backing Up a Database for more information about error correction blocks and data recovery.
-vf
Specifies that the restore utility only compares the backup to the database block for block.
-list
Provides a description of all application data storage areas contained within a database backup. Use the information to create a new structure description (.st) file and database so you can restore the backup.
-keeptargetlfe
Restores a backup without enabling large files.
By default, restoring a database backup that has large files enabled, enables large files on the target database, even if the target is an existing database without large files enabled. Use this parameter to restore a backup without enabling large files on the target database.
Note: PROREST does not ensure that the target database is sized to hold all the restored data. In the event that the target database is too small, the behavior of PROREST is unchanged, it exits with an error.
-dbrestrict restrict-type
Protects the restored database from updates by other users by putting the database in a restricted access mode where restrict-type is one of the following values:
*rollforward — Indicating that the next allowable activity on this database is rolling forward after-image files
*datamove — Indicating that the next allowable activity on this database is moving data with the datamove utility
*partitioncopy — Indicating that the next allowable activity on this database is copying data with the partitionmanage copy utility
Adding -dbrestrict enables the same restrictions as PROUTIL DBRESTRICT. See PROUTIL DBRESTRICT qualifier for details of the restrictions.
-verbose
Displays additional information as the restore is performed, such as:
*If the target of the restore doesn't exist, -verbose lists the target area size information.
*For restore full verify (-vf) and restore partial verify (-vp), -verbose displays periodic updates that include the number of blocks verified, the elapsed time, and an estimate of the time remaining given the current rate of progress.

Notes

*When restoring a backup, the target database must contain the same physical structure as the backup version. For example, it must have the same number of storage areas, records per block, and block size.
*PROREST creates storage areas that match the information provided by the -list qualifier. However, if you do not create and apply a structure definition (.st) file to your target database, PROREST creates one variable-length extent per area. To have multiple extents, you must create and apply a structure definition file to your target database before performing the restore.
The following figure shows an example of the output generated by the -list qualifier.
Table 108. Sample PROREST -list output
OpenEdge Release 10.2B1P as of Wed Oct 21 19:01:48 EDT 2009
Area Name: Schema Area
Size: 11264, Records/Block: 32, Area Number: 6, Cluster Size: 1
Area Name: Info Area
Size: 1024, Records/Block: 32, Area Number: 7, Cluster Size: 1
Area Name: Customer/Order Area
Size: 6656, Records/Block: 32, Area Number: 8, Cluster Size: 8
Area Name: Primary Index Area
Size: 112, Records/Block: 1, Area Number: 9, Cluster Size: 8
Area Name: Customer Index Area
Size: 256, Records/Block: 1, Area Number: 10, Cluster Size: 64
Area Name: Order Index Area
Size: 8192, Records/Block: 32, Area Number: 11, Cluster Size: 64
Area Name: Encryption Policy Area
Size: 20448, Records/Block: 32, Area Number: 12, Cluster Size: 64
Area Name: Audit Area
Size: 4608, Records/Block: 32, Area Number: 20, Cluster Size: 8
Area Name: Audit Index
Size: 8704, Records/Block: 32, Area Number: 22, Cluster Size: 8
Use the output of PROREST -list to calculate the size of each restored area as follows:
area-size = (Size / records-per-block) * database-block-size
For example, the size of the restored schema area is:
area-size = (Size / records-per-block) * database-block-size
1,441,792 = (11264 / 32) * 4096
If you do not know your database block size, the output of PROREST -vp or -vf provides the information.
*PROREST restores transaction log (TL) extents.
*If your database is enabled for transparent data encryption, you must restore your key store file (dbname.ks). You must back up and restore your key store independent of your database using operating system utilities. The key store is not backed up by PROBKUP or restored by PROREST.
*Before you restore a database, you might want to verify that your backup does not contain any corrupted blocks. You can 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. You must use the PROREST utility separately to restore the database.
*You can use the Partial Verify parameter with both online and offline backups.
*Use the Full Verify parameter immediately after performing an offline backup to verify that the backup is correct.
*PROREST supports the use of internationalization startup parameters such as -cpinternalcodepage and -cpstreamcodepage. See Database Startup Parameters for a description of each database-related internationalization startup parameter.