Kbase P23046: Database will not start due to a missing data extent.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/2/2009 |
|
Status: Verified
SYMPTOM(s):
Database will not start due to a missing data extent.
Missing data extent is the last extent.
Last extent was an empty variable extent.
Getting the missing extent from the customer is not an option at this time.
Getting a backup of the database with all the files present is not an option.
FACT(s) (Environment):
Windows 2000
Progress 9.x
OpenEdge Category: Database
CHANGE:
This is a copy of a production database sent in without the last data extent.
CAUSE:
Missing data extent.
FIX:
This solution is a business decision.
Running prostrct unlock bypasses the bi file, thus the recovery process.
Recommendation of Progress is to restore from backup rather than to bypass the bi file.
1.) First ensure that a structure file exists where the dbname.db file resides with fully qualified paths, describing EVERY extent that should be in place
2.) Run prostrct unlock dbname -extents
3.) Start database in single user mode.
4.) Stop database.
5.) Dump and load the database.