How to delete failed Oracle RMAN backups ?

How to delete failed Oracle RMAN backups ?

Failed Oracle Database backups will increase the utilization size of “tape library” or “data domain” or “ZFS storage”
Deleting those failed/unnecessary  backups immediately will resolve space issues ,and billing related issues.

Step 1 ) get the list of backup sets from List backp database;

Step 2) Prepare the script to delete the archive logs.

Step 3) run the script after connecting to rman target .

Note : No catalog connection is required.

rman target /

run
{
allocate channel for maintenance device type ‘SBT_TAPE’ parms=
‘ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo_ORCLP.opt)’;
delete noprompt force BACKUPSET 86231, 86232;
}

Step 4) crosscheck backup;

 

See also