Rman backup Management

 Dear's

An essential part of a backup and recovery strategy is managing backups after you create them. Backup management includes deleting obsolete backups and performing periodic checks to ensure that backups are available and usable.

A backup recorded in the Oracle Recovery Manager (RMAN) repository has one of the following status values:

Available, meaning that the backup is still present on disk or tape, as recorded in the repository

Expired, meaning that the backup no longer exists on disk or tape, but is still listed in the repository

Unavailable, meaning that the backup is temporarily not available for data recovery operations (because, for example, it is stored on a tape that is stored offsite or on a disk that is currently not mounted)

Backups can also be obsolete. An obsolete backup is, based on the currently configured retention policy, no longer needed to satisfy data recovery goals.

Maintenance tasks that you can perform in RMAN include the following:

Viewing details about your backups

Cross-checking your repository, which means checking whether backups listed in the repository exist and are accessible, and marking as expired any backups not accessible at the time of the cross-check

Deleting the record of expired backups from your RMAN repository

Deleting obsolete backups from the repository and from the backup media

Validating backups to ensure that a given backup is available and not corrupted

Cross-Checking Backups  :

LIST BACKUP SUMMARY;

CROSSCHECK BACKUPSET 1345;

CROSSCHECK DATAFILECOPY 1,5;

CROSSCHECK BACKUP;

Deleting Expired Backups  : 

Deleting expired backups removes from the Oracle Recovery Manager (RMAN) repository those backups that are listed as EXPIRED. Expired backups are those found to be inaccessible during a cross-check. No attempt is made to delete the files containing the backup from disk or tape; this action updates only the RMAN repository.

CROSSCHECK BACKUPSET;

DELETE EXPIRED BACKUP;

LIST BACKUP SUMMARY;

DELETE OBSOLETE;

SELECT * FROM V$RECOVERY_FILE_DEST;

SELECT * FROM V$RECOVERY_AREA_USAGE;