ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 配置data domain遇到的问题

配置data domain遇到的问题

原创 Linux操作系统 作者:marvinoracle 时间:2013-04-12 09:11:46 0 删除 编辑

今天在配置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博客 ” ,链接:http://blog.itpub.net/24531354/viewspace-758329/,如需转载,请注明出处,否则将追究法律责任。

下一篇: oracle10安装图解
请登录后发表评论 登录
全部评论

注册时间:2010-09-02

  • 博文量
    67
  • 访问量
    181767