RMAN-06091: no channel allocated for maintenance (of an appropriate type)

一、RMAN删除过期备份报错

RMAN> delete noprompt obsolete
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 01/01/2025 23:38:49
RMAN-06091: no channel allocated for maintenance (of an appropriate type)

二、原因

因为平时使用Commvault备份软件，控制文件中记录有磁带的备份信息

三、解决方法

1.修改默认设备类型为磁盘

通过show all命令查看rman配置信息:

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO DISK

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name HYEMR are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '+FRA/HYEMR/backup/%F_control.bak';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/HYEMR/CONTROLFILE/snapcf_HYEMR2.f';
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/HYEMR/CONTROLFILE/snapcf_hyemr2.f';

2.备份脚本指定磁盘类型

delete noprompt obsolete device type disk;

3.删除控制文件中磁带备份信息

RMAN> allocate channel for maintenance device type sbt parms 'SBT_LIBRARY=oracle.disksbt, ENV=(BACKUP_DIR=/tmp)';
RMAN> crosscheck backup;
RMAN> delete noprompt expired backup;
RMAN> list backup summary;