Salesforce

What does prorest -vp do?

« Go Back

Information

 
TitleWhat does prorest -vp do?
URL NameP14232
Article Number000131487
EnvironmentProduct: Progress,OpenEdge
Version: All supported versions
OS: All supported platforms
Question/Problem Description
What does prorest -vp do?
Why prorest -vp and prorest -vf doesn't display any error while verifying corrupted database backup?
Is there any benefit to using prorest -vp after an online probkup to disk?
Why prorest -vp doesn't detect any error when database backup media are corrupted?
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
Partial verification of online PROBKUP volume(s) and full verification of offline PROBKUP volumes assure they can be considered reliable. These verification routines do not result in a database restore or overwrite or update the database used to verify the backup volume in any way.

Before verifying the backup volume(s), ensure the PROBKUP completed without error.

Neither prorest -vp nor prorest -vf is a test for data corruption.

The PROREST (-vp) parameter is used to perform a partial verification of the backup volume for bad blocks and reports whether any exist. 
  • The prorest utility when used with the -vp parameter instructs the prorest utility to read the backup file(s) and compute and compare the backup block cyclic redundancy checks (CRC's) with those in the block headers.  
  • If there is an inconsistency detected a CRC errors will be reported "CRC check failed reading backup block n"
  • This is an indication that something is wrong with the backup volume(s). 
  • When any bad blocks are reported, it is possible to recover data from bad blocks if a redundancy factor was specified when the backup was made (-red). 
  • If no bad blocks are reported, then the backup should restore without issue.

Prorest "-vf" compares the contents of each backup block with the corresponding database block of the database which the backup was taken from, to see if they match.

  • If the data in the database block is corrupted but it matches the data in the backup it will not generate any error. Block corruption is raised at the time the PROBKUP utility creates the backup volume, failing a complete backup and resulting in a dbdown.
  • The Full Verify (-vf) should only be used immediately after a full offline backup is performed. Error 9454 is reported when inconsistency is found: 
DB block in area <number> with dbkey <dbkey>, does not match backup. (9454)
Full verify failed. (3757)
  • A full verify (-vf) should not be used in conjunction with online backups. The database would have changed since the backup was run the blocks recorded in the backup volume will not match those in the current database at the time the full verification check is run and will generate 9454 messages raising false alarm.
Workaround
Notes
References to Other Documentation:

Progress Database Administration Guide and Reference.

Version 11.7:  
Progress Information Hub: OpenEdge Data Management: Database Administration: Backing Up a Database: Verifying a Backup:
https://docs.progress.com/bundle/openedge-database-management-117/page/Verifying-a-backup.html

Version 12.2:
Progress Information Hub:  Manage the OpenEdge Database:  Backing Up a Database:  Verifying a backup:
https://docs.progress.com/bundle/openedge-database-management-122/page/Verifying-a-backup.html

 
Keyword Phrase
Last Modified Date4/9/2021 3:16 PM

Powered by