今天在配置data domain的时候，遇到点问题，数据库信息如下

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

PL/SQL Release 11.2.0.3.0 - Production

CORE 11.2.0.3.0 Production

TNS for Linux: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 - Production

Red Hat Enterprise Linux Server release 5.5 (Tikanga)

rman备份失败报错信息如下：

Starting backup at 10-APR-13

channel d1: starting full datafile backup set

channel d1: specifying datafile(s) in backup set

input datafile file number=00003 name=+DATA/finance/datafile/sysaux01.dbf

RMAN-03009: failure of backup command on d1 channel at 04/10/2013 10:24:37

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 d1: starting full datafile backup set

channel d1: specifying datafile(s) in backup set

提示BACKUP_TAPE_IO_SLAVES 参数不启用的时候会有问题

alter system set backup_tape_io_slaves = true deferred sid='*';

注：defferred说明修改只对本次会话之后的程序发生作用

再次执行rman备份脚本又出现错误

RMAN-03009: failure of backup command on d1 channel at 04/10/2013 14:52:42

ORA-19506: failed to create sequential file, name="201304108oo6o21g_1", parms=""

ORA-27028: skgfqcre: sbtbackup returned error

ORA-19511: Error received from media manager layer, error text:

sbtbackup: dd_rman_connect_to_backup_host failed

channel d1 disabled, job failed on it will be run on another channel

RMAN-03009: failure of backup command on d2 channel at 04/10/2013 14:52:42

ORA-19506: failed to create sequential file, name="201304108po6o21i_1", parms=""

经分析查找原因是由于hosts中主机名和域名解析有误导致，修改hosts后备份正常

网摘BACKUP_TAPE_IO_SLAVES 参数解释如下：

调整参数为：BACKUP_TAPE_IO_SLAVES=true

BACKUP_TAPE_IO_SLAVES指定了恢复管理器（Recovery Manager）所使用的从属进程的数目，这些从属进程被用来备份，拷贝或恢复数据到磁带上。当此参数为TRUE时，一个I/O从属进程被用来从磁带设备读取或写入数据。如果此参数为FALSE（默认情况下），在备份中不会使用I/O从属进程，而是由备份的阴影进程（shadow process）来存取磁带设备。

但是更改参数的时候无法成功提示错误：ORA-02096: specified initialization parameter is not modifiable with this option

查看Oracle的文档发现需要用 ALTER SYSTEM ... DEFERRED

加上deferred就不会报错了, 但是表示这次修改对当前会话不发生作用, 在以后打开的会话中起作用, 故它有"推迟"影响的效果.

alter system set backup_tape_io_slaves = true deferred;

ITPub博客

配置data domain遇到的问题

最新文章