用磁带后改用本地磁盘备份可能出现的问题:
RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of delete command at 03/01/2014 09:45:04RMAN-06091: no channel allocated for maintenance (of an appropriate type)使用RMAN> report obsolete;可以看到有两种类型的备份数据在结果中。处理步骤:1、删除磁盘过期文件:rman target sys/####@orcl catalog rman/#####@rmanallocate channel for maintenance device type disk;resync catalog;delete obsolete device type disk;DELETE OBSOLETE REDUNDANCY = 3;
2、删除磁带过期文件:rman target sys/####@orcl catalog rman/#####@rmanallocate channel for maintenance device type 'sbt_tape'send 'ENV=(SERVER=ORACLE.BACKUP.200,CLIENT=database.localdomain,DATA_VOLUME_POOL=DDBoost,NO_MULTIPLEX=TRUE)';DELETE OBSOLETE REDUNDANCY = 3;此处要与原来写在rman备份脚本里的配置相同。或者allocate channel for maintenance device type 'sbt_tape' PARMS 'ENV=(OB2BARTYPE=Oracle9i,OB2APPNAME=backup,OB2BARLIST=swt-oracle-full)';