设为首页收藏本站

Botang唐波's Oracle Station

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

2016-7-8 10:29| 发布者: admin| 查看: 109| 评论: 0

摘要: 更换服务器网卡后,Oracle Secure Backup在 rman备份恢复过程中,莫名其妙超时等待的解决方案
    这是一个令人抓狂的,耗费大量时间试验的悲惨经历。
    环境:
    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

鲜花

握手

雷人

路过

鸡蛋

刚表态过的朋友 (1 人)

QQ|手机版|Botang唐波's Oracle Station   

GMT+8, 2017-9-16 15:10 , Processed in 1.431018 second(s), 20 queries .

返回顶部