问题描述
今天crosscheck backup发现报错,查了半天后来发现是因为配置了SBT_TAPE,而根本没有磁带的。
专家解答
RMAN> crosscheck backupset; using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=118 devtype=DISK released channel: ORA_DISK_1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of crosscheck command at 04/12/2011 13:07:31 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27211: Failed to load Media Management Library Additional information: 2 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; # default CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘%F’; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO ‘%F’; # default CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1; CONFIGURE DEVICE TYPE ‘SBT_TAPE’ BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK 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 SBT_TAPE TO 1; # default CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ‘%U’; 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/product/10.2.0/db_1/dbs/snapcf_orcl.f’; # default
虽然default的配置仍然是Disk,但可能因为配置了CONFIGURE DEVICE TYPE ‘SBT_TAPE’ BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;而加载时出现了问题。
RMAN> list backup; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ——- —- — ———- ———– ———— ————— 136 Full 3.64G DISK 00:05:17 24-2月 -11 BP Key: 136 Status: AVAILABLE Compressed: NO Tag: TAG20110224T094233 Piece Name: /rmanbackup/ORCL_194_1_20110224.bak List of Datafiles in backup set 136 File LV Type Ckp SCN Ckp Time Name —- — —- ———- ———- —- 1 Full 43681744 24-2月 -11 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_6cgckx95_.dbf 2 Full 43681744 24-2月 -11 3 Full 43681744 24-2月 -11 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_6cgckx9p_.dbf 4 Full 43681744 24-2月 -11 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_6cgckxds_.dbf 5 Full 43681744 24-2月 -11 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_6cgckxc7_.dbf 6 Full 43681744 24-2月 -11 /u01/app/oracle/oradata/ORCL/datafile/tt.dbf 7 Full 43681744 24-2月 -11 9 Full 43681744 24-2月 -11 /u01/app/oracle/oradata/ORCL/datafile/tt1.dbf 10 Full 43681744 24-2月 -11 BS Key Type LV Size Device Type Elapsed Time Completion Time ——- —- — ———- ———– ———— ————— 137 Full 76.00K DISK 00:00:03 24-2月 -11 BP Key: 137 Status: AVAILABLE Compressed: NO Tag: TAG20110224T094233 Piece Name: /rmanbackup/ORCL_195_1_20110224.bak List of Datafiles in backup set 137 File LV Type Ckp SCN Ckp Time Name —- — —- ———- ———- —- 8 Full 43681965 24-2月 -11 BS Key Type LV Size Device Type Elapsed Time Completion Time ——- —- — ———- ———– ———— ————— 138 Full 6.83M DISK 00:00:03 24-2月 -11 BP Key: 138 Status: EXPIRED Compressed: NO Tag: TAG20110224T163222 Piece Name: /home/oracle/c-1246063822-20110224-00.ctl Control File Included: Ckp SCN: 43696327 Ckp time: 24-2月 -11 SPFILE Included: Modification time: 24-2月 -11 BS Key Type LV Size Device Type Elapsed Time Completion Time ——- —- — ———- ———– ———— ————— 139 Full 3.64G DISK 00:05:06 24-2月 -11 BP Key: 139 Status: AVAILABLE Compressed: NO Tag: TAG20110224T163942 Piece Name: /rmanbackup/ORCL_%r_199_743963982_full_bak List of Datafiles in backup set 139 File LV Type Ckp SCN Ckp Time Name —- — —- ———- ———- —- 1 Full 43696725 24-2月 -11 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_6cgckx95_.dbf 2 Full 43696725 24-2月 -11 3 Full 43696725 24-2月 -11 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_6cgckx9p_.dbf 4 Full 43696725 24-2月 -11 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_6cgckxds_.dbf 5 Full 43696725 24-2月 -11 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_6cgckxc7_.dbf 6 Full 43696725 24-2月 -11 /u01/app/oracle/oradata/ORCL/datafile/tt.dbf 7 Full 43696725 24-2月 -11 9 Full 43696725 24-2月 -11 /u01/app/oracle/oradata/ORCL/datafile/tt1.dbf 10 Full 43696725 24-2月 -11 BS Key Type LV Size Device Type Elapsed Time Completion Time ——- —- — ———- ———– ———— ————— 140 Full 76.00K DISK 00:00:02 24-2月 -11 BP Key: 140 Status: AVAILABLE Compressed: NO Tag: TAG20110224T163942 Piece Name: /rmanbackup/ORCL_%r_200_743964298_full_bak List of Datafiles in backup set 140 File LV Type Ckp SCN Ckp Time Name —- — —- ———- ———- —- 8 Full 43696725 24-2月 -11 BS Key Type LV Size Device Type Elapsed Time Completion Time ——- —- — ———- ———– ———— ————— 141 Full 6.83M DISK 00:00:01 24-2月 -11 BP Key: 141 Status: EXPIRED Compressed: NO Tag: TAG20110224T164501 Piece Name: /home/oracle/c-1246063822-20110224-01.ctl Control File Included: Ckp SCN: 43696725 Ckp time: 24-2月 -11 SPFILE Included: Modification time: 24-2月 -11 BS Key Type LV Size Device Type Elapsed Time Completion Time ——- —- — ———- ———– ———— ————— 142 Full 6.83M DISK 00:00:01 11-3月 -11 BP Key: 142 Status: EXPIRED Compressed: NO Tag: TAG20110311T123632 Piece Name: /home/oracle/c-1246063822-20110311-00.ctl Control File Included: Ckp SCN: 43830934 Ckp time: 11-3月 -11 SPFILE Included: Modification time: 11-3月 -11 BS Key Type LV Size Device Type Elapsed Time Completion Time ——- —- — ———- ———– ———— ————— 143 Full 6.83M DISK 00:00:00 11-3月 -11 BP Key: 143 Status: EXPIRED Compressed: NO Tag: TAG20110311T123803 Piece Name: /home/oracle/c-1246063822-20110311-01.ctl Control File Included: Ckp SCN: 43830981 Ckp time: 11-3月 -11 SPFILE Included: Modification time: 11-3月 -11 BS Key Type LV Size Device Type Elapsed Time Completion Time ——- —- — ———- ———– ———— ————— 144 Full 6.83M DISK 00:00:00 11-3月 -11 BP Key: 144 Status: EXPIRED Compressed: NO Tag: TAG20110311T124211 Piece Name: /home/oracle/c-1246063822-20110311-02.ctl Control File Included: Ckp SCN: 43831067 Ckp time: 11-3月 -11 SPFILE Included: Modification time: 11-3月 -11 BS Key Type LV Size Device Type Elapsed Time Completion Time ——- —- — ———- ———– ———— ————— 145 Full 6.83M DISK 00:00:01 11-3月 -11 BP Key: 145 Status: EXPIRED Compressed: NO Tag: TAG20110311T124233 Piece Name: /home/oracle/c-1246063822-20110311-03.ctl Control File Included: Ckp SCN: 43831121 Ckp time: 11-3月 -11 SPFILE Included: Modification time: 11-3月 -11
根本没有什么sbt_tape介质。
RMAN> CONFIGURE CHANNEL DEVICE TYPE ‘SBT_TAPE’ clear; old RMAN configuration parameters are successfully deleted RMAN> crosscheck backupset; allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=118 devtype=DISK crosschecked backup piece: found to be ‘AVAILABLE’ backup piece handle=/rmanbackup/ORCL_194_1_20110224.bak recid=136 stamp=743938953 crosschecked backup piece: found to be ‘AVAILABLE’ backup piece handle=/rmanbackup/ORCL_195_1_20110224.bak recid=137 stamp=743939279 crosschecked backup piece: found to be ‘EXPIRED’ backup piece handle=/home/oracle/c-1246063822-20110224-00.ctl recid=138 stamp=743963545 crosschecked backup piece: found to be ‘AVAILABLE’ backup piece handle=/rmanbackup/ORCL_%r_199_743963982_full_bak recid=139 stamp=743963982 crosschecked backup piece: found to be ‘AVAILABLE’ backup piece handle=/rmanbackup/ORCL_%r_200_743964298_full_bak recid=140 stamp=743964298 crosschecked backup piece: found to be ‘EXPIRED’ backup piece handle=/home/oracle/c-1246063822-20110224-01.ctl recid=141 stamp=743964302 crosschecked backup piece: found to be ‘EXPIRED’ backup piece handle=/home/oracle/c-1246063822-20110311-00.ctl recid=142 stamp=745504593 crosschecked backup piece: found to be ‘EXPIRED’ backup piece handle=/home/oracle/c-1246063822-20110311-01.ctl recid=143 stamp=745504683 crosschecked backup piece: found to be ‘EXPIRED’ backup piece handle=/home/oracle/c-1246063822-20110311-02.ctl recid=144 stamp=745504931 crosschecked backup piece: found to be ‘EXPIRED’ backup piece handle=/home/oracle/c-1246063822-20110311-03.ctl recid=145 stamp=745504954 Crosschecked 10 objects
成功
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。