Kbase P119044: A database created with an operating system copy while database was in use contains corruption and g
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/12/2009 |
|
Status: Verified
SYMPTOM(s):
A database created with an operating system copy while database was in use contains corruption and generates error 876.
The source database used in the OS copy has no corruption.
The database was served while the operating system copy was being made.
The database was in single user mode while the operating system copy was being made.
** The database was last used <date/time>. (886)
** The before-image file expected <date/time>. (887)
** Those dates don't match, so you have the wrong copy of one of them. (888)
SYSTEM ERROR: Invalid record with recid <recid> area <area-num> <inst-num>. (10833)
SYSTEM ERROR: Record continuation not found, fragment recid <recid> area <areanum> <msg-inst> . (10831)
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
CAUSE:
The database was in use while the operating system copy was performed.
This type of backup is not supported since most of the changes are occurring in memory and can not be seen by the operating system.
FIX:
If a database is served and any non-Progress backup tools are required / preferred, consider using proquiet (added in version 9) to force a sync of memory down to disk.
After the proquiet has taken effect (review database log file to validate when proquiet has completed the enable).
This will suspend writes during the period the quiet point is enabled but will allow an OS tool to safely backup the files on disk and make sure all files are up to date.
If the database is in single user mode, do not attempt to use a non-Progress backup to copy the files on disk as they are dynamically being updated and the non-Progress tool will most likely catch the files midstream and the resultant files will most likely be out of sync.