Bo's Oracle Station › 博客首页 ›Oracle技术› 开发和基础管理 › 查看内容

【博客文章2016】更换服务器网卡后，Oracle Secure Backup在 rman备份恢复过程中，莫名其妙超时等待的解决方案

2016-7-8 10:29| 发布者: admin| 查看: 229| 评论: 0|原作者: Bo Tang

摘要: 更换服务器网卡后，Oracle Secure Backup在 rman备份恢复过程中，莫名其妙超时等待的解决方案

Author: Bo Tang

这是一个令人抓狂的，耗费大量时间试验的悲惨经历。
    环境：
    RedHat linux 5.4
    Oracle Database Enterprise Edition 11.2.0.3
    Oracle Secure Backup 10.3.0.3.0
    MHVTL虚拟带库
    场景一（两年以前）：
    【问题】obtool命令等很久不出提示符
    【有效解决方案】/etc/resolv.conf把nameserver设置成能正确解析"obtool lshost"名字的nameserver
    【无效解决方案】/usr/local/oracle/backup/admin/state 全删除，chmod 777 /usr/tmp

    场景二（最近）：
    【问题】更换服务器网卡后，Oracle Secure Backup在 rman备份恢复过程中，莫名奇妙超时等待

channel ORA_SBT_TAPE_5: Oracle Secure Backup

allocated channel: ORA_SBT_TAPE_6

channel ORA_SBT_TAPE_6: SID=132 device type=SBT_TAPE

channel ORA_SBT_TAPE_6: Oracle Secure Backup

allocated channel: ORA_SBT_TAPE_7

channel ORA_SBT_TAPE_7: SID=194 device type=SBT_TAPE

channel ORA_SBT_TAPE_7: Oracle Secure Backup

allocated channel: ORA_SBT_TAPE_8

channel ORA_SBT_TAPE_8: SID=13 device type=SBT_TAPE

channel ORA_SBT_TAPE_8: Oracle Secure Backup

channel ORA_SBT_TAPE_1: starting datafile backup set restore

channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set

channel ORA_SBT_TAPE_1: restoring datafile 00005 to /home/oracle/examplettio.dbf

channel ORA_SBT_TAPE_1: reading from backup piece 16q8flha_1_1

......

抓狂等5个小时不出来，换网卡前3分钟的事情。

ob> lshost -l
station90:
    Access mode:            OB
    IP names:               2400:dd01:2001:1:ba88:e3ff:fe5b:3b80,station90.example.com,159.226.150.106,cracker90.cracker.org,server90.example.com,cracker253.cracker.org,subserver1.subdomain1.example.com,172.16.205.1,172.16.122.1
    TCP/IP buffer size:     not set (global policy)
    Algorithm:              aes192
    Encryption policy:      allowed
    Rekey frequency:        1 month
    Key type:               transparent
    In service:             yes
    Roles:                  admin,mediaserver,client
    Trusted host:           yes
    Certificate key size:   1024
    UUID:                   fed0d14e-cf1a-1030-a87c-b888e35b3b80

【有效解决方案】

ob> chhost -i station90.example.com,159.226.150.106,cracker90.cracker.org,server90.example.com,cracker253.cracker.org,subserver1.subdomain1.example.com,172.16.205.1,172.16.122.1 station90
ob>

canceljob后，重新执行
oracle/225.1     none        restore piece '16q8flha_1_1'   running since 2016/07/08.10:27
ob> lsjob
Job ID           Sched time Contents                       State
---------------- ----------- ------------------------------ ---------------------------------------
oracle/225       none        database orcl (dbid=1343950367) processed; Oracle job(s) scheduled
oracle/225.1     none        restore piece '16q8flha_1_1'   running since 2016/07/08.10:27
ob> lsjob
ob> lsjob
ob> lsjob
ob> lsjob
ob> lsjob
ob>

几分钟就结束了！！！！
【无效解决方案】升级OSB10.4.0.4, OSB12.1.0.2等等

还要注意一下以上chhost的更改，反映到以下的配置文件是否同步更改：/usr/etc/ob/.hostid
例子：
my host uuid:               676f8e8e-20d4-1035-bce5-54ee75212a2c
admin host uuid:            676f8e8e-20d4-1035-bce5-54ee75212a2c
admin host ip:              station90.example.com
cert key size:              1024
distinguished name:         CN=676f8e8e-20d4-1035-bce5-54ee75212a2c,O=Oracle,C=US

路过

雷人

握手

鲜花

鸡蛋

刚表态过的朋友 (1 人)

lujiaguai

收藏邀请

上一篇：【视频2016】近期11g OCP我的课堂录屏回放：Win32平台数据库迁移Linux64平台后续---升级Standalone Grid Infrastructure到11.2.0.3下一篇：【博客文章2016】12c 多租户体系结构新特性，我们应该了解的内容系列一