crosscheck backup ORA-19554

朋友在rman中执行crosscheck backup出现ORA-19554错误
RMAN> crosscheck backup;using channel ORA_DISK_1
released channel: ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 01/23/2015 17:23:19
ORA-19554: error allocating device, device type: STB, device name:
ORA-27001: unsupported device type
Additional information: 1
提示找不到STB，根本就没有这种设备，下面执行命令来显示所有配置信息
RMAN> show all;RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO "%F"; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE STB TO "%F"; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO "%F"; # default
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET PARALLELISM 1;
CONFIGURE DEVICE TYPE "STB" BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DEVICE TYPE "SBT_TAPE" BACKUP TYPE TO BACKUPSET PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE STB TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE STB TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT "/u02/test_df%t_s%s_s%p";
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM "AES128"; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO "/u01/app/Oracle/10.2.0/db/dbs/snapcf_test.f"; # default
上述信息中有
CONFIGURE DEVICE TYPE "SBT_TAPE" BACKUP TYPE TO BACKUPSET PARALLELISM 1;
说明确实有人设置了SBT_TAPE类型的设备信息，下面将其设置还原为默认值：
RMAN> configure device type "SBT_TAPE" clear;old RMAN configuration parameters:
CONFIGURE DEVICE TYPE "SBT_TAPE" BACKUP TYPE TO BACKUPSET PARALLELISM 1;
RMAN configuration parameters are successfully reset to default valueRMAN> show all;RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO "%F";
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE "STB" TO "%F";
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE "SBT_TAPE" TO "%F";
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET PARALLELISM 1;
CONFIGURE DEVICE TYPE "STB" BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE "STB" TO 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE "SBT_TAPE" TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE "STB" TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE "SBT_TAPE" TO 1;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT "/u02/test_df%t_s%s_s%p";
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE ENCRYPTION FOR DATABASE OFF;
CONFIGURE ENCRYPTION ALGORITHM "AES128";
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO "/u01/app/oracle/10.2.0/db/dbs/snapcf_test.f";
再来执行crosscheck backup命令正常执行：
RMAN> crosscheck backup;allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=145 devtype=DISKcrosschecked backup piece: found to be "AVAILABLE"
backup piece handle=/u02/test_df869734336_s15_s1 recid=5 stamp=869734336
crosschecked backup piece: found to be "AVAILABLE"
backup piece handle=/u02/test_df869734461_s16_s1 recid=6 stamp=869734463
Crosschecked 2 objects更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址