When I view the rc_backup_piece table via SQLPLUS, my backupsets goes as far back as Jan 2002. My retention policy is set to 366 days. When I issue the delete obsolete command in Rman it works but does not remove the backups created in 2002- 2004. I assume that the old backups are not known to Oracle Rman. Is there a way to cleanup the catalog by removing these backupset through SQLPLUS? I thought maybe I can change the Status to "Delete" and then run the prgrmanc.sql script. (But which table would I change).
Also this catalog contains backupsets from 28 different instances/database.