Kbase P120642: Probkup online estimates incorrect media size when database is greater than 4 GB.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/11/2011 |
|
Status: Verified
SYMPTOM(s):
Probkup online estimates incorrect media size when database is greater than 4 GB.
<num> active blocks out of <num> blocks in <name> will be dumped. (6686)
Backup requires an estimated <size+identifier> of media. (9285)
Restore would require an estimated db blocks using <size+identifier> of media. (9286)
probkup online estimates incorrect media size
the Probkup command option "-estimate" gives wrong information.
Numbers from messages 6686 and 9285 show the problem
Message 9286 gives correct numbers
Log file entry showing incorrect media estimate:
4197998 active blocks out of 4198028 blocks in /<path>/<database> will be dumped. (6686)
Backup requires an estimated 35.7 MBytes of media. (9285)
Restore would require an estimated 4197998 db blocks using 4.0 GBytes of media. (9286)
FACT(s) (Environment):
A correct estimate shown for database smaller than 4 GB
All Supported Operating Systems
OpenEdge 10.x
Progress 9.1D
Progress 9.1C
OpenEdge Category: Database
CHANGE:
Database grew over 4 Gig
CAUSE:
Bug# OE00100082
CAUSE:
probkup command the -estimate media size information is wrong when the database is greater than 4 GB in size.
FIX:
Use the final message of the online probkup that gives a more accurate reflection:
Wrote a total of <blocks> backup blocks using <size+identifier> of media. (9284)
As an alternative,
A. Use VST tables to find the sum of the High Water Mark (HWM) in each Storage Area, then add the size of the bi files to determine the amount of media required for the probkup. Progress Solution P27398, "Virtual System Table (VST) used to calculate database occupation" provides an example of how this may be achieved.
B. Use the backed up volumes to calculate the restore size using the PROREST -LIST feature described in Progress Solution P145009, "How to find the database Storage Areas and extent sizes needed for a PROREST?"