Backup Approach with One-Day Retention Period 

This section describes a sample backup approach for your Oracle database using daily full backups but with a retention period of only one day.

Do not follow the example shown in this section. It is included to illustrate a faulty backup approach.

In this example, a complete backup is performed offline once a day. However, the retention period is set to 1 day, so the two tapes required are overwritten each day.

In the event of a disk error, the single backup has to be used. If it cannot be read, the database is destroyed. As the redo information has not been saved separately, all transactions executed since the last backup are lost, if a disk failure affects data and redo information.

Faulty Backup Approach

 

See also:

Backup Approach with Daily Complete Backups

Backup Approach for Very Large Database with Partial Backups