Try OpenEdge Now
skip to main content
Database Administration
Protecting Your Data : Recovering a Database : Recovering from media failures : Loss of the AI file
 
Loss of the AI file
The following procedure describes what to do if a disk holding the AI files is damaged or the AI file is accidentally deleted.
To recover from the loss of an AI file:
1. 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.
2. Disable after-imaging using the RFUTIL AIMAGE END utility.
3. If you have a database, re-create the lost extent using PROSTRCT ADD.
4. Back up the database using the PROBKUP utility or an operating system backup utility.
5. 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.
6. Enable after-imaging.
7. Re-enable two-phase commit if you disabled it in Step 1.