I want to remove RMAN catalog entries older than 30 days. The backup pieces have long since been moved off the system.
I understand I can use the RMAN CHANGE command to remove just the catalog records but I can't find the syntax anywhere. Can anyone help me?
Here's my best guess at piecing it together:
CHANGE BACKUP COMPLETED BEFORE 'SYSDATE-30' UNCATALOG;