Kbase P10047: Cannot find or open first data extent file on trying to start the database.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/03/2009 |
|
Status: Verified
SYMPTOM(s):
Start of database fails with following message: cannot find or open file <path to first missing extent>, errno = 2 (43)
All data extent files are missing
Current .db file shows nine data extents via prostrct list
Only backup available is an OS copy of six data extents
No data was entered since adding the three additional data extents
Unable to end after imaging
FACT(s) (Environment):
Progress 8.3B
IBM AIX
CHANGE:
All data extents were deleted
CAUSE:
The database fails to start because all the data extents were deleted after the prostrct add
FIX:
Follow the steps below to recover from missing data extents:
1. Run prostrct list dbname to get the current .st file which shows nine data extents
2. Restore the available data extents from backup to the directory where database is located.
3. Use prostrct create to create a void database with three data extents in a different directory.
4. Copy those extents to the database directory.
5. Modify the three data extents to agree with expected extents 7,8, and 9.
6. Make sure that the .st file contains the correct paths to all nine data extents.
7. Run prostrct unlock <dbname>
8. Run rfutil dbname -C aimage end
9. Run proutil dbname -C truncate bi -F
10. Run probkup dbname <path to backup file>
11. Restart after imaging
12. Restart the database
13. Dump and load this database at the first opportunity