Delete old rman backup piece manually
My Nagios checking reported there were an old backup dated back 2010. There is no such backup on disk. RMAN crosscheck and delete wont be able to remove it.Tried to delete it with “nice” rman command:
RMAN> delete backup tag = 'TAG20101029T101009'; allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=317 device type=DISK specification does not match any backup in the repository RMAN> delete backuppiece tag = 'TAG20101029T101009'; using channel ORA_DISK_1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of delete command at 01/12/2012 09:59:49 RMAN-06168: no backup pieces with this tag found: TAG20101029T101009Resort to manually deleting in the base table:
SELECT * FROM rc_backup_set where db_id='1320220071' order by start_time select * from bp where db_key=10492312 and tag = 'TAG20101029T101009' delete from bp where db_key=10492312 and tag = 'TAG20101029T101009'