I am running RMAN NOCATALOG, we run backup with level=0 (baseline, full) every monthend leve 1 every weekend and level 2 during weekday. when we issue
list backupset of database;
there are huge list of backup history listed. I try to use change backuppiece key validate, to remove those old history since it is useless (we only want keep the last month or two backup piece and history). the error is:
RMAN-03022: compiling command: change
RMAN-03026: error recovery releasing channel resources
RMAN-00569: ================error message stack follows================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: change
RMAN-06038: recovery catalog package detected an error
RMAN-20300: operation not supported without the recovery catalog
RMAN-06092: error while looking up backup piece
it only works with catalog!!!
Does anyone know how to remove those old history useless piece?
You have to mark them individually as delete, then use the file in $ORACLE_HOME/rdbms/admin/, the file name is prgrmanc.sql. This file will remove all files marked as delete from your catalog. I find it very tedious and time-consumming. I'd like to find out who can do it more effectively.
rman>allocate channel for maintenance type 'disk'
2>change backupset xxx,xxx,xxx delete;