Previous Topic: RECOVERY (Rebuild a Database)Next Topic: When to Use


Types of Recovery

There are two RECOVERY options available:

Forward

Reapplies maintenance transactions as they are recorded in the Recovery File (RXX). Use forward recovery to bring a database up to date when a restore of a previous backup has been necessary.

Backward

Reverses maintenance transactions recorded in the Recovery File (RXX). Use backward recovery to reverse or back out maintenance that was applied.

Note: Because SQL DDL statements are not recorded in the Log Area, they are not recoverable using the RECOVERY function of the DBUTLTY. In the case of DDL statments, it is therefore your responsibility to ensure the existence of the Directory (CXX) defintions necessary for recovery.