RMAN - removing old catalog entries

[hrishy]

Hi

Does this work

CHANGE BACKUPSETS COMPLETED BEFORE 'SYSDATE-30' UNCATALOG;

if that doesnt work one other way of doing that would be

http://www.orafaq.com/scripts/unix/purgecat.txt

Just change the line
echo "CHANGE BACKUPSET $key DELETE;" >>$CMDFILE

in that script to
echo "CHANGE BACKUPSET $key UNCATALOG;" >>$CMDFILE

and also this line
list backupset of database
from time 'SYSDATE-3000' until time 'SYSDATE-$DAYSTOKEEP'

Hmm Frank Nuade has done some smart MetaProgramming i beleive ;-)

regards
Hrishy