Kbase P73015: Errors 9971 and 9972 after messing before image file due to
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/03/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1X
FACT(s) (Environment):
UNIX
SYMPTOM(s):
Invalid before image version number found in bi file . (9971)
This is a version <version-number> bi file. (9972)
Playing with tar in order to make a copy of a database
Backup of a database is not available
Errors 9971 and 9972 after messing before image file due to incorrect tar command syntax
CHANGE:
Incorrect tar syntax has caused a corruption in a before-image file
FIX:
1) create an empty structure using database.st file in another directory
2) copy .b1 file from new directory to database directory (replace the corrupted .b1)
3) prostrct repair <dbname>
4) prostrct unlock <dbname> and answer Y when asked
5) proutil <dbname> -C truncate BI -G 0 -F and answer Y when asked
6) access your db in single user mode and dump .df, data and sequences out
7) load them back to a brand new database
Since the before-image file have been wiped out, latest changes to a database might be in vain - data integrity checkup is recommended.