Try OpenEdge Now
skip to main content
Database Administration
Protecting Your Data : Recovering a Database : Recovering from media failures : Loss of the DB files, BI files, or both
 
Loss of the DB files, BI files, or both
If a disk holding the DB or BI files is damaged, or the files are accidentally deleted, you can restore the database.
To restore the database after the loss of DB and/or BI files:
1. Back up the current AIfile and any full AI files not already archived before rolling forward. This step is important to protect yourself in case you lose the AI files if anything goes wrong, such as inadvertently overwriting the AI file. Be sure to back up the AI files on media different from the media where the database files are backed up. The AI files have the information you require to bring the database backup files up to date.
2. Create the structure for the database. You will restore the database to this structure.
3. Restore the most recent full database backup. If you are using incremental backups, you must restore the most recent full backup and then apply all the incremental backups.
4. If you use after-imaging, roll forward the AI files starting after the last backup. Use the RFUTIL ROLL FORWARD utility. See After-imaging for more information.
5. Perform a full backup of the restored, recovered database. Follow the standard backup procedure described in BackingUp a Database.
6. Restart after-imaging and two-phase commit, if you are using it.
7. Restart the database.
8. Restart the applications and continue database processing.