Kbase P11011: Can I use a third party tool to perform an online backup ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/27/2009 |
|
Status: Verified
GOAL:
Can I use a third party tool to perform an online backup ?
GOAL:
Is Microsoft Volume Shadow Copy Service (VSS) a supported solution for taking online backups of a PROGRESS database?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
3rd Party backup utilities to perform online backup are not supported by Progress, they are supported by their vendor. The only online backup supported is our probkup online and use of the proquiet utility for OS copies (which this 3rd party product falls under).
Typically, problems reported previously are dbdown situations with 9446 1124 error messages as a result:
SYSTEM ERROR: <function>: Bad file descriptor was used during <system call>, fd <file descriptor>, len <bytes>, offset <bytes>, file <file-name>. (9446)
SYSTEM ERROR: wrong dbkey in block. Found <dbkey>, should be <dbkey2> (1124)
Essentially caused by the product accessing the run-time Progress environment.
Options:
1. Ensure that the utility does not access the run-time environment
2a. probkup your database online, move the probkup elsewhere, the probkup is then copied by the 3rd party utility
2b. Use the proquiet utilitiy (added for mirroing etc), take the copy, release the quiet point. NOTE: It is imperative the the quiet point is raised before the copy utilitiy is allowed to continue so that the database is not flushing data to the disks. During the quiet point time, all except READ access to the the database will be frozen so try to avoid this operation while the database is being highly used or while there are many users connected.
In any event, as with any DR plan, this should not be implemented until fully tested, including the 'other' side of the story: restoring.