Release 10.1A: OpenEdge Data Management:
Database Administration

> ## 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 AI`` file 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 Chapter 7, "After-imaging," for more information.

> 5. Perform a full backup of the restored, recovered database. Follow the standard backup procedure described in Chapter 5, " Backing Up 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.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095