重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: 磁带双工备份报报ora-19565错误 [打印本页]

作者: 郑全 时间: 2013-5-3 11:18
标题: 磁带双工备份报报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

作者: 杨芳超 时间: 2013-5-3 13:40
学习了

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)