Oracle Archival Backups


If you need to preserve an online backup for a specified amount of time, RMAN normally assumes you might want to perform point-in-time recovery for any time since that backup to the present. To satisfy this scenario, RMAN keeps the archived logs for that time period (unless you specified NOLOGS). However, you may have a requirement to simply keep the specific backup (and what is necessary to keep it consistent and recoverable) for a specified amount of time—for example, for two years. You do not have the intention of recovering to a point in time since that backup, but you just want to be able to recover to the exact time of the backup, and no later. You also want to maintain a retention policy that keeps your backup area free of clutter, so making it reach back two years is not acceptable. This is a common need, when meeting business or legal requirements for data retention.


An archival backup solves this problem. If you mark a backup as an archival backup, that attribute overrides any configured retention policy for the purpose of this backup. You can retain archival backups such that they are either considered obsolete only after a specific time that you specify, or never considered obsolete. If you want to specify the latter, you need to use a recovery catalog.

An archival backup also guarantees that all of the files needed to restore the backup are included. RMAN includes the data files, archived log files (only those needed to recover an online backup), and the relevant autobackup files. All these files must go to the same media family (or group of tapes).

You can also specify a restore point to be created, which has the same SCN as the archival backup. That essentially gives a meaningful name to the point of time the backup was made.

After an archival backup is created, it is retained for as long as specified. Even if you have a much smaller retention window and run the DELETE OBSOLETE command, the archival backup remains.

This backup is a snapshot of the database at a point in time, and can be used to restore the database to another host for testing purposes, for example.

Note: Archival backups cannot be written to the Flash Recovery Area. So if you have one, you must provide a FORMAT clause to specify a different location.

Creating Archival Backups with EM
To create an archival backup using Enterprise Manager, perform the following steps:

·        Select Availability > Schedule Backup > Schedule Customized Backup.
·        Follow the steps of the Schedule Customized Backup wizard until you are on the Settings page.
o   Click Override Current Settings and then the Policy tab. In the Override Retention Policy section, you can select to keep a backup for a specified number of days. A restore point is generated based on the backup job name. You probably also want to specify a different destination for the backup files; to do this, use the Device tab.

Creating Archival Backups with RMAN
Use the following syntax to create an archival backup using RMAN:
BACKUP ... KEEP {FOREVER|UNTIL TIME 'SYSDATE + <n>'} RESTORE POINT <restore_point_name>

The UNTIL TIME clause enables you to specify when the archival backup is no longer immune to the retention policy. You can optionally specify FOREVER, meaning that the backup is an archival backup until you take some other action to change that.
Optionally, use the RESTORE POINT clause to specify the name of a restore point to be associated with this backup.