Progress
Database Administration
Guide and Reference
Example 4: High Availability Requirements
The database administrators at site D have determined the following availability requirements. Table 8–4 provides examples.
Given these high availability requirements, the database administrators keep a duplicate database on warm standby. They follow these steps:
- Restore a backup of the production database to an empty database with a duplicate structure on a different system.
- On the production database, enable after-imaging using AI files with fixed-length extents.
- On the production database, whenever a fixed-length AI extent becomes full, copy it to the standby system and roll it forward on the standby database.
- After bringing the standby database up to date, mark the full after-image extent on the production database as empty to make it available for reuse.
In addition, backups and AI files are constantly tested and verified on the standby database. The standby database is put through crash recovery, verified, and if possible, backed up before restoring online backups of the production database to the standby database.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |