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

OEM Agent Installation

./agentDeploy.sh AGENT_BASE_DIR=/u001/oracle/product/agent13c OMS_HOST=oem-dev.xxx.com EM_UPLOAD_PORT=1159 AGENT_REGISTRATION_PASSWORD=*****...