Kbase P24116: How to recover from a missing or lost AI file?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/28/2003 |
|
Status: Unverified
GOAL:
How to recover from a missing or lost AI file?
FIX:
1- Shut the database down.
2- If two-phase commit is enabled for the database, end two-phase commit using the PROUTIL 2PHASE END utility. You must do so before you can perform the next step.
NOTE: If you end two-phase commit and a coordinator recorded any distributed transaction commits in this database, the user cannot resolve any limbo transactions where this database was the coordinator.
3- Disable after-imaging using the RFUTIL AIMAGE END utility.
4- Run the PROSTRCT REMOVE utility for each missing or lost AI file of the database.
5- Re-create the missing or lost AI extent(s) using PROSTRCT ADD.
6- Back up the database using the PROBKUP utility or an operating system backup utility.
7- If you used an operating system backup utility to back up the database, mark the database as backed up using the RFUTIL MARK BACKEDUP utility.
8- Enable after-imaging using RFUTIL AIMAGE BEGIN.
9- Re-enable two-phase commit if you disabled it in Step# 2.