Kbase 19831: Error 873, when attempting to access the database in single user mode?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Verified
SYMPTOM(s):
Attempting a Single User connection to the database.
SYSTEM ERROR: Physical redo, BKUPDCTR=<number>, note updctr=<number>. (873)
CAUSE:
This error is typically seen when a single user has logged onto the database and has not yet logged out of the database.
In this case, if a new user deleted the dbname.lk file then a log in can take place. It is normally not possible for another session to take place.
Review the database.lg file for single user entries and exits, determine if a previous user has currently established a single user connection to the database and has not logged out.
If the database has two single-user sessions logged in at the same time.
The potential for a corrupt before image file is close to 100 percent.
FIX:
Restore the database from last good backup.
If no backup is available then force the truncation of the bi file.
proutil <database name> -C truncate bi -F
Now the database must be dumped and reloaded into a brand new database.