Show TOC

Example documentationBackup Approach with One-Day Retention Period Locate this document in the navigation structure

 

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 Caution

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

End of the caution.

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.

This graphic is explained in the accompanying text.

Faulty Backup Approach