带库或VTL作为关键业务的备份，虽在普通用户接触较少，但总体使用量还是比较大。
很多实例在做专业备份软件的同时会采用disk方式在本地或共享地址上再备一次，如果专业备份软件采用的是带库或VTL方式进行存储，在cross check后发现存在大量的备份集仍然无法删除，可以参考本文。
export ORACLE_SID=bzzh1date >> /home/oracle/rman_log/rman_delete.logrman target / append << EOFconfigure device type disk parallelism 16;allocate channel for maintenance device type disk;run{crosscheck backup;delete expired backup;crosscheck archivelog all;delete noprompt obsolete device type disk;delete noprompt expired archivelog all;}release channel;##for TAPE##allocate channel for maintenance device type 'sbt_tape';run{crosscheck backup;delete expired backup;crosscheck archivelog all;delete noprompt obsolete device type 'sbt_tape';delete noprompt expired archivelog all;}release channel;EOFdate >> /home/oracle/rman_log/rman_delete.log
需要注意，仅当backupset的Device Type为SBT_TAPE是参考本文才有意义。
BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------3177 Incr 0 256.00K SBT_TAPE 00:00:47 30-JUL-15BP Key: 3137 Status: AVAILABLE Compressed: NO Tag: HOT_DB_BK_LEVEL0Handle: bk_3229_1_886451722 Media:SPFILE Included: Modification time: 10-JUL-15BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------3179 83.75M SBT_TAPE 00:00:57 30-JUL-15BP Key: 3139 Status: AVAILABLE Compressed: NO Tag: TAG20150730T203744Handle: al_3230_1_886451865 Media:List of Archived Logs in backup set 3179Thrd Seq Low SCN Low Time Next SCN Next Time---- ------- ---------- --------- ---oracle账号------- ---------1 4005 12030094721658 30-JUL-15 12030095358801 30-JUL-151 4006 12030095358801 30-JUL-15 12030095373861 30-JUL-15