I face this issue when my Tivoli admin friends warn me about old backup which could be listed on Tivoli Storage even I delete my all old RMAN backups with RMAN commands on our 11.2.0.4 database have 11.2.0.4 database on AIX 6.1 which we use RMAN backup utility with RMAN catalog by using Tivoli tool

First I connect to RMAN catalog,

RMAN> show all;
RMAN configuration parameters for database with db_unique_name XXXX are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 8 DAYS;

then run below RMAN commands to delete my backup which is older than 8 days;

run
{
ALLOCATE CHANNEL C1 device type ‘sbt_tape’ ;
delete force noprompt obsolete;
RELEASE CHANNEL C1;
}

After this command  I checked below

RMAN>  LIST EXPIRED BACKUPSET;
the specification does not match any backup in the repository
RMAN> LIST EXPIRED BACKUP;
the specification does not match any backup in the repository

also, report obsolete doesn’t bring any data, but my Tivoli admin friends keep saying me they see still an old backup.

We noticed that When an RMAN delete command is run, RMAN deletes entries in the recovery catalog before confirmation from the Tivoli Storage Manager server.

We followed Remove Backups From Tivoli not available in RMAN catalog [ID 1209740.1] docs and We solved the problem.

 

Advertisements