19 January, 2018

How to Delete Old Obsolete and Expired Oracle RMAN Backup

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

RMAN-06210: List of Mismatched objects


$ rman
$rman> connect target
rman> crosscheck backup;
rman> report obsolete;
rman> delete obsolete;
            say YES when prompt

If above command able to delete obsolete backup then good otherwise use force delete option like
rman> delete force obsolete;
            say yes


RMAN> report obsolete;

RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 2 no obsolete backups found

No comments:

Post a Comment

Finding OPP Manager log for a concurrent request

=> Use below query to find the OPP manager log for a concurrent request.  SELECT fcpp.concurrent_request_id req_id, fcp.node_name, fcp.lo...