2,333 views
in RMAN by ACE (20,920 points)

1 Answer

by ACE (20,920 points)

Delete expired : to remove records of expired backups from the RMAN repository marked by crosscheck command if
rman cannot locate the backups.

Syntx : CROSSCHECK BACKUP;
        DELETE EXPIRED BACKUP;


Delete Force :

RMAN repository says that a backup set is AVAILABLE when it is in fact no longer present on disk.
Ignores any I/O errors

Syntx: DELETE FORCE NOPROMPT BACKUPSET TAG 'weekly_bkup'

Error : RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
        RMAN-06208: to mismatched status.  Use CROSSCHECK command to fix status



Delete Obsolete :

The files deleted are removed from backup media, deleted from the recovery catalog,
and marked as DELETED in the control file.
No longer needed to satisfy specified recoverability requirements.
You can also use the REDUNDANCY or RECOVERY WINDOW clauses.

Syntax:

DELETE OBSOLETE;
DELETE OBSOLETE REDUNDANCY = 3;
DELETE OBSOLETE RECOVERY WINDOW OF 7 DAYS;

Categories

...