磁带双工备份报报ora-19565错误

郑全

当我执行磁带备份时,报以下错误:

 

RMAN> backup as backupset device type sbt copies 2 incremental level 0 database;

Starting backup at 03-MAY-13
using channel ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/oracle/app/oracle/oradata/sztech1/system01.dbf
input datafile file number=00002 name=/oracle/app/oracle/oradata/sztech1/sysaux01.dbf
input datafile file number=00005 name=/oracle/app/oracle/oradata/sztech1/example01.dbf
input datafile file number=00003 name=/oracle/app/oracle/oradata/sztech1/undotbs01.dbf
input datafile file number=00004 name=/oracle/app/oracle/oradata/sztech1/users01.dbf
RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 05/03/2013 11:08:15
ORA-19565: BACKUP_TAPE_IO_SLAVES not enabled when duplexing to sequential devices
continuing other job steps, job failed will not be re-run
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 05/03/2013 11:08:16
ORA-19565: BACKUP_TAPE_IO_SLAVES not enabled when duplexing to sequential devices

 

问题分析:

     看到上面错误:ora-19565,BACKUP_TAPE_IO_SLAVES参数没有启用,查看一下:

     

SQL> show parameter backup_

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
backup_tape_io_slaves                boolean     FALSE

 

 

      看来这个参数确实为false,修改为true

       alter system set backup_tape_io_slaves =true scope=spfile;

       startup force;

       重新进行备份,成功,如下:

      

RMAN> backup as backupset device type sbt copies 2 incremental level 0 database;

Starting backup at 03-MAY-13
using target database control file instead of recovery catalog
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=141 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/oracle/app/oracle/oradata/sztech1/system01.dbf
input datafile file number=00002 name=/oracle/app/oracle/oradata/sztech1/sysaux01.dbf
input datafile file number=00005 name=/oracle/app/oracle/oradata/sztech1/example01.dbf
input datafile file number=00003 name=/oracle/app/oracle/oradata/sztech1/undotbs01.dbf
input datafile file number=00004 name=/oracle/app/oracle/oradata/sztech1/users01.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 03-MAY-13
channel ORA_SBT_TAPE_1: finished piece 1 at 03-MAY-13 with 2 copies and tag TAG20130503T111242
piece handle=0so8mu5a_1_1 comment=API Version 2.0,MMS Version 10.4.0.2
piece handle=0so8mu5a_1_2 comment=API Version 2.0,MMS Version 10.4.0.2
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:03:55
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_SBT_TAPE_1: starting piece 1 at 03-MAY-13
channel ORA_SBT_TAPE_1: finished piece 1 at 03-MAY-13 with 2 copies and tag TAG20130503T111242
piece handle=0to8mucm_1_1 comment=API Version 2.0,MMS Version 10.4.0.2
piece handle=0to8mucm_1_2 comment=API Version 2.0,MMS Version 10.4.0.2
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:05
Finished backup at 03-MAY-13

杨芳超

学习了