Archival Backup in 11g

1. New in Oracle 11g is a feature that permits you to create a backup that will not be affected by the normal retention policy defined for backups taken using RMAN.

2. Such backups once created may be exempted from the normal backup and recovery strategy.

3. These backups may be created on separate backup media other than the flash recovery area to be retained for a long time.

4. These kinds of backups may require to be maintained for business or legal requirements. They will not be displayed when you view the obsolete backups based on your retention policy.

5. This backup is "all-inclusive" and every datafile of the database, control file, server parameter file needed for restore and recovery is backed up to a single disk or tape device.

6. It also automatically generates an archive redo log backup to ensue that the database backup can be recovered to a consistent state.

7. Typically these backups are done to tape.

8. An archival backup are created with the BACKUP…KEEP command.

9. The KEEP option indicates that the backupset should be exempt from the retention policy either forever (KEEP FOREVER clause) or for a specified time period (KEEP UNTIL TIME).

10. The KEEP FOREVER clause requires the use of a recovery catalog database.


The RMAN syntax

KEEP {FOREVER| UNTIL TIME ‘SYSDATE +n’}

RESTORE POINT restore_point_name

where the restore point is a user-defined name associated with an SCN of the database corresponding to the time of the

creation of the restore point. The restore point would act as a label for the SCN to which the backup must be recovered to

be made consistent. The restore point option is not allowed with the CHANGE…KEEP command described later.

An example:

RMAN> BACKUP TAG FORBKP DATABASE KEEP FOREVER;

RMAN>BACKUP DATABASE FORMAT '/%U.bkp' KEEP UNTIL TIME 'sysdate + 365';

Modify The archival backup settings by CHANGE Command

The CHANGE... NOKEEP may be used to remove the KEEP attributes of a backup, making it subject to the backup retention policy.

The CHANGE…KEEP command may be used to change a consistent backup into an archival backup.

RMAN> CHANGE BACKUP TAG 'full_orcl_backup' KEEP FOREVER;

Archival Backups using Enterprise Manager (OEM):
Database Control Home Page

- Availability tab

- Schedule Backup

- Schedule Customized Backup (Wizard)

- Setting Page

- Override Current Settings Button

- Policy

- Over Retention Policy Section

- You can select to keep a backup for a specified number of days.

Thanks,