Backup Cycles (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Backup Cycles

Definition

This section gives you recommendations on how to plan a backup cycle for your Oracle database. We recommend a backup cycle of at least 14 days, preferably 28 days. For more information on the tapes required, see Backup Media.

Use

Recommended 28-Day Backup Cycle

This graphic is explained in the accompanying text

The guidelines are as follows:

Perform a full online backup each working day.
Perform a full offline backup at least once in the cycle, or at least weekly.
Back up the offline redo log files each working day and after every online and offline backup. Be sure to back up the offline redo log files twice on separate tapes.
To verify the process, you need to:

Verify backups for physical errors
Verify the database for logical errors at least once in the cycle

Keep the verified full offline backup from each cycle in long-term storage, replacing it with a new initialized tape in the pool.
Remember to perform additional backups after changes to the database structure and keep these tapes in long-term storage. You need to do this after any of the following:

A data file is added
A data file is moved to a different location
A tablespace or its data files are reorganized