Backup Approach with One-Day Retention Period
Use
This section describes a sample backup approach for your Oracle database using daily full backups but with a retention period of only one day.
Caution
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.
Figure 1:
Faulty Backup Approach