Progress
Database Administration
Guide and Reference
Introduction To Recovery Mechanisms
The Progress Version 9 database has three kinds of recovery mechanisms:
Depending on your site requirements, you might choose not to implement all three of these recovery mechanisms. Figure 8–1 shows the order of precedence of these mechanisms. Crash recovery requires use of a recovery (BI) log and occurs without any interaction. Roll-forward recovery requires use of an after-image (AI) log. Two-phase commit requires use of a transaction log (TL). If you use two-phase commit, be sure to also use after-imaging.
Figure 8–1: Progress Recovery Mechanisms
![]()
Each mechanism relies on notes that are written to a file to record database changes. A note is a record of the smallest unit of change in a database. For example, a record of one change made to one block in the database. The database engine automatically records database changes as notes in the primary recovery (BI) log. If after-imaging is enabled, it also records notes to the after-image (AI) log. If two-phase commit is enabled, it also records transactions and notes to the transaction log (TL).
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |